Exploring the Ribbon
Understanding the Quick Access Toolbar
The Formula Bar
Understanding Backstage View
Understanding the Workbook
Selecting Cells
Moving Around a Sheet
Adding/Deleting Sheets
Hiding/Unhiding Sheets
Worksheet Tab Colors
Entering Data in Excel
Using the AutoFill Feature
Custom Lists for AutoFill
Flash Fill for Data Entry
Data Validation Basics
Relative Cell References
Absolute Cell References
Mixed Cell References
Practical Cell Reference
3D Cell References
Inserting Rows & Columns
Deleting Rows & Columns
Modifying Cell Size
Inserting and Deleting Cells
Hiding/Unhiding
Number Formatting
Text Formatting
Cell Formatting
Date Formatting
Using Themes
Highlight Cells Rules
Top/Bottom Rules
Data Bars
Color Scales
Icon Sets
Understanding Formulas
Arithmetic Operators
Cell References
Absolute References
Mixed References
SUM Function
AVERAGE Function
MIN and MAX Functions
COUNT Function
Function Arguments
Creating Worksheets
Renaming Worksheets
Deleting Worksheets
Worksheet Tabs
Moving/Copying Sheets
3D Formulas Intro
Creating 3D Formulas
Referencing Ranges
3D Formula Editing
3D Formula Best Practices
Introduction to Sorting
Sorting by Multiple Cols
Custom Sorting
Intro to Filtering
Advanced Filtering
Chart Types
Creating Column Charts
Creating Bar Charts
Creating Line Charts
Creating Pie Charts
Chart Elements
Formatting Charts
Page Setup Options
Print Preview
Printing Worksheets
Track Changes Intro
Reviewing Changes
Working with Comments
Showing/Hiding Comments
Sharing Workbooks
Dynamic Arrays
XLOOKUP Function
Co-Authoring Enhancements
Data from Picture
Ideas Feature