Skip to content

Advanced Microsoft Excel for Administrative Professionals

Build practical Excel skills that administrators across African organisations rely on daily to track budgets, staff registers, stock and schedules without errors. Participants move beyond basic spreadsheets to confident use of formulas, lookups, pivot tables and clean formatting that turn raw office data into information managers can trust. The course uses everyday office scenarios so skills transfer straight back to the desk.

Ready to book? Secure your place on this programme.

Register for this course

What you will be able to do

  • Construct reliable formulas using functions such as IF, SUMIF, VLOOKUP and XLOOKUP.
  • Summarise office data quickly with pivot tables and pivot charts.
  • Clean and standardise messy spreadsheets imported from other systems.
  • Apply data validation and protection to reduce capture errors and accidental changes.
  • Design clear tracking sheets for budgets, leave, assets and schedules.
  • Automate repetitive tasks with simple templates and conditional formatting.

Course outline

  1. 01Excel Foundations Refresher and Good Practice
  2. 02Essential Formulas and Cell Referencing
  3. 03Lookup Functions for Linking Data
  4. 04Building and Using Pivot Tables
  5. 05Cleaning and Validating Imported Data
  6. 06Conditional Formatting and Visual Cues
  7. 07Protecting Workbooks and Shared Sheets
  8. 08Practical Office Tracking Templates

Who should attend

This course suits office administrators, personal assistants, data capturers and support staff who use Excel regularly and want to work faster and more accurately.

Dates, venues and fees

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

Administration and Office Management

Office Management Operations and Systems

Office managers hold together budgets, suppliers, facilities and a team that reports to somebody else.

Next session
5 to 9 Oct 2026
Venue
Accra
5 day programme
FromR18,000
Administration and Office Management

Records Management and POPIA Compliance in the Office

Filing becomes a compliance function the moment personal information is involved. Administrators build a records system with defensible...

Next session
29 Sep to 1 Oct 2026
Venue
Lagos
3 day programme
FromR13,000
Administration and Office Management

Executive Assistant Diary and Travel Management

Protect a principal's calendar, brief them properly, and get them through a three city trip without a single missed connection.

Next session
5 to 9 Oct 2026
Venue
Lusaka
5 day programme
FromR18,000
See all Administration and Office Management courses