Managing Advanced Excel

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

This programme is for the person accountable for the work rather than the person doing it. It covers scenario modelling and report automation from the position of someone who must review, approve and answer for the output. Managers carry this because analysts are frequently self taught in the tool and untrained in the reasoning, and the accountability does not delegate cleanly. Delegates leave able to work confidently with KPI definition, data warehouse concepts and dashboard design in their own organisation.

What delegates leave able to do

Bring KPI definition into line with current good practice, measured against established visualisation principles
Make a decision about data warehouse concepts without waiting for a specialist
Review dashboard design and say plainly whether it is working
Take ownership of spreadsheet controls rather than escalating it

What the course covers

Scenario modelling
Report automation
KPI definition
Data warehouse concepts
Dashboard design
Spreadsheet controls
Storytelling with data

Who should attend

reporting specialists
business analysts
management information officers
professionals moving into analytics
data analysts

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

26 to 28 Oct 2026	Gaborone	USD 1 500
4 to 6 Jan 2027	Harare	USD 1 500
8 to 10 Feb 2027	Online	USD 900
22 to 24 Mar 2027	Johannesburg	R13 000
10 to 12 May 2027	Nairobi	USD 1 500
21 to 23 Jun 2027	Dar es Salaam	USD 1 500
2 to 4 Aug 2027	Pretoria	R13 000
13 to 15 Sep 2027	Cape Town	R13 000
18 to 20 Oct 2027	Dar es Salaam	USD 1 500
22 to 24 Nov 2027	Dubai	USD 1 500

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)