Styles
Working with data
-
Working with external data (5:46)
-
Advanced filters (4:22)
-
Data validation numbers part 1 (3:40)
-
Data validation numbers part 2 (6:11)
-
Data validation lists (2:42)
-
Data validation other (3:42)
-
Consolidate data (6:45)
-
What if analysis goal seek (3:58)
-
What if analysis scenario manager part 1 (3:14)
-
What if analysis scenario manager part 2 (5:19)
-
What if analysis data table (4:00)
-
Working with outlines group (6:05)
-
Working with outlines subtotal (3:22)
The famous IF function
Vlookup function
Other common functions
Pivot tables
Charts
Protecting your work
Introducing macros
