Skip to main content Help with accessibility Skip to main navigation
Updated on: 17-05-2024

Excel - Intermediate (half day)

Topics covered

Complex Formulae

  • Review of simple formulae
  • Formulae with relative referencing
  • Formulae with absolute referencing
  • Applying BODMAS
  • Create a 3D Reference (total of multiple sheets) and create a summary sheet


  • Statistical Functions (sum/average/count/min/max/countif)
  • Logical Functions (IF function)

Range Naming

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

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

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