In Jordanian organisations where reporting is often assembled from multiple Excel files, Power Query, pivot tables, and structured formulas help reduce manual copy-paste work and improve the consistency of management reports.
Pretoria, South Africa
Research, Data Analytics, and Business Intelligence
Microsoft Excel for Data Analytics Training Course
South Africa's administrative capital where government, science and heritage converge for professional growth
10 Days
Duration
In-Person
Delivery
12 Dates
Available
Certificate
Included
Master Microsoft Excel for data analytics to transform raw data, build dynamic dashboards, and deliver actionable insights through advanced formulas and visualization techniques.
Upcoming In-Person Schedules in Pretoria
Reserve Your Spot Today — Pay When You're Ready!
| Code | Start Date | End Date | Duration | Fee | |
|---|---|---|---|---|---|
| MED-02 | Mon - Fri (10 Days) | USD 6,600 | Reserve my seat → Register my team → | ||
| MED-02 | Mon - Fri (10 Days) | USD 5,900 | Reserve my seat → Register my team → | ||
| MED-02 | Mon - Fri (10 Days) | USD 5,900 | Reserve my seat → Register my team → | ||
| MED-02 | Mon - Fri (10 Days) | USD 5,900 | Reserve my seat → Register my team → | ||
| MED-02 | Mon - Fri (10 Days) | USD 5,900 | Reserve my seat → Register my team → | ||
| MED-02 | Mon - Fri (10 Days) | USD 5,900 | Reserve my seat → Register my team → |
Here's What You'll Learn
Each module tackles real challenges you face in your role
1
Excel Analytics Foundation and Modern Data Workflows
2
Power Query for Automated Data Integration
3
Advanced Formula Architecture and Array Functions
4
Statistical Analysis and Data Mining Techniques
5
Pivot Table Mastery for Multidimensional Analysis
6
Forecasting and Predictive Modeling
7
Scenario Analysis and Risk Modeling
8
Interactive Dashboard Design and Visualization
9
Data Validation and Quality Assurance
10
Advanced Reporting and Stakeholder Communication
Market-specific guidance for Jordan
A country-aware view of the pressures, proof points, and practical tools that shape how this course applies locally.
Tools and platforms relevant to this field
4Field-relevant examples that may be featured in training where they support the confirmed scope. Exact coverage depends on participant needs and delivery format.
-
Microsoft Excel MicrosoftUsed for data cleaning, pivot tables, formulas, charting, and dashboard reporting in day-to-day business analysis.
-
Power Query MicrosoftUsed to import, reshape, and combine data from multiple files or systems before analysis in Excel.
-
Power Pivot MicrosoftUsed to build data models and perform more scalable analysis when spreadsheets need to handle larger, linked datasets.
-
Power BI MicrosoftUsed by teams that want to extend Excel-based analysis into interactive reporting and shareable dashboards.
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
8
heritage
Union Buildings
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.
heritage
Voortrekker Monument
A 60-metre granite National Heritage Site commemorating the 19th-century Great Trek, featuring the Hall of Heroes with 27 marble relief panels.
Learn more
heritage
Freedom Park
A memorial and museum on Salvokop Hill honouring South Africa's liberation history, with panoramic views over the city and the Voortrekker Monument.
Learn more
nature
Pretoria National Botanical Garden
A 76-hectare garden showcasing South African plant species grouped by climatic region, with paved nature trails through natural vegetation.
Learn more
leisure
National Zoological Gardens of South Africa
An 85-hectare zoo and research hub housing over 500 species, with a reptile park, walk-through aviary, and inland aquarium.
nature
Groenkloof Nature Reserve
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.
heritage
Church Square
The historic heart of Pretoria, surrounded by grand old buildings including the Palace of Justice, with the Paul Kruger statue at its centre.
heritage
Melrose House
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 5
Sector-level context showing where this capability is relevant in Pretoria.
Government and Public Administration
Pretoria is South Africa's administrative capital, hosting government departments, ministries, and foreign embassies — relevant for delegates in governance, compliance, and public-sector training.
Science, Research and Technology
The CSIR, headquartered on its Pretoria campus, is Africa's largest R&D organisation. Combined with two major universities, the city is a hub for applied research and technology skills development.
Defence and Aerospace
Pretoria hosts the SANDF headquarters and state-owned defence manufacturer Denel, making it relevant for delegates in defence, security, and aerospace sectors.
Higher Education and Distance Learning
UNISA, headquartered in Pretoria, is the largest distance-learning university in Africa, making the city a natural fit for education-sector and e-learning training programmes.
Telecommunications
Telkom, South Africa's national fixed-line operator, is headquartered in Pretoria, anchoring the city's role in the country's telecommunications infrastructure.
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
O.R. Tambo International Airport (JNB) in Johannesburg is the primary gateway, approximately 50 km south-east of Pretoria. The Gautrain rapid-rail service connects the airport to Pretoria station in about 40 minutes; metered taxis and ride-hailing apps (Uber, Bolt) are widely available for ground transfers.
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
Microsoft Excel for Data Analytics Training is delivered in the cities below — pick the one that fits your schedule.
