Skip to content

Training across Africa, the Middle East and live online

069 221 6943

ISP TrainingsInnovative Special Projects

Arrow keys to moveEnter to openEsc to close

Print this page or save it as a PDF to circulate internally.

Back to the course
Innovative Special Projects

Executive and professional training

305 Glenwood Road, Faerie Glen, Pretoria, South Africa

069 221 6943

info@isptrainings.co.za

Advanced Excel in the Public Sector

Data and Business Intelligence|5 days|Classroom or live online

Advanced Excel in the Public Sector takes the discipline and works it through the constraints of this operating context, including spreadsheet controls, visual encoding choices and the compliance obligations that come with it. The sector framing is necessary because analysts are frequently self taught in the tool and untrained in the reasoning, and generic training rarely survives contact with the local rules. Delegates leave able to work confidently with self service analytics, pivot table analysis and data quality management in their own organisation.

What delegates leave able to do

  • Take ownership of self service analytics rather than escalating it, measured against established visualisation principles
  • Review pivot table analysis and say plainly whether it is working
  • Spot where data quality management is failing before it becomes a finding
  • Explain forecasting techniques to someone who does not do the work

What the course covers

  • Spreadsheet controls
  • Visual encoding choices
  • Self service analytics
  • Pivot table analysis
  • Data quality management
  • Forecasting techniques
  • Data cleaning and preparation

Who should attend

  • reporting specialists
  • management information officers
  • operations managers using dashboards
  • team leaders responsible for KPIs

Fees

South AfricaR18 000
Elsewhere in Africa and the GulfUSD 1 800
Live onlineUSD 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

19 to 23 Oct 2026Dar es SalaamUSD 1 800
30 Nov to 4 Dec 2026Cape TownR18 000
11 to 15 Jan 2027Cape TownR18 000
22 to 26 Feb 2027JohannesburgR18 000
22 to 26 Mar 2027Cape TownR18 000
26 to 30 Apr 2027Cape TownR18 000
24 to 28 May 2027DurbanR18 000
21 to 25 Jun 2027DubaiUSD 1 800
19 to 23 Jul 2027PretoriaR18 000
6 to 10 Sep 2027JohannesburgR18 000
18 to 22 Oct 2027DubaiUSD 1 800

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)