43
The Excel Window
The Ribbon
Insert data and undo/redo
Navigate and select in worksheet
Horizontal scroll
Create formulas
Create functions
AutoSum
Cut and Copy formulas
Absolute and Relative Cell References
Format characters, borders and alignment
Format numbers
Custom formatting
Format painter
Conditional Formatting
Handle Rows and Columns
Move, copy and paste data
Find and Replace
Printing essentials
Freeze panes
Grouping rows and columns
Protect worksheet and workbook
Create chart
Format chart
IF
IFS
IFERROR
SUBTOTAL
COUNTIFS, SUMIFS
XLOOKUP
Date functions
Text functions
Manage multiple sheets
Working with tables
Sort
Filter
Flash Fill
Duplicates
Data Validation
Create a PivotTable
Working with a PivotTable
Filter and slicers
Pivot charts
Get started!
