Advanced Excel Modelling and Analytics
This advanced programme extends Excel into serious analysis and modelling. Participants master complex formulas, data tools, and modelling techniques that turn Excel into a capable analytics environment.
Course outline
What this programme covers, module by module.
- 01Building complex formulas with nested and combined functions
- 02Using dynamic arrays and advanced lookup techniques
- 03Analysing data with Power Query and the data model
- 04Constructing financial and scenario models with assumptions
- 05Running what-if analysis, goal seek and data tables
- 06Automating repetitive tasks with recorded and edited macros
- 07Building error checks and controls into a large model
What you will gain
- Build complex formulas with nested functions
- Use dynamic arrays and advanced lookups
- Analyse data with Power Query and the data model
- Build financial and scenario models
- Run what-if analysis and goal seeking
- Automate tasks with macros
Who should attend
- Experienced Excel users
- Financial and business analysts
- Planning and modelling staff
- Anyone building analytical models
Upcoming sessions
| Date | City | Duration | Fees | Book |
|---|---|---|---|---|
| 9 to 13 Nov 2026 | Durban | 5 Days | R18,000 | |
| 23 to 27 Nov 2026 | Cape Town | 5 Days | R18,000 | |
| 7 to 11 Dec 2026 | Johannesburg | 5 Days | R18,000 | |
| 11 to 15 Jan 2027 | London | 5 Days | US$1,800 | |
| 1 to 5 Mar 2027 | Dubai | 5 Days | US$1,800 | |
| 10 to 14 May 2027 | Pretoria | 5 Days | R18,000 | |
| 19 to 23 Jul 2027 | Durban | 5 Days | R18,000 |
Fees are per delegate and exclude VAT. Public intakes are confirmed once minimum numbers are met. We also deliver this course on your own schedule, in-house or live online.
Enquire about this course
Register your team or ask for a tailored in-house quote. We reply within one working day.
WhatsApp usCourse brochure (PDF)- Fees from
- R18,000 per delegate
- Duration
- 5 Days
- Field
- Data & Analytics
- Formats
- In-house, public, online
More in Data & Analytics
Data Analysis and Visualisation with Excel
Excel remains the most widely used analysis tool in business, and few use it to its full potential. This course takes participants beyond basic formulas into structured analysis, PivotTables, and clear charts that reveal what the numbers mean.
Power BI for Business Intelligence and Reporting
Power BI turns scattered data into interactive reports that decision-makers can explore for themselves. This course guides participants from connecting data sources through building models to publishing dashboards that stay current.
Introduction to Data Analytics for Decision Making
This course demystifies data analytics for professionals who need to use data but are not specialists. Participants learn how to ask the right questions, interpret results, and use evidence to support better decisions.