Microsoft Excel Intermediate.

About This Course

Course Code

Course Type


2 Days


Course Overview

Special Notices

Please note that this course uses Microsoft Excel for Windows. It is not suitable for Excel for MAC. Courses for MAC users are available on request

For customers attending remotely via Virtual Classroom or ‘Attend From Anywhere’, an additional screen is required for this course to work through remote desktop labs and view training information.

This course is suitable for anyone using Excel 2013 or later. If delivered in a Nexus training centre, it will be delivered using Excel 2019.


The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and auditing. You will also organise table data and present data as charts.

The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.


Course Outline

Module 1: Formulas

Module 2: The Auditing tools

Module 3: Working with data lists

Module 4: Filtering data lists

Module 5: Mastering Excel tables

Module 6: Charts

Module 7: Additional features

Module 8: Conditional formatting


This course is aimed at existing Excel users who need to further their knowledge. Delegates are assumed to have experience of entering data and writing basic formulas, including common functions such as SUM and AVERAGE.

Dates & Prices

Tuesday 31st August 2021


Thursday 9th September 2021


Monday 20th September 2021


Monday 11th October 2021


Monday 25th October 2021


Thursday 4th November 2021


Monday 8th November 2021


Thursday 9th December 2021


Monday 20th December 2021