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
Fundamentals of Advanced Excel
Data and Business Intelligence|2 days|Classroom or live online
Fundamentals of Advanced Excel is built for delegates who need to be useful in this area quickly. It starts at first principles and works through data modelling and scenario modelling without assuming prior specialist training. The programme exists because reporting effort scales badly when the underlying model is wrong, and because capability in this area is usually built on the job with no structure behind it. Delegates leave able to work confidently with SQL querying, pivot table analysis and KPI definition in their own organisation.
What delegates leave able to do
- Spot where SQL querying is failing before it becomes a finding, measured against established visualisation principles
- Put pivot table analysis on a footing they can defend to a reviewer
- Bring KPI definition into line with current good practice
- Make a decision about visual encoding choices without waiting for a specialist
What the course covers
- Data modelling
- Scenario modelling
- SQL querying
- Pivot table analysis
- KPI definition
- Visual encoding choices
- Data governance
Who should attend
- operations managers using dashboards
- business analysts
- reporting specialists
- data analysts
Fees
| South Africa | R10 000 |
| Elsewhere in Africa and the Gulf | USD 1 100 |
| Live online | USD 900 |
Per delegate, for the full 2 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
| 30 Nov to 1 Dec 2026 | Gaborone | USD 1 100 |
| 11 to 12 Jan 2027 | Lagos | USD 1 100 |
| 1 to 2 Mar 2027 | Pretoria | R10 000 |
| 29 to 30 Mar 2027 | Online | USD 900 |
| 3 to 4 May 2027 | Johannesburg | R10 000 |
| 7 to 8 Jun 2027 | Cape Town | R10 000 |
| 19 to 20 Jul 2027 | Pretoria | R10 000 |
| 30 to 31 Aug 2027 | Johannesburg | R10 000 |
| 11 to 12 Oct 2027 | Lusaka | USD 1 100 |
| 29 to 30 Nov 2027 | Cape Town | R10 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)