Skip to main content


Excel Advanced:

Analyse data using Pivot Tables, Automate repetitive task with Macros and build on existing formula knowledge with Nested ifs and Text manipulation formulae.

Course Outline
Excel Advanced 1 Day

Who is it for?

The course is suitable for existing users of Microsoft Excel wanting to further their knowledge – this course covers automating spreadsheets and using advanced data handling techniques.


Delegates should have a good knowledge of the Introduction and Intermediate outline.

Advanced Functions
An in-depth look into:
  • Nesting IF’s
  • And/Or Functions
  • Array Formulas
  • Text Functions
  • Database Functions
  • New formulas; XLOOKUP, Filter, Sort and Unique (O365 only)
Pivot Tables
Pivot Tables and Pivot Charts:
  • Creating and Editing Tables & Charts
  • Refreshing Data
  • Displaying Pages
  • Slicers
Templates & Editing
Templates & Advanced Editing Techniques:
  • Creating & Editing Templates
  • Deleting Templates
  • Paste Special & Paste Link
  • Data Validation
  • Custom Views
  • Shared workbooks
Spreadsheet Automation
Working with Macros:
  • Creating & Naming Macros
  • Absolute and Relative Macros
  • Creating Macro Buttons
  • The VBA screen

Microsoft Excel, Software