RELATED COURSES
Analysing Data with Excel
Azure Fundametals
Data Modelling with M and Power Query
DAX Programming
Excel Boot Camp
Excel Dashboards & Power Pivot: Building Interactive Data Solutions
Excel for Statistical Analysis
Excel Productivity
Excel VBA
Microsoft Access
Microsoft Azure Administrator
Microsoft Excel For Human Resources Analytics
Microsoft Excel Fundamentals
Microsoft Excel: Advanced
Microsoft Office 365 Overview
Microsoft OneNote Fundamentals
Microsoft Outlook Level 1
Microsoft Power Automate
Microsoft Power BI Bootcamp
Microsoft Power BI Desktop Advanced
Microsoft Power Query
Microsoft PowerApps
Microsoft PowerBI Dashboard User Course
Microsoft PowerPoint Level 1
Microsoft PowerPoint Level 2
Microsoft Project
Microsoft SharePoint User
Microsoft Teams
Microsoft Visio
Microsoft Word Level 1
Microsoft Word Level 2
MS Office Level 1
OneDrive Training
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 | ||
|---|---|---|---|
| Classroom | 1 Day | Get a Quote | |
| Live Virtual Training | 1 Day | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Customer Testimonials
BMW Group South Africa
Awesome training looking forward to using my knowledge at work
Gauteng Provincial Treasury
I think overall, the training experience was excellent. I do not have any regrets.
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 13 May 2025 | Tue 13 May 2025 | Fourways | Scheduled | |
| Tue 10 Jun 2025 | Tue 10 Jun 2025 | Fourways | Scheduled | |
| Tue 8 Jul 2025 | Tue 8 Jul 2025 | Fourways | Scheduled | |
| Tue 5 Aug 2025 | Tue 5 Aug 2025 | Fourways | Scheduled | |
| Tue 2 Sep 2025 | Tue 2 Sep 2025 | Fourways | Scheduled | |
| Tue 30 Sep 2025 | Tue 30 Sep 2025 | Fourways | Scheduled | |
| Tue 28 Oct 2025 | Tue 28 Oct 2025 | Fourways | Scheduled | |
| Tue 25 Nov 2025 | Tue 25 Nov 2025 | Fourways | Scheduled |