South Africa's seat of government and presidential offices, set on a hilltop with terraced gardens, panoramic city views, and the iconic 9-metre Nelson Mandela statue.
Advanced Microsoft Excel Training Course
South Africa's administrative capital where government, science and heritage converge for professional growth
Upcoming In-Person Schedules in Pretoria
Reserve Your Spot Today — Pay When You're Ready!
| Code | Start Date | End Date | Duration | Fee | |
|---|---|---|---|---|---|
| AME-49 | Mon - Fri (5 Days) | USD 3,000 | Reserve my seat → Register my team → | ||
| AME-49 | Mon - Fri (5 Days) | USD 3,500 | Reserve my seat → Register my team → | ||
| AME-49 | Mon - Fri (5 Days) | USD 3,500 | Reserve my seat → Register my team → | ||
| AME-49 | Mon - Fri (5 Days) | USD 3,500 | Reserve my seat → Register my team → | ||
| AME-49 | Mon - Fri (5 Days) | USD 3,500 | Reserve my seat → Register my team → | ||
| AME-49 | Mon - Fri (5 Days) | USD 3,500 | Reserve my seat → Register my team → |
Here's What You'll Learn
Each module tackles real challenges you face in your role
Excel Power Foundations: Getting Beyond the Basics
Advanced Formulas and Functions for Analysis
Data Cleaning and Preparation with Power Query
PivotTables and PivotCharts Mastery
Data Visualization and Dashboard Design
Automation with Macros and VBA Essentials
Power Pivot and Data Modeling
Excel for Financial Analysis and Forecasting
Collaboration and Integration Tools
Training visit intelligence for Pretoria
Practical notes for confirmed delegates: arrival, venue expectations, after-class options, and on-the-ground considerations.
Optional after-class stops
8A 60-metre granite National Heritage Site commemorating the 19th-century Great Trek, featuring the Hall of Heroes with 27 marble relief panels.
Learn moreA memorial and museum on Salvokop Hill honouring South Africa's liberation history, with panoramic views over the city and the Voortrekker Monument.
Learn moreA 76-hectare garden showcasing South African plant species grouped by climatic region, with paved nature trails through natural vegetation.
Learn moreAn 85-hectare zoo and research hub housing over 500 species, with a reptile park, walk-through aviary, and inland aquarium.
South Africa's first proclaimed nature reserve (1895), offering hiking, mountain biking, and game drives to see giraffes, zebras, and antelope just south of the city centre.
The historic heart of Pretoria, surrounded by grand old buildings including the Palace of Justice, with the Paul Kruger statue at its centre.
A beautifully preserved Victorian mansion where the Treaty of Vereeniging ending the Anglo-Boer War was signed, featuring original furnishings and stained glass.
Local demand signals 3
Sector-level context showing where this capability is relevant in Pretoria.
public-sector service delivery
Course fitAdvanced Excel helps teams automate recurring reporting, reconcile large datasets, and build decision-ready dashboards for budgeting, performance tracking, and case-management workflows.
Market signalPublic administration in Pretoria operates under strong pressure to improve reporting speed, data quality, and audit readiness while working within tight resource and governance constraints.
regulated financial services
Course fitAdvanced Excel is useful for automating reconciliations, scenario modelling, and management reporting where accurate, repeatable analysis is essential.
Market signalFinancial institutions in the Pretoria area face persistent pressure to strengthen data control, documentation quality, and compliance-oriented reporting.
infrastructure and utilities
Course fitAdvanced Excel can improve asset tracking, maintenance scheduling, operational reporting, and forecasting through formulas, pivot tables, and automation features.
Market signalInfrastructure operators typically need stronger visibility over service performance, maintenance backlogs, and cost control in data-constrained operating environments.
Training venue
Pretoria offers a solid range of 4- and 5-star hotels and dedicated conference facilities in suburbs such as Hatfield, Brooklyn, and Centurion. The CSIR International Convention Centre is a purpose-built venue frequently used for professional training and conferences.
Getting there
Direct service is not confirmed from Lesotho to Pretoria; the practical airport for Pretoria is OR Tambo International Airport in Johannesburg, with onward ground transfer to Pretoria. Airlink operates Maseru–Johannesburg service from Moshoeshoe I International Airport, and typical air time is about 1h 15m before the road leg into Pretoria.
Visa
Many nationalities (including US, UK, EU, and several African passport holders) can enter South Africa visa-free for up to 90 days on business or tourism. South Africa launched an Electronic Travel Authorisation (ETA) system in late 2025 for select nationalities — confirm current requirements with the nearest South African embassy, as visa rules vary by passport.
Safety
Avoid wearing visible jewellery, keep valuables concealed, and do not walk alone at night — use ride-hailing services for evening travel. Stay in well-known suburbs such as Hatfield, Brooklyn, or Waterkloof and remain aware of your surroundings in the CBD.
Internet
Reliability: good
Weather year-round
- Apr 24/13°C Autumn transition; rainfall drops significantly and days become drier and pleasant.
- Jan 29/18°C Warmest month; afternoon thunderstorms common with ~135 mm rainfall. Humid (62%).
- Jul 21/5°C Coldest month; dry (only ~3 mm rain) with clear skies. Nights can be cold — bring layers.
- Oct 27/14°C Spring warmth returns; low humidity (~35%) and minimal early-month rain. Jacaranda trees in bloom.
Where this course runs
Advanced Microsoft Excel Training is delivered in the cities below — pick the one that fits your schedule.























