Data Analysis and Visualisation with Excel
Excel remains the most widely used analysis tool in business, and few use it to its full potential. This course takes participants beyond basic formulas into structured analysis, PivotTables, and clear charts that reveal what the numbers mean.
Course outline
What this programme covers, module by module.
- 01Structuring raw data into a clean and reliable table
- 02Using lookup and logical functions with confidence
- 03Summarising large data sets with PivotTables and slicers
- 04Building charts that communicate the point at a glance
- 05Cleaning and validating messy or inconsistent data
- 06Creating dashboards that refresh automatically from source
- 07Auditing formulas to trace and fix calculation errors
What you will gain
- Structure raw data for reliable analysis
- Use lookup and logical functions confidently
- Summarise data with PivotTables and slicers
- Build charts that communicate clearly
- Clean and validate messy data sets
- Create dashboards that update automatically
Who should attend
- Analysts and officers who work with data
- Finance and operations staff
- Administrators handling reporting
- Anyone using Excel for analysis
Upcoming sessions
| Date | City | Duration | Fees | Book |
|---|---|---|---|---|
| 26 to 28 Oct 2026 | Pretoria | 3 Days | R13,000 | |
| 9 to 11 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 | |
| 15 to 17 Feb 2027 | London | 3 Days | US$1,500 | |
| 26 to 28 Apr 2027 | Dubai | 3 Days | US$1,500 | |
| 21 to 23 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
- Data & Analytics
- Formats
- In-house, public, online
More in Data & Analytics
Power BI for Business Intelligence and Reporting
Power BI turns scattered data into interactive reports that decision-makers can explore for themselves. This course guides participants from connecting data sources through building models to publishing dashboards that stay current.
Introduction to Data Analytics for Decision Making
This course demystifies data analytics for professionals who need to use data but are not specialists. Participants learn how to ask the right questions, interpret results, and use evidence to support better decisions.
SQL for Data Analysis and Reporting
SQL is the standard language for extracting and analysing data held in databases. This hands-on course builds the querying skills needed to pull, filter, combine, and summarise data directly from source systems.