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.

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

DatesVenueDaysFeeCalendar
17 to 19 Aug 2026Dubai3US$1,500
24 to 26 Aug 2026Lagos3US$1,500
31 Aug to 2 Sep 2026Harare3US$1,500
7 to 9 Sep 2026Kampala3US$1,500
14 to 16 Sep 2026Dar es Salaam3US$1,500
21 to 23 Sep 2026Pretoria3R13,000
28 to 30 Sep 2026Cape Town3R13,000
12 to 14 Oct 2026Online3US$900
19 to 21 Oct 2026Mozambique3US$1,500
26 to 28 Oct 2026Cairo3US$1,500
2 to 4 Nov 2026Accra3US$1,500
9 to 11 Nov 2026Lusaka3US$1,500
16 to 18 Nov 2026Kigali3US$1,500
23 to 25 Nov 2026Nairobi3US$1,500
30 Nov to 2 Dec 2026Durban3R13,000
7 to 9 Dec 2026Johannesburg3R13,000
21 to 23 Dec 2026Mauritius3US$1,500

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. This course covers the systems that...

Next session
31 Aug to 4 Sep 2026
Venue
Accra
5 day programme
FromUS$900
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
31 Aug to 2 Sep 2026
Venue
Online
3 day programme
FromUS$900
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. The work is...

Next session
31 Aug to 4 Sep 2026
Venue
Pretoria
5 day programme
FromUS$900
See all Administration and Office Management courses