Skip to content

Training across Africa, the Middle East and live online

069 221 6943

ISP TrainingsInnovative Special Projects

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

Practical Advanced Excel

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

This is a hands-on programme. Delegates spend most of the time working through data cleaning and preparation and forecasting techniques on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: most organisations have more dashboards than decisions that depend on them, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with spreadsheet controls, statistical fundamentals and data governance in their own organisation.

What delegates leave able to do

  • Put spreadsheet controls on a footing they can defend to a reviewer, measured against dimensional modelling practice
  • Improve statistical fundamentals within their own organisation
  • Bring data governance into line with current good practice
  • Take ownership of scenario modelling rather than escalating it

What the course covers

  • Data cleaning and preparation
  • Forecasting techniques
  • Spreadsheet controls
  • Statistical fundamentals
  • Data governance
  • Scenario modelling
  • Data modelling

Who should attend

  • management information officers
  • data analysts
  • reporting specialists

Fees

South AfricaR13 000
Elsewhere in Africa and the GulfUSD 1 500
Live onlineUSD 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 2026JohannesburgR13 000
30 Nov to 2 Dec 2026Dar es SalaamUSD 1 500
8 to 10 Feb 2027WindhoekUSD 1 500
29 to 31 Mar 2027KigaliUSD 1 500
3 to 5 May 2027HarareUSD 1 500
21 to 23 Jun 2027OnlineUSD 900
19 to 21 Jul 2027KampalaUSD 1 500
30 Aug to 1 Sep 2027DurbanR13 000
11 to 13 Oct 2027HarareUSD 1 500
15 to 17 Nov 2027KigaliUSD 1 500

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)