From VLOOKUP to Power Query, financial modeling, and VBA automation. Master pivot tables, dynamic arrays with XLOOKUP/FILTER, dashboard design, DCF models with scenario analysis, Power Query ETL, and macros that automate hours of work.
1-month free Pro trial included
Cell references, formula types, VLOOKUP vs XLOOKUP, IF logic, text functions, and the Excel mental model that makes everything else click
Pivot tables from beginner to advanced, Power Query for ETL, dynamic arrays, and building executive dashboards
Dynamic ranges with OFFSET and INDIRECT, array formulas, LET, LAMBDA, XLOOKUP, and building formula-driven models
Choose the right chart type, build interactive dashboards with slicers and form controls, sparklines, conditional formatting, and data storytelling principles
Import, clean, reshape, and combine data from multiple sources automatically with Power Query — the Excel feature that replaces hours of manual data wrangling
Build 3-statement financial models, DCF valuation, scenario analysis with Data Tables, Goal Seek, Solver, and the best practices used by investment banks
Record and write VBA macros, automate repetitive tasks, build custom functions, create user forms, and protect/distribute Excel workbooks
