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
Advanced Excel Masterclass
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 SQL querying, data cleaning and preparation and the judgement calls that sit outside recognised data governance frameworks. At this level the constraint is rarely knowledge. It is judgement under pressure, which matters because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with data modelling, pivot table analysis and data governance in their own organisation.
What delegates leave able to do
- Spot where data modelling is failing before it becomes a finding, measured against recognised data governance frameworks
- Put pivot table analysis on a footing they can defend to a reviewer
- Review data governance and say plainly whether it is working
- Improve visual encoding choices within their own organisation
What the course covers
- SQL querying
- Data cleaning and preparation
- Data modelling
- Pivot table analysis
- Data governance
- Visual encoding choices
- Statistical fundamentals
Who should attend
- finance professionals building reports
- operations managers using dashboards
- data analysts
- professionals moving into analytics
- business 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
| 16 to 20 Nov 2026 | Durban | R18 000 |
| 25 to 29 Jan 2027 | Durban | R18 000 |
| 8 to 12 Mar 2027 | Lusaka | USD 1 800 |
| 5 to 9 Apr 2027 | Johannesburg | R18 000 |
| 3 to 7 May 2027 | Online | USD 900 |
| 7 to 11 Jun 2027 | Pretoria | R18 000 |
| 12 to 16 Jul 2027 | Dubai | USD 1 800 |
| 9 to 13 Aug 2027 | Johannesburg | R18 000 |
| 13 to 17 Sep 2027 | Durban | R18 000 |
| 11 to 15 Oct 2027 | Durban | R18 000 |
| 22 to 26 Nov 2027 | Cape Town | 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)