Advanced Excel for Small and Medium Enterprises

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

Advanced Excel for Small and Medium Enterprises takes the discipline and works it through the constraints of this operating context, including report automation, data cleaning and preparation 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 statistical fundamentals, pivot table analysis and data warehouse concepts in their own organisation.

What delegates leave able to do

Put statistical fundamentals on a footing they can defend to a reviewer, measured against dimensional modelling practice
Take ownership of pivot table analysis rather than escalating it
Make a decision about data warehouse concepts without waiting for a specialist
Improve scenario modelling within their own organisation

What the course covers

Report automation
Data cleaning and preparation
Statistical fundamentals
Pivot table analysis
Data warehouse concepts
Scenario modelling
DAX and calculated measures

Who should attend

operations managers using dashboards
team leaders responsible for KPIs
data analysts
reporting specialists

Fees

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

23 to 27 Nov 2026	Cairo	USD 1 800
1 to 5 Feb 2027	Johannesburg	R18 000
8 to 12 Mar 2027	Lusaka	USD 1 800
12 to 16 Apr 2027	Windhoek	USD 1 800
31 May to 4 Jun 2027	Johannesburg	R18 000
12 to 16 Jul 2027	Nairobi	USD 1 800
23 to 27 Aug 2027	Dubai	USD 1 800
27 Sep to 1 Oct 2027	Port Louis	USD 1 800
15 to 19 Nov 2027	Online	USD 900

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)