Excel for Analysts: Zero to Confident
Master formulas, lookups, pivot tables and charts by building four real reports.
- Welcome and the Excel mindset
- Formulas that matter: SUM, IF, XLOOKUP
- Pivot tables in 20 minutes
- Charts and your first dashboard
Formulas that matter: SUM, IF, XLOOKUP
Use absolute references ($A$1) when a cell must not move. XLOOKUP replaces VLOOKUP and looks left or right.
=XLOOKUP(A2, Prices[Item], Prices[Price], "Not found")
Log in to track progress and earn a certificate.