Excel Lessons
Practical, step-by-step Excel lessons — from the basics through advanced data analysis.
PivotTables Basics
Summarize hundreds of rows of raw data into a clean, cross-tabulated summary in a few clicks.
Read lesson →VLOOKUP in Practice
A real, working example of the lookup function every intermediate Excel user needs to know.
Read lesson →Data Validation
Stop bad data before it gets entered, with dropdown lists and input rules.
Read lesson →Nested IF Statements
Go beyond a simple yes/no with multiple conditions chained together.
Read lesson →Named Ranges
Replace confusing cell references like $D$1 with a plain-English name.
Read lesson →