Excel Lessons
Practical, step-by-step Excel lessons — from the basics through advanced data analysis.
Sorting and Filtering Data
Put your data in order, and hide the rows you don't need to see right now.
Read lesson →Understanding Cell References: Relative vs. Absolute
Why copying a formula sometimes breaks it — and how a dollar sign fixes that.
Read lesson →Creating Your First Chart
Turn a table of numbers into a chart that's actually easy to read at a glance.
Read lesson →The COUNT and COUNTA Functions
Count how many cells actually have something in them — numbers, or anything at all.
Read lesson →Freezing Panes and Printing Your Worksheet
Keep your headers visible while you scroll, and get a printed page that actually looks right.
Read lesson →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 →XLOOKUP Deep Dive
Everything VLOOKUP could do, and several things it couldn't — the modern standard for lookups.
Read lesson →INDEX and MATCH Combined
The classic, version-proof alternative to VLOOKUP and XLOOKUP alike.
Read lesson →