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

Excel Automation and Macros Masterclass

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

This advanced programme assumes delegates already work in the field. It goes past the basics into data quality management, visual encoding choices and the judgement calls that sit outside recognised data governance frameworks. At this level the constraint is rarely knowledge. It is judgement under pressure, which matters because analysts are frequently self taught in the tool and untrained in the reasoning. Delegates leave able to work confidently with dashboard design, DAX and calculated measures and forecasting techniques in their own organisation.

What delegates leave able to do

  • Bring dashboard design into line with current good practice, measured against recognised data governance frameworks
  • Take ownership of DAX and calculated measures rather than escalating it
  • Spot where forecasting techniques is failing before it becomes a finding
  • Review KPI definition and say plainly whether it is working

What the course covers

  • Data quality management
  • Visual encoding choices
  • Dashboard design
  • DAX and calculated measures
  • Forecasting techniques
  • KPI definition
  • Data governance

Who should attend

  • operations managers using dashboards
  • business analysts
  • management information officers
  • reporting specialists
  • 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

9 to 13 Nov 2026DubaiUSD 1 800
8 to 12 Feb 2027LusakaUSD 1 800
29 Mar to 2 Apr 2027PretoriaR18 000
3 to 7 May 2027PretoriaR18 000
14 to 18 Jun 2027LusakaUSD 1 800
19 to 23 Jul 2027AccraUSD 1 800
16 to 20 Aug 2027Port LouisUSD 1 800
27 Sep to 1 Oct 2027OnlineUSD 900
15 to 19 Nov 2027Cape TownR18 000

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)