Advanced Excel Automation and Macros

Data and Business Intelligence|5 days|Classroom or live online

This advanced programme assumes delegates already work in the field. It goes past the basics into storytelling with data, KPI definition and the judgement calls that sit outside dimensional modelling practice. At this level the constraint is rarely knowledge. It is judgement under pressure, which matters because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with dashboard design, forecasting techniques and self service analytics in their own organisation.

What delegates leave able to do

Make a decision about dashboard design without waiting for a specialist, measured against dimensional modelling practice
Bring forecasting techniques into line with current good practice
Review self service analytics and say plainly whether it is working
Put DAX and calculated measures on a footing they can defend to a reviewer

What the course covers

Storytelling with data
KPI definition
Dashboard design
Forecasting techniques
Self service analytics
DAX and calculated measures
Spreadsheet controls

Who should attend

reporting specialists
finance professionals building reports
professionals moving into analytics
business analysts
data analysts

Fees

South Africa	R18 000
Elsewhere in Africa and the Gulf	USD 1 800
Live online	USD 900

Per delegate, for the full 5 days. Covers tuition, course materials and refreshments. Excludes travel and accommodation. South African courses carry VAT at 15%; on deliveries outside South Africa the VAT position is confirmed on the quotation, because it depends on where your organisation is registered.

Scheduled dates

12 to 16 Oct 2026	Accra	USD 1 800
9 to 13 Nov 2026	Cape Town	R18 000
8 to 12 Feb 2027	Kampala	USD 1 800
15 to 19 Mar 2027	Pretoria	R18 000
12 to 16 Apr 2027	Pretoria	R18 000
17 to 21 May 2027	Online	USD 900
5 to 9 Jul 2027	Dar es Salaam	USD 1 800
2 to 6 Aug 2027	Kampala	USD 1 800
6 to 10 Sep 2027	Pretoria	R18 000
18 to 22 Oct 2027	Dar es Salaam	USD 1 800
29 Nov to 3 Dec 2027	Durban	R18 000

Dates are the published schedule at the time this page was printed. We also run this programme on request, and in-house for a full team.

How to book

Call 069 221 6943 or email info@isptrainings.co.za with the date and the number of delegates. We reply with a written quotation and an invoice. A registration is not a confirmed booking until we confirm it in writing.

Innovative Special Projects|Monday to Friday, 08:00 to 18:00 (SAST)