Mastering Microsoft® Excel® for Office 365® Level 100

In this lesson, you’ll learn the fundamentals of Excel — not the basics of Office.

• Recognize the Excel interface
• Discuss how to employ the 3 layers and 3 rules of worksheets
• Input basic numbers, text and formulas
• Use the Help feature while you work

In this lesson, you’ll learn to work more effectively and efficiently with Excel. You’ll also learn essential data entry shortcuts.

• Identify essential shortcuts to rapidly generate text, numbers and formulas
• Describe formatting cells with styles
• Identify how to solve printing problems
• Discuss the steps to generate a well-structured workbook

In this lesson, you’ll learn the essentials of tables for data input and PivotTable reports for effective data output.

• Recognize the difference between reports, crosstabs and tables
• Build a table
• Work with tables
• Describe how to master the basics of PivotTable reports

In this lesson, you’ll learn how to write a formula and how to use built-in functions to streamline complicated formulas.

• Write formulas with relative and absolute cell references
• Build formulas with cell references, rather than fixed values
• Audit workbooks with formulas to troubleshoot errors
• Use tables to simplify absolute and relative cell references

In this module, you’ll begin expanding your Excel repertoire by learning the most commonly needed Excel functions.

• Explain text functions
• Describe the family of IF functions
• Discuss XLOOKUP, the replacement for VLOOKUP, INDEX and MATCH
• Define logical formulas (TRUE/FALSE)
• Understand dynamic array functions

In this lesson, you’ll explore the methods of formatting a workbook using shortcuts, styles, formulas and functions.

• Format quickly with the format painter
• Recognize the use of formatting styles
• Format with conditional formatting
• Identify formatting using formulas and conditional formatting