Skip to main content Help with accessibility Skip to main navigation
Updated on: 25-10-2022

Excel Advanced - half day online

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

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

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 Quiet room with access to MS Teams and headset or headphones
Duration of Training 2 - 2.5 hours

Login