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

Excel Intermediate - 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 formulae and functions
  • Define and manage Range Names

Topics covered

Complex Formulae

  • Review of simple formulae
  • Formulae with relative referencing
  • Formulae with absolute referencing


  • Statistical Functions
  • Logical Functions

Range Naming

  • Defining Range Names
  • Using Range Names in formulae and functions
  • Mange Range Names

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

About the course

Course Code MLCSU-TR0086
Intended Audience Regular users of Excel or those who have completed the Excel Introduction 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