Skip to main content Help with accessibility Skip to main navigation
Updated on: 19-10-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
  • Use the Format Painter
  • Use the Split and Freeze Panes to change the view
  • Protect spreadsheets
  • Create Pivot Tables and Pivot Charts

Topics covered

Complex Functions

  • VLOOKUP
  • XLOOKUP
  • SUMIF
  • CONCATENATE
  • IFERROR
  • Formula Auditing

Advanced Formatting

  • Conditional Formatting
  • Apply the Format Painter
  • Split and Freeze columns

Protection

  • 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.5 hours

Login