Excel Lessons
Practical, step-by-step Excel lessons — from the basics through advanced data analysis.
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 →Dynamic Arrays: FILTER, SORT, and UNIQUE
Three newer functions that can return many results from a single formula, spilling automatically into nearby cells.
Read lesson →PivotTables for Advanced Analysis
Calculated fields, grouping, and slicers — going beyond a basic PivotTable summary.
Read lesson →Introduction to Macros
Record a repetitive task once, then replay it with a single click forever after.
Read lesson →