INDEX & MATCH
Flexible lookups and two-way matching
Learning path 03
Make complexity useful.
Build repeatable workflows, explore dynamic formulas and turn messy data into decisions.
Confident with lookups and PivotTables12 lessons in the curriculum12 available now
Advanced XLOOKUP
Multiple criteria and search modes
Dynamic array foundations
Understand spilling and array behavior
FILTER, SORT & UNIQUE
Create live views of your data
Readable formulas with LET
Name and reuse intermediate results
Reusable functions with LAMBDA
Build your own formula functions
Power Query foundations
Import, clean and refresh data
Clean, merge & append
Create repeatable transformations
Advanced PivotTables
Grouping, slicers and calculated fields
The data model
Relationships, measures and DAX basics
Design a useful dashboard
Choose KPIs, layout and interactions
Project: inventory decisions
Analyze service, stock and exceptions