Skip to main content Help with accessibility Skip to main navigation
Updated on: 25-06-2021

Excel Advanced - half day online

At the end of the session all delegates will:

On successful completion of this course you will be able to:

  • Create complex functions
  • Apply Conditional Formatting
  • Protect spreadsheets
  • Create Pivot Tables and Pivot Charts

Topics covered

Complex Functions

  • Vertical Lookups
  • Horizontal Lookups
  • Sumif and CountIf

Advanced Formatting

  • Conditional Formatting


  • Protecting Sheets
  • Protecting Cells

Pivot Tables

  • Creating a Pivot Tables
  • Editing a Pivot Table
  • Using Pivot Charts

Online training will be delivered via MS Teams. You will receive joining instructions before your selected session

About the course

Course Code MLCSU-TR0087
Intended Audience Regular users of Excel or those who have completed the Excel Introduction and Intermediate course
Delivery Method Online
Required Experience / Training Attendees to have completed the Excel Introduction course or have equivalent work based experience
Duration of Training 2 hours - 2.5 hours