Great Minds, Always Changing

Excel Advanced

By the end of this course you will be able to use advanced formulae, data consolidation and working with pivot tables. You will also be able to create macros, use auditing tools and be able to share and protect your workbooks.

Course details

Working with advanced formulae

  • Refresher on Logical functions
  • Using Lookups, Vlookups and Hlookups
  • Nesting formulas
  • Managing Error messages
  • Using Rounding Functions
  • Using the Watch Window
  • Auditing Workbooks
  • Tracing Errors

Data Consolidation

  • Grouping and Outlining Data
  • Using the Subtotalling Tool
  • Creating Advanced Filters
  • Removing Duplicates from a spread sheet

Pivot Tables

  • Creating a Pivot Table and Pivot Chart
  • Inserting fields into the Pivot Table
  • Creating Calculated fields
  • Grouping fields
  • Using Drilldown to analyse data
  • Creating a Pivot Chart

Using Macros and Auditing Tools  

  • What is a Macro?
  • Recording a Macro
  • Running a Macro
  • Editing a Macro

Sharing Workbooks

  • Creating a Shared Workbooks
  • Protecting Columns
  • Protecting Worksheets
  • Protecting Worksheet Content
  • Protecting Cells
  • Assigning a Password
  • Tracking Changes
  • Adding Comments
  • Preparing a Workbook




1 day (but can be run as shorter sessions)

Course Requirements

A good understanding of Excel is assumed. Take a look at our Introduction and Intermediate course topics to assess the level you require.


Email the Training Team for more information and availability at