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

Spreadsheet Controls: Tools and Techniques

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

This is a hands-on programme. Delegates spend most of the time working through DAX and calculated measures and data cleaning and preparation 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 pivot table analysis, data governance and self service analytics in their own organisation.

What delegates leave able to do

  • Review pivot table analysis and say plainly whether it is working, measured against dimensional modelling practice
  • Improve data governance within their own organisation
  • Explain self service analytics to someone who does not do the work
  • Put forecasting techniques on a footing they can defend to a reviewer

What the course covers

  • DAX and calculated measures
  • Data cleaning and preparation
  • Pivot table analysis
  • Data governance
  • Self service analytics
  • Forecasting techniques
  • Statistical fundamentals

Who should attend

  • business analysts
  • finance professionals building reports
  • operations managers using dashboards

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

2 to 4 Nov 2026PretoriaR13 000
30 Nov to 2 Dec 2026PretoriaR13 000
4 to 6 Jan 2027JohannesburgR13 000
22 to 24 Feb 2027Cape TownR13 000
29 to 31 Mar 2027LusakaUSD 1 500
3 to 5 May 2027HarareUSD 1 500
31 May to 2 Jun 2027KampalaUSD 1 500
19 to 21 Jul 2027OnlineUSD 900
16 to 18 Aug 2027LusakaUSD 1 500
27 to 29 Sep 2027CairoUSD 1 500
25 to 27 Oct 2027Cape TownR13 000
29 Nov to 1 Dec 2027KampalaUSD 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)