Microsoft Excel: Intermediate

TRAINING COURSE

Details Audience and Pre-Requisites Course Outline / Curriculum Schedule Dates and Booking Enquiry

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:

Download Brochure

Information may change without notice.

Customer Testimonials

Gauteng Provincial Treasury

I think overall, the training experience was excellent. I do not have any regrets.

BMW Group South Africa

Awesome training looking forward to using my knowledge at work

Shaeffler South Africa (Pty) Ltd

i really learnt so much. Gained so much knowledge. It was worth the time. I really enjoyed the overall training kept me motivated & I just wanted to know more as we went along

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  
Tue 8 Jul 2025 Tue 8 Jul 2025 Fourways

Book Live Virtual Training

Tue 5 Aug 2025 Tue 5 Aug 2025 Fourways

Book Live Virtual Training

Tue 2 Sep 2025 Tue 2 Sep 2025 Fourways

Book Live Virtual Training

Tue 30 Sep 2025 Tue 30 Sep 2025 Fourways

Book Live Virtual Training

Tue 28 Oct 2025 Tue 28 Oct 2025 Fourways

Book Live Virtual Training

Tue 25 Nov 2025 Tue 25 Nov 2025 Fourways

Book Live Virtual Training

Submit Enquiry

Name
Email
Telephone
Query