Microsoft Excel Advanced Training Course

Microsoft Excel Advanced


Interactive Sessions
We’ll show you how to put the skills from your Microsoft Excel Advanced course into practice
Easy to Follow
Easy to follow examples to help you start using the software immediately after the course
Always Engaging
Our training courses have been designed to be interactive and engaging, no matter how you attend

Microsoft Excel Advanced Course – Details

Course Aim

Our one day Online Microsoft Excel Intermediate training course will provide slightly more advanced knowledge of the use and functions of Microsoft Excel.

Many of us need to use Microsoft Excel in our jobs to produce a range of spreadsheets to show a wide range of business data.

Our Microsoft Excel Intermediate Training Course is designed to provide those who attend with a more advanced knowledge of using this very much used software.

Course Objectives

Those who attend this Microsoft Excel Advanced Training Course will be able to:

  • Create sophisticated spreadsheets that include complex functions
  • Use analysis tools to summarise and extract data
  • Use pivot tables, scenarios and database functions and auditing tools
  • Use macros to automate tasks

Course Content

Here’s what we cover in our Microsoft Excel Advanced training course:

Formulas and Functions

  • Date and time functions
  • Math and trig functions
  • Logical functions
  • Statistical functions
  • Look up and reference functions
  • Text functions
  • Financial functions
  • Data tables
  • Information functions

Formula Auditing

  • Cell comments
  • Formula error checking
  • Using the watch window
  • Copy and paste special

What-IF Analysis Tools

  • Creating, editing and deleting scenarios
  • Scenario summary reports
  • Using goal seek
  • Using solver

Multiple Workbooks

  • Arranging workbooks
  • Entering formulas across workbooks
  • Linking information across workbooks
  • Linking information across applications

Advanced Lists

  • Advanced filters
  • Database functions
  • Grouping and outlining
  • Data validation
  • Go To Special

Introducing Pivot Tables

  • Creating a pivot table
  • Extracting data from a pivot table
  • Pivot calculations
  • Sorting, grouping and filtering pivot data
  • Pivot chart reports

Templates and Views

  • Designing and saving templates
  • Creating and using custom views


  • Amending chart values
  • 3-D Charts
  • Creating projections with trend lines
  • Creating combination charts
  • Custom chart templates

Automation and Macros

  • Recording and running macros
  • Deleting macros
  • Editing macros
  • Macro virus protection

When you bring this course in-house, the content above can be tweaked and changed to meet the needs of your team.

Online Training Courses

A 1 day online live virtual training course with one of our highly experienced Excel trainers. You also get:

  • A highly interactive online experience
  • Access to MyRevolution Learning to retain access to your materials and stay in touch with your trainer
  • A digital copy of the course materials from the course
  • A digital course certificate

In-Person & Online In-House

A 1 day training course with one of our highly experienced trainers at your location. You also get

  • Course materials for each delegate to take away
  • A course certificate
  • Reporting on delegate evaluation
  • Access to MyRevolution Learning to retain access to your materials and stay in touch with your trainer

Our Microsoft Excel Advanced courses are delivered by our friendly and highly experienced trainers. We live and breathe what we talk about in these sessions as we use most of the tools and techniques ourselves on a daily bases and bring this real-world experience into the session and the examples that we use.

If you are attending one of our scheduled online courses, these courses are delivered via Zoom. If we deliver the course just for your organisation, we can use the platform you are most comfortable with.

You will need to have the most up-to-date version of the software installed on your device as well as the Zoom app, or if we are delivering this just for your organisation, the software relating to the platform we are using for delivery.

Open Online Course

Our Online Microsoft Excel Advanced course is an interactive live virtual course. The content remains the same but the delivery and approach has been re-imagined for the virtual environment. Our online training courses are delivered by Zoom.

In-House Delivery

We can also deliver this Microsoft Excel Advanced course just for your organisation. We can do this in-person at your office or a location of your choice or as a live virtual training course. We can deliver this via Zoom, Teams, Webex or any other platform that you are currently using and comfortable with.

Here are the most recent reviews that have been left for our Microsoft Excel Advanced Training Course. If you would like to see more detailed reviews then please get in touch and we can pull some data from our course evaluations together for you.

Course Delivery Methods

Here’s how we deliver our Microsoft Excel Advanced Training Course. Click an option to see the full details.

Join our live online virtual Microsoft Excel Advanced training course from work or home for an interactive online learning experience.

1 Delegate
£215.00 + VAT
2 Delegates
£204.25 + VAT
3 + Delegates
£182.75 + VAT

Price per delegate includes multiple person discounts. Group booking price only applicable when delegates book onto the same course date.

Bring this Microsoft Excel Advanced training course in-house and train your team together at the same time.

  • Delivered online or in person at your business premises
  • Course content can be tailored to your specific requirements

Complete the form below to get a personalised quote from a member of our team.

Short Contact
Delivery Type
Would they all be attending in the same group or split across smaller groups?