Skip to content

Advanced Microsoft Excel for Data Analysis and Automation

Excel remains the workhorse of analysis in most African offices, yet many users apply only a fraction of its power. This advanced course pushes beyond basic formulas into dynamic models, powerful lookups, pivot analysis and lightweight automation with macros. Participants rebuild real workbooks to be faster, more accurate and easier to maintain.

Ready to book? Secure your place on this programme.

Register for this course

What you will be able to do

  • Build robust formulas using advanced lookup, logical and dynamic functions.
  • Analyse large datasets efficiently with pivot tables and slicers.
  • Design flexible models that update automatically as inputs change.
  • Apply data validation and error checks to improve workbook reliability.
  • Record and edit simple macros to automate repetitive tasks.
  • Structure workbooks so they remain accurate and easy to audit.

Course outline

  1. 01Advanced Formulas and Dynamic Functions
  2. 02Powerful Lookups Across Datasets
  3. 03Pivot Tables, Slicers and Analysis
  4. 04Building Flexible Models
  5. 05Data Validation and Error Control
  6. 06Introduction to Macros and Automation
  7. 07Designing Auditable Workbooks
  8. 08Rebuild a Real Workbook Workshop

Who should attend

Finance, operations and administrative staff who use Excel regularly and want to work faster and more accurately.

Dates, venues and fees

DatesVenueDaysFeeCalendarRegister
28 to 30 Sep 2026Dubai3US$1,500Closed
29 Sep to 1 Oct 2026Online3US$900Register
26 to 28 Oct 2026Johannesburg3R13,000Register
27 to 29 Oct 2026Cape Town3R13,000Register
28 to 30 Oct 2026Durban3R13,000Register
2 to 4 Nov 2026Pretoria3R13,000Register
3 to 5 Nov 2026Windhoek3US$1,500Register
4 to 6 Nov 2026Gaborone3US$1,500Register
9 to 11 Nov 2026Maseru3US$1,500Register
10 to 12 Nov 2026Mbabane3US$1,500Register
11 to 13 Nov 2026Lusaka3US$1,500Register
16 to 18 Nov 2026Harare3US$1,500Register
17 to 19 Nov 2026Lilongwe3US$1,500Register
18 to 20 Nov 2026Blantyre3US$1,500Register
23 to 25 Nov 2026Mozambique3US$1,500Register
24 to 26 Nov 2026Nairobi3US$1,500Register
25 to 27 Nov 2026Dar es Salaam3US$1,500Register
30 Nov to 2 Dec 2026Kigali3US$1,500Register
1 to 3 Dec 2026Kampala3US$1,500Register
2 to 4 Dec 2026Accra3US$1,500Register
7 to 9 Dec 2026Lagos3US$1,500Register
8 to 10 Dec 2026Cairo3US$1,500Register
9 to 11 Dec 2026Mauritius3US$1,500Register

Fees are per delegate. South African venues are priced in rand; other locations and online in US dollars. Fees exclude 15% VAT where applicable. Group bookings of three or more delegates from the same organisation qualify for a reduced rate; contact us for a quotation.

Related courses in Data, Digital and Cyber Security

Data, Digital and Cyber Security

Cyber Security Fundamentals for Business Teams

Most breaches begin with an ordinary employee making a reasonable decision on incomplete information.

Next session
29 Sep to 1 Oct 2026
Venue
Mbabane
3 day programme
FromR13,000
Data, Digital and Cyber SecurityNew

Artificial Intelligence for Business Managers

Artificial intelligence has moved from novelty to something managers are expected to have an opinion on.

Next session
29 Sep to 1 Oct 2026
Venue
Maseru
3 day programme
FromR13,000
See all Data, Digital and Cyber Security courses