Skip to main content
Get a Quote
Course Enquiry
Contact Us
Microsoft Excel: Intermediate

RELATED COURSES


TRAINERS FOR COURSE


CUSTOMERS ON THIS COURSE

Details

You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

This course is designed for students who already have foundation knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

On completion of the Excel Basic, Intermediate and Advanced Courses,  delegates may also write the Microsoft Office Specialist Exam, 2016 Exam 77-727 online.

 

Delivery Methods

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of four delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method Duration Price (excl. VAT)
Fulltime 1 Day R 2,649.00
Webinar 1 Day R 2,050.00

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Download Brochure


Information may change without notice.

Audience

The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyse data, and work with Excel on the web

Pre-Requisites

Microsoft Office Excel Basic

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.

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of four delegates. We remain committed to offering training that is fast, focused and effective.

Start Date End Date Branch Status  
Tue 7 Jun 2022 Tue 7 Jun 2022 Not Applicable Scheduled

Book Webinar

Tue 21 Jun 2022 Tue 21 Jun 2022 Not Applicable Scheduled

Book Webinar

Tue 5 Jul 2022 Tue 5 Jul 2022 Not Applicable Scheduled

Book Webinar

Tue 19 Jul 2022 Tue 19 Jul 2022 Not Applicable Scheduled

Book Webinar

Tue 2 Aug 2022 Tue 2 Aug 2022 Not Applicable Provisional
Tue 16 Aug 2022 Tue 16 Aug 2022 Not Applicable Provisional
Tue 30 Aug 2022 Tue 30 Aug 2022 Not Applicable Provisional
Tue 13 Sep 2022 Tue 13 Sep 2022 Not Applicable Provisional
Tue 27 Sep 2022 Tue 27 Sep 2022 Not Applicable Provisional
Tue 11 Oct 2022 Tue 11 Oct 2022 Not Applicable Provisional
Tue 25 Oct 2022 Tue 25 Oct 2022 Not Applicable Provisional
Tue 8 Nov 2022 Tue 8 Nov 2022 Not Applicable Provisional
Tue 22 Nov 2022 Tue 22 Nov 2022 Not Applicable Provisional
Tue 6 Dec 2022 Tue 6 Dec 2022 Not Applicable Provisional