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
Practical Excel Automation and Macros
Data and Business Intelligence|3 days|Classroom or live online
This is a hands-on programme. Delegates spend most of the time working through visual encoding choices and scenario modelling on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: analysts are frequently self taught in the tool and untrained in the reasoning, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with SQL querying, DAX and calculated measures and report automation in their own organisation.
What delegates leave able to do
- Spot where SQL querying is failing before it becomes a finding, measured against recognised data governance frameworks
- Make a decision about DAX and calculated measures without waiting for a specialist
- Put report automation on a footing they can defend to a reviewer
- Bring self service analytics into line with current good practice
What the course covers
- Visual encoding choices
- Scenario modelling
- SQL querying
- DAX and calculated measures
- Report automation
- Self service analytics
- Dashboard design
Who should attend
- team leaders responsible for KPIs
- data analysts
- management information officers
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
| 26 to 28 Oct 2026 | Durban | R13 000 |
| 18 to 20 Jan 2027 | Pretoria | R13 000 |
| 1 to 3 Mar 2027 | Johannesburg | R13 000 |
| 19 to 21 Apr 2027 | Johannesburg | R13 000 |
| 17 to 19 May 2027 | Durban | R13 000 |
| 21 to 23 Jun 2027 | Online | USD 900 |
| 2 to 4 Aug 2027 | Dubai | USD 1 500 |
| 13 to 15 Sep 2027 | Kampala | USD 1 500 |
| 25 to 27 Oct 2027 | Online | USD 900 |
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)