Excel Automation and Macros for Non-Specialists

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

Excel Automation and Macros for Non-Specialists is built for delegates who need to be useful in this area quickly. It starts at first principles and works through SQL querying and self service analytics without assuming prior specialist training. The programme exists because analysts are frequently self taught in the tool and untrained in the reasoning, and because capability in this area is usually built on the job with no structure behind it. Delegates leave able to work confidently with data governance, spreadsheet controls and pivot table analysis in their own organisation.

What delegates leave able to do

Spot where data governance is failing before it becomes a finding, measured against established visualisation principles
Take ownership of spreadsheet controls rather than escalating it
Improve pivot table analysis within their own organisation
Review data modelling and say plainly whether it is working

What the course covers

SQL querying
Self service analytics
Data governance
Spreadsheet controls
Pivot table analysis
Data modelling
Forecasting techniques

Who should attend

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

Fees

South Africa	R10 000
Elsewhere in Africa and the Gulf	USD 1 100
Live online	USD 900

Per delegate, for the full 2 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

2 to 3 Nov 2026	Cape Town	R10 000
18 to 19 Jan 2027	Accra	USD 1 100
8 to 9 Mar 2027	Pretoria	R10 000
12 to 13 Apr 2027	Gaborone	USD 1 100
31 May to 1 Jun 2027	Pretoria	R10 000
5 to 6 Jul 2027	Lagos	USD 1 100
23 to 24 Aug 2027	Lagos	USD 1 100
20 to 21 Sep 2027	Pretoria	R10 000
18 to 19 Oct 2027	Lusaka	USD 1 100
22 to 23 Nov 2027	Port Louis	USD 1 100

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)