Details
This intermediate Excel training focuses on displaying data effectively. Learn to leverage visual elements and advanced formulas to create compelling worksheets. Our intermediate Excel classes cover a range of formats, enabling you to present data clearly and professionally. Join our Excel intermediate course to enhance your data visualization skills.
Take your Excel abilities to the next level with our Excel Intermediate Training. Ideal for students with existing Excel skills, this course explores advanced features for data analysis and presentation. Master higher-level Excel functionalities in our engaging intermediate Excel classes and intermediate Excel course.
Delivery Methods
| Delivery Method | Duration | ||
|---|---|---|---|
| 1 Day | Get a Quote | ||
| 1 Day | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Customer Testimonials
World Vision International
The facilitator was very considerate & tried to give clarity where we needed one & even demonstrated some things which were not in his examples.
United Exports South Africa (Pty) Ltd
Learned so many new skills to boost my data analysis capabilities. I highly recommend this course to anyone looking to level up their Excel skills & knowledge.
Cox
I would for sure recommend this course. Very well represented!
World Vision International
They are knowledgeable about the content
Marara Pharmacy
The course was very informative. Keep up the good work.
Broll Property Group (Pty) Ltd
yes, the excel training was very informative particularly in learning how to create pivot tables and also learning about excel formulars and shortcuts calculation. this will assist in being more efficient when working on any calculation in excel
Audience
This Intermediate Excel course is for anyone who has a basic understanding of Excel and wants to take their skills to the next level. Target students include individuals who need to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. It is for people aiming to boost their efficiency and data handling capabilities.
Pre-Requisites
Microsoft Office Excel Fundamentals
Course Outline / Curriculum
Lesson 1: Working with Functions
- Work with Ranges
- Use Specialized Functions
- Work with Logical Functions
- Work with Date & Time Functions
- Work with Text Functions
Lesson 2: Working with Lists
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
Lesson 3: Analyzing Data
- Create and Modify Tables
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
Lesson 4: Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
- Use Advanced Chart Features
Lesson 5: Using PivotTables and PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
Schedule Dates and Booking
To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.
| Start Date | End Date | Branch | Status | |
|---|---|---|---|---|
| Tue 20 Jan 2026 | Tue 20 Jan 2026 | Not Applicable | Scheduled | |
| Tue 17 Feb 2026 | Tue 17 Feb 2026 | Not Applicable | Scheduled | |
| Tue 10 Mar 2026 | Tue 10 Mar 2026 | Not Applicable | Scheduled | |
| Tue 17 Mar 2026 | Tue 17 Mar 2026 | Not Applicable | Scheduled | |
| Tue 14 Apr 2026 | Tue 14 Apr 2026 | Not Applicable | Scheduled |
