Excel Automation and Macros in the Public Sector

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

Excel Automation and Macros in the Public Sector takes the discipline and works it through the constraints of this operating context, including scenario modelling, SQL querying and the compliance obligations that come with it. The sector framing is necessary because reporting effort scales badly when the underlying model is wrong, and generic training rarely survives contact with the local rules. Delegates leave able to work confidently with DAX and calculated measures, data cleaning and preparation and KPI definition in their own organisation.

What delegates leave able to do

Put DAX and calculated measures on a footing they can defend to a reviewer, measured against dimensional modelling practice
Bring data cleaning and preparation into line with current good practice
Improve KPI definition within their own organisation
Make a decision about data warehouse concepts without waiting for a specialist

What the course covers

Scenario modelling
SQL querying
DAX and calculated measures
Data cleaning and preparation
KPI definition
Data warehouse concepts
Self service analytics

Who should attend

operations managers using dashboards
finance professionals building reports
data analysts
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

12 to 14 Oct 2026	Johannesburg	R13 000
16 to 18 Nov 2026	Cape Town	R13 000
8 to 10 Feb 2027	Windhoek	USD 1 500
22 to 24 Mar 2027	Nairobi	USD 1 500
26 to 28 Apr 2027	Harare	USD 1 500
7 to 9 Jun 2027	Johannesburg	R13 000
12 to 14 Jul 2027	Harare	USD 1 500
23 to 25 Aug 2027	Online	USD 900
11 to 13 Oct 2027	Johannesburg	R13 000
15 to 17 Nov 2027	Pretoria	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)