Anyone who already builds spreadsheets and now maintains them for other people.
Excel — Intermediate
Move from typing numbers to modelling them. Lookups, pivot tables and structured tables that update themselves instead of breaking every month.
What we cover
- Structured tables and named ranges
- XLOOKUP, INDEX/MATCH and the end of VLOOKUP
- PivotTables, slicers and grouping
- Date, text and logical function families
- Data validation and protecting your inputs
- Conditional formatting driven by formulas
- Auditing and tracing broken workbooks
Who it is for
What you need first
Comfortable with basic formulas and cell references.
Would this suit your whole team?
We run Excel — Intermediate privately, at your offices or online, built around your own files.