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 Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm. Classroom	1 Day	Get a Quote
Live Virtual Training This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office. 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:

Information may change without notice.

Customer Testimonials

World Vision International

Trainer was chosen on my behalf, but personally I have found the interactive nature of the training very helpful, so no suggestions for improvement based on day 1

Shaeffler South Africa (Pty) Ltd

I really liked everything about this course. I learned new things that will really be helpful on mu daily tasks. Very good course.

Cox

I would for sure recommend this course. Very well represented!

Broll Property Group (Pty) Ltd

Yes. I would like to commend Leadingtraining to all Employers with staff having to use EXCEL Spreadsheets. The Facilitators are well informed and very knowledgeable and use excellent examples from the highly recommended training material.

Pact World

I will never regrate spending every second or taking this opportunity to learn with you. Thank you.

World Vision International

I like the fact that we get practical's to test our knowledge.

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 14 Apr 2026	Tue 14 Apr 2026	Not Applicable	Scheduled	Book Live Virtual Training

Powered by ClassPlanner

Submit Enquiry

Name

Email

Telephone

Query