Choose “Save as PDF” as the destination to email Advanced Excel Modelling and Analytics to a client.
EasyUphill
CORPORATE DEVELOPMENT
+27 81 041 7673
training@eubiz.co.za
68 Sunstone Street, Germiston, 1401
eubiz.co.za
training@eubiz.co.za
68 Sunstone Street, Germiston, 1401
eubiz.co.za
Data & Analytics
Advanced Excel Modelling and Analytics
Duration
5 Days
Delivery
In-house, public or online
From
R18,000 per delegate
Certificate
On completion
Course overview
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.
What you will be able to do
- 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
Course outline
01
Building complex formulas with nested and combined functions
02
Using dynamic arrays and advanced lookup techniques
03
Analysing data with Power Query and the data model
04
Constructing financial and scenario models with assumptions
05
Running what-if analysis, goal seek and data tables
06
Automating repetitive tasks with recorded and edited macros
07
Building error checks and controls into a large model
Upcoming public sessions
| Dates | Venue | Duration | Fee per delegate |
|---|---|---|---|
| 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 exclude VAT. This course can also be delivered in-house at your premises on dates that suit your team, or live online.
To book or ask for an in-house quote
Reply to the email this brochure came with, call +27 81 041 7673, or visit eubiz.co.za and open this course.
EasyUphill Training & ConsultingTailored training that moves teams forward.
+27 81 041 7673 · training@eubiz.co.za
68 Sunstone Street, Germiston, 1401 · eubiz.co.za
68 Sunstone Street, Germiston, 1401 · eubiz.co.za