Level 1 – Discover

Understanding Excel 
The menu & ribbon
Workbook
Worksheet
Saving

Navigating with keyboard    
Navigating
ALT key

Working with cells    
Cell
Right mouse click
Entering text or numbers
Cell formatting 1
Format cells options 1
Data types 1

Basic of Calculating  
Calculating with Excel
Get dynamic
References
Error Message 1
F2 key
Copying and pasting within Excel

Starting to work with formulas
Calculating within Excel (input cells)
F4/absolute reference (one input cell)
Formula bar
Formula Entry & Help
Math formulas (SUM, Count, Average)
Calculation tips

Handling large dataset
Selecting  data (Ctrl+shift)
Finding entries Ctrl+ F
Filtering
Sorting

General  
Best practices with Save
Printing
Shortcuts & Practice

Go back to overview