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
Strategic Excel Automation and Macros
Data and Business Intelligence|5 days|Classroom or live online
Strategic Excel Automation and Macros looks at this work from the level at which it is resourced and defended. The focus is on pivot table analysis, forecasting techniques and how both connect to what the organisation is actually trying to achieve. This matters at the strategic level because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with SQL querying, self service analytics and visual encoding choices in their own organisation.
What delegates leave able to do
- Explain SQL querying to someone who does not do the work, measured against recognised data governance frameworks
- Put self service analytics on a footing they can defend to a reviewer
- Improve visual encoding choices within their own organisation
- Take ownership of dashboard design rather than escalating it
What the course covers
- Pivot table analysis
- Forecasting techniques
- SQL querying
- Self service analytics
- Visual encoding choices
- Dashboard design
- KPI definition
Who should attend
- business analysts
- finance professionals building reports
- management information officers
- data analysts
- team leaders responsible for KPIs
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
| 9 to 13 Nov 2026 | Nairobi | USD 1 800 |
| 18 to 22 Jan 2027 | Lagos | USD 1 800 |
| 1 to 5 Mar 2027 | Cape Town | R18 000 |
| 19 to 23 Apr 2027 | Johannesburg | R18 000 |
| 17 to 21 May 2027 | Durban | R18 000 |
| 5 to 9 Jul 2027 | Pretoria | R18 000 |
| 2 to 6 Aug 2027 | Dubai | USD 1 800 |
| 13 to 17 Sep 2027 | Online | USD 900 |
| 1 to 5 Nov 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)