Intermediate
5 lessons
Intermediate Excel
PivotTables, VLOOKUP, data validation, nested logic, and named ranges.
-
1
PivotTables Basics
Summarize hundreds of rows of raw data into a clean, cross-tabulated summary in a few clicks. Intermediate 10 min -
2
VLOOKUP in Practice
A real, working example of the lookup function every intermediate Excel user needs to know. Intermediate 9 min -
3
Data Validation
Stop bad data before it gets entered, with dropdown lists and input rules. Intermediate 8 min -
4
Nested IF Statements
Go beyond a simple yes/no with multiple conditions chained together. Intermediate 9 min -
5
Named Ranges
Replace confusing cell references like $D$1 with a plain-English name. Intermediate 7 min