Excel Automation and Macros for Small and Medium Enterprises

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

Excel Automation and Macros for Small and Medium Enterprises takes the discipline and works it through the constraints of this operating context, including forecasting techniques, data governance and the compliance obligations that come with it. The sector framing is necessary because most organisations have more dashboards than decisions that depend on them, and generic training rarely survives contact with the local rules. Delegates leave able to work confidently with visual encoding choices, DAX and calculated measures and data modelling in their own organisation.

What delegates leave able to do

Make a decision about visual encoding choices without waiting for a specialist, measured against established visualisation principles
Take ownership of DAX and calculated measures rather than escalating it
Bring data modelling into line with current good practice
Review KPI definition and say plainly whether it is working

What the course covers

Forecasting techniques
Data governance
Visual encoding choices
DAX and calculated measures
Data modelling
KPI definition
Scenario modelling

Who should attend

business analysts
finance professionals building reports
operations managers using dashboards
team leaders responsible for KPIs

Fees

South Africa	R13 000
Elsewhere in Africa and the Gulf	USD 1 500
Live online	USD 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

30 Nov to 2 Dec 2026	Cape Town	R13 000
18 to 20 Jan 2027	Johannesburg	R13 000
22 to 24 Feb 2027	Johannesburg	R13 000
29 to 31 Mar 2027	Kigali	USD 1 500
26 to 28 Apr 2027	Dar es Salaam	USD 1 500
14 to 16 Jun 2027	Dar es Salaam	USD 1 500
19 to 21 Jul 2027	Port Louis	USD 1 500
30 Aug to 1 Sep 2027	Pretoria	R13 000
11 to 13 Oct 2027	Johannesburg	R13 000
15 to 17 Nov 2027	Durban	R13 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)