Microsoft Excel Advanced Training Course

This Microsoft Excel Advanced Course is for people who already manage data well with Excel. They use it regularly and require advanced features to automate tasks. It is designed for Excel 2013, 2016, 2019 & 365.

Who is this course for?

Our Microsoft Excel Advanced course is suitable for those with a good working knowledge of Excel who wish to progress to the more complicated functions and features.


A good working knowledge of Microsoft Excel, or our Excel Intermediate course.


  • At the end of this advanced Excel course you will have a complete understanding of the higher functions of Excel.
  • You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.

Course Outline

Using logical functions

The IF function (recap)
Creating nested IF functions
The IFS function
AND and OR functions
Combining logical functions

Working with Lookups

The VLOOKUP function
The HLOOKUP function
The XLOOKUP function (365)

Data Validation

Using data validation
Setting criteria for entry of text, values and dates
Creating a dropdown list

PivotTables and PivotCharts

Creating and rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTables

Using analytical options

Using Goal Seek
Creating, saving and viewing scenarios
Creating single input data tables
Creating double input data tables
Projecting with data tables


Creating macros
Using the macro recorder
Viewing and editing macro VBA code

Training Mode

  • Online/virtual
  • Physical/in-person

Get In Touch

Send us a message & we will respond shortly


Registration Form

Enter your name, like you want it to appear on your Certificate