Microsoft Excel for Business Analysis
Excel remains one of the most widely used and misused tools in business. This course develops the intermediate and advanced skills needed to analyse data and build reliable models. Delegates work with functions, tables, and analysis tools on realistic problems.
Course outline
What this programme covers, module by module.
- 01Using advanced functions such as lookup and logical
- 02Building and managing structured data tables
- 03Summarising data quickly with pivot tables
- 04Creating clear and honest charts
- 05Building simple models and scenario analysis
- 06Reducing errors and auditing spreadsheet formulas
- 07Automating repetitive steps with basic macros
What you will gain
- Use advanced functions and formulas
- Build and manage data tables
- Summarise data with pivot tables
- Create clear and useful charts
- Build simple models and scenarios
- Reduce errors in spreadsheets
Who should attend
- Analysts and finance staff
- Managers and administrators
- Operations professionals
- Anyone working with spreadsheets
Upcoming sessions
| Date | City | Duration | Fees | Book |
|---|---|---|---|---|
| 9 to 11 Nov 2026 | Pretoria | 3 Days | R13,000 | |
| 23 to 25 Nov 2026 | Durban | 3 Days | R13,000 | |
| 8 to 10 Dec 2026 | Cape Town | 3 Days | R13,000 | |
| 11 to 13 Jan 2027 | Johannesburg | 3 Days | R13,000 | |
| 22 to 24 Feb 2027 | London | 3 Days | US$1,500 | |
| 19 to 21 Apr 2027 | Dubai | 3 Days | US$1,500 | |
| 28 to 30 Jun 2027 | Pretoria | 3 Days | R13,000 |
Fees are per delegate and exclude VAT. Public intakes are confirmed once minimum numbers are met. We also deliver this course on your own schedule, in-house or live online.
Enquire about this course
Register your team or ask for a tailored in-house quote. We reply within one working day.
WhatsApp usCourse brochure (PDF)- Fees from
- R13,000 per delegate
- Duration
- 3 Days
- Field
- IT & Digital Skills
- Formats
- In-house, public, online
More in IT & Digital Skills
Cybersecurity Fundamentals for Professionals
Every organisation now depends on systems and data that attackers actively seek to exploit. This course builds a practical understanding of cyber threats and the defences that reduce them. Participants study common attacks, security controls, and the response to incidents.
Spreadsheet to Database Migration for Teams
Teams outgrow a shared spreadsheet long before they admit it, usually at the point where two people are editing different copies. This course covers moving that work into something that holds.
Cloud Computing Foundations
Cloud services have changed how organisations build, run, and pay for technology. This course explains the concepts, models, and benefits of cloud computing in plain terms. Participants examine service models, deployment options, and the basics of cost and security.