Start Learning
Advanced 5 lessons

Advanced Excel

XLOOKUP, INDEX/MATCH, dynamic arrays, advanced PivotTables, and your first macro.

Your Progress 0 of 5 complete
  1. 1 XLOOKUP Deep Dive
    Everything VLOOKUP could do, and several things it couldn't — the modern standard for lookups.     Advanced 10 min
  2. 2 INDEX and MATCH Combined
    The classic, version-proof alternative to VLOOKUP and XLOOKUP alike.     Advanced 11 min
  3. 3 Dynamic Arrays: FILTER, SORT, and UNIQUE
    Three newer functions that can return many results from a single formula, spilling automatically into nearby cells.     Advanced 13 min
  4. 4 PivotTables for Advanced Analysis
    Calculated fields, grouping, and slicers — going beyond a basic PivotTable summary.     Advanced 12 min
  5. 5 Introduction to Macros
    Record a repetitive task once, then replay it with a single click forever after.     Advanced 10 min