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

Strategic Advanced Excel

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

Strategic Advanced Excel looks at this work from the level at which it is resourced and defended. The focus is on pivot table analysis, SQL querying and how both connect to what the organisation is actually trying to achieve. This matters at the strategic level because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with statistical fundamentals, self service analytics and data warehouse concepts in their own organisation.

What delegates leave able to do

  • Review statistical fundamentals and say plainly whether it is working, measured against dimensional modelling practice
  • Make a decision about self service analytics without waiting for a specialist
  • Put data warehouse concepts on a footing they can defend to a reviewer
  • Spot where data quality management is failing before it becomes a finding

What the course covers

  • Pivot table analysis
  • SQL querying
  • Statistical fundamentals
  • Self service analytics
  • Data warehouse concepts
  • Data quality management
  • Storytelling with data

Who should attend

  • business analysts
  • reporting specialists
  • team leaders responsible for KPIs
  • professionals moving into analytics
  • finance professionals building reports

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

12 to 16 Oct 2026AccraUSD 1 800
16 to 20 Nov 2026PretoriaR18 000
1 to 5 Feb 2027Cape TownR18 000
1 to 5 Mar 2027DubaiUSD 1 800
5 to 9 Apr 2027GaboroneUSD 1 800
10 to 14 May 2027NairobiUSD 1 800
21 to 25 Jun 2027OnlineUSD 900
19 to 23 Jul 2027CairoUSD 1 800
30 Aug to 3 Sep 2027JohannesburgR18 000
11 to 15 Oct 2027JohannesburgR18 000
15 to 19 Nov 2027CairoUSD 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)