Trainings
Advanced Excel for Financial Modeling
Excel for people who build or review financial models: clean structure, formulas that audit easily, and scenarios a decision-maker can follow.
Built for finance and accounts teams who already work in Excel and want models that hold up when someone else opens them.
What we cover
- Laying out a model so inputs, workings and outputs stay separate
- Lookups, INDEX and MATCH, and XLOOKUP across linked sheets
- Building three-statement links and checks that flag when something doesn't tie
- Scenario and sensitivity analysis with data tables
- Error-proofing: named ranges, validation and audit tools
- Presenting results in a one-page summary a promoter can read
Taught on your own models where possible, by a Chartered Accountant.