Getting Started with Excel ✓
Learn your way around the Excel 2016 environment.
Understanding OneDrive ✓
Learn all about working with your Microsoft account and OneDrive.
Creating and Opening Workbooks ✓
Learn how to create and open Excel workbooks.
Saving and Sharing Workbooks ✓
Learn how to save and share Excel workbooks.
Modifying Columns, Rows, and Cells ✓
Learn how to modify rows, columns, and cells in Excel.
Formatting Cells ✓
Learn all about formatting text in Excel.
Understanding Number Formats ✓
Learn all about formatting numbers in Excel.
Working with Multiple Worksheets ✓
Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
Using Find & Replace ✓
Learn how to use Excel's Find and Replace features to search for specific data.
Checking Spelling ✓
Learn how to use Excel's spell check feature.
Page Layout and Printing ✓
Learn how to use Excel commands that let you control the way your content will appear on a printed page.
Intro to Formulas ✓
Learn how to use cell references to create a simple formula in Excel.
Creating More Complex Formulas ✓
Learn how to create a complex formula in Excel.
Relative and Absolute Cell References ✓
Learn all about absolute and relative cell references and how they're used in Excel.
Basic Tips for Working with Data ✓
Learn these basic tips for working with data to help you organize it and find what you need.
Freezing Panes and View Options ✓
Learn how to freeze panes and split your worksheet so you're only seeing certain parts of your worksheet.
Conditional Formatting ✓
Learn how to apply, modify, and delete conditional formatting rules in Excel.
Track Changes and Comments ✓
Learn how to use Excel's track changes and comments features when proofreading workbooks.
Inspecting and Protecting Workbooks ✓
Learn how to inspect and protect your Excel workbook.
Intro to PivotTables ✓
Learn how to use PivotTables in Excel for stronger data analysis.
Doing More with PivotTables ✓
Learn how to do more with PivotTables in Excel to better summarize data.
What-if Analysis ✓
Learn how to use what-if analysis to answer different types of questions.