Why the spreadsheet was invented
Key concepts used to create Excel solutions
The structure of Excel files and worksheets
Keyboard keys and shortcuts
Worksheet efficiency tricks
Worksheet formulas, formatting, and setup to solve problems
A golden rule for building Excel models
Knowing when to use the ROUND function
Date and time number formatting and formulas
Worksheet formula types and formula elements
Logical tests and related functions (AND, ISNUMBER, IF, IFS, FILTER, SUMIFS, and more)
Worksheet lookup functions and formulas
Worksheet array formulas: just enter!
The LET and LAMBDA functions
Data analysis basics: standard pivot tables, sorting, filtering, visualizations, and more
Advanced data analysis with power query, power pivot, power BI, M code, and DAX
Data analysis examples: big data and complex data analysis
The macro recorder and the VBA editor
Financial worksheet functions
Simple linear regression worksheet functions