1 Get to know Excel
Menus and settings
Worksheets
The Status Bar
Help
2 Basic functionality
Insert data
Navigate with the mouse
Navigate with the keyboard
Undo and Redo
Comments and Annotations
Save
3 Working with formulas
Create formulas
Create a function
Copy formulas
Complicated formulas
Absolute and Relative Cell References
AutoSum
Insert Function
4 Formatting
Visual formatting
Date and time
Format numbers
Conditional Formatting
Format table
5 Worksheet basics
Insert and Delete Rows and Columns
Hide and Unhide Rows and Columns
Move and Copy Data
Paste
Find and Replace
6 Printing
7 Charts
8 Worksheet overview
Freeze panes
Split windows
Grouping rows and columns
9 Manage multiple workbooks
Linking worksheets and workbooks
Manage links
Displaying multiple worksheets
10 Functions
The IF-function
Vlookup
CountIF
SumIF
AverageIF
Hlookup
Nested IF-functions
IFerror
Date functions
Text functions
XLOOKUP
Combine Functions
11 Security and sharing
Protect the worksheet
Protect the workbook
Password for workbooks
12 Working with databases
13 PivotTables
Create a PivotTable
Working with a PivotTable
Filter and slicer
Insert a PivotChart
Grouping by time
Grouping rows and columns
Refresh the PivotTable
Change data source
Create PivotTables with multiple data sources (Power Pivot)
14 Goal Seek and Macros
Goal seek
Create a Macro
Create shortcut for macro
Manage and remove macros
Create a Database
Share
Share "Create a Database"
Share a link to someone who will get access to this lesson for 24 hours.
Share "Create a Database"
Share a link to someone who will get access to this lesson for 24 hours.