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: Tools and Techniques

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

This is a hands-on programme. Delegates spend most of the time working through data warehouse concepts and spreadsheet controls on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: reporting effort scales badly when the underlying model is wrong, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with data modelling, pivot table analysis and data cleaning and preparation in their own organisation.

What delegates leave able to do

  • Bring data modelling into line with current good practice, measured against dimensional modelling practice
  • Take ownership of pivot table analysis rather than escalating it
  • Spot where data cleaning and preparation is failing before it becomes a finding
  • Review data governance and say plainly whether it is working

What the course covers

  • Data warehouse concepts
  • Spreadsheet controls
  • Data modelling
  • Pivot table analysis
  • Data cleaning and preparation
  • Data governance
  • Data quality management

Who should attend

  • data analysts
  • reporting specialists
  • management information officers

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

4 to 8 Jan 2027OnlineUSD 900
8 to 12 Feb 2027PretoriaR18 000
15 to 19 Mar 2027HarareUSD 1 800
19 to 23 Apr 2027HarareUSD 1 800
24 to 28 May 2027OnlineUSD 900
5 to 9 Jul 2027DubaiUSD 1 800
16 to 20 Aug 2027Dar es SalaamUSD 1 800
4 to 8 Oct 2027Dar es SalaamUSD 1 800
8 to 12 Nov 2027KampalaUSD 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)