Print this page or save it as a PDF to circulate internally.
Back to the course
Executive and professional training
305 Glenwood Road, Faerie Glen, Pretoria, South Africa
069 221 6943
info@isptrainings.co.za
Excel Automation and Macros
Data and Business Intelligence|3 days|Classroom or live online
This Excel Automation and Macros programme gives delegates a working command of statistical fundamentals and pivot table analysis, grounded in dimensional modelling practice. Organisations invest here because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with visual encoding choices, KPI definition and scenario modelling in their own organisation.
What delegates leave able to do
- Spot where visual encoding choices is failing before it becomes a finding, measured against dimensional modelling practice
- Bring KPI definition into line with current good practice
- Make a decision about scenario modelling without waiting for a specialist
- Explain DAX and calculated measures to someone who does not do the work
What the course covers
- Statistical fundamentals
- Pivot table analysis
- Visual encoding choices
- KPI definition
- Scenario modelling
- DAX and calculated measures
- Forecasting techniques
Who should attend
- professionals moving into analytics
- business analysts
- data analysts
Fees
| South Africa | R13 000 |
| Elsewhere in Africa and the Gulf | USD 1 500 |
| Live online | USD 900 |
Per delegate, for the full 3 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
| 16 to 18 Nov 2026 | Johannesburg | R13 000 |
| 4 to 6 Jan 2027 | Johannesburg | R13 000 |
| 15 to 17 Feb 2027 | Nairobi | USD 1 500 |
| 22 to 24 Mar 2027 | Online | USD 900 |
| 3 to 5 May 2027 | Windhoek | USD 1 500 |
| 7 to 9 Jun 2027 | Durban | R13 000 |
| 12 to 14 Jul 2027 | Johannesburg | R13 000 |
| 23 to 25 Aug 2027 | Johannesburg | R13 000 |
| 20 to 22 Sep 2027 | Gaborone | USD 1 500 |
| 1 to 3 Nov 2027 | Cairo | USD 1 500 |
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)