A complete Excel training programme — from formulas and functions through to PivotTables, data analysis and advanced Excel. Delivered by an MCT with 17+ years of enterprise training experience.
Practical, measurable outcomes from Day 1.
VLOOKUP, XLOOKUP, IF, SUMIFS, COUNTIFS, INDEX-MATCH — the essential toolkit for any analyst.
Summarise 100,000 rows in seconds — drill down, group by date, add calculated fields.
Right chart for the data, formatting for impact, sparklines and dynamic charts.
Remove duplicates, text functions, Flash Fill — turn messy data into clean data fast.
Dropdown lists, input restrictions, conditional formatting, sheet and workbook protection.
Power Query introduction, What-If Analysis, Goal Seek, Scenario Manager and data tables.
Build reports, financial models and dashboards with confidence — faster and more accurately.
Maintain trackers, automate attendance, analyse operational data with PivotTables.
Start from scratch and reach a level where Excel becomes a core professional skill.
Advance beyond basic formulas to PivotTables, functions and data analysis techniques.
All modules — practical, hands-on labs throughout.
Trainer travels to your location. Ideal for teams of 8–25 — maximum focus, zero travel cost for participants.
Instructor-led training via Microsoft Teams with screen share and hands-on labs. Full trainer interaction throughout.
Split across 2–3 half-days to minimise business disruption. Same content, more flexible scheduling.
Tell us your team size and current level. We'll design the right programme for your organisation.
Practice files based on your industry's actual data and reports
Beginner, Intermediate or Advanced — curriculum adapted to your team
Printable formula cheat sheets and keyboard shortcut guides included