Skip to main content Help with accessibility Skip to main navigation
Updated on: 19-10-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
  • Applying BODMAS
  • Create a 3D Reference (total of multiple sheets) and create a summary sheet

Functions

  • Statistical Functions (sum/average/count/min/max/countif)
  • Logical Functions (IF function)
  • Create a 3D Reference (total of multiple sheets) and create a summary sheet

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

Login