Microsoft Excel - Formulas & Functions Course


Objectives of this course are to enable experienced users of Microsoft Excel to increase their knowledge of formulae and functions and their use in a variety of spreadsheet applications.  


This is best for

Experienced Excel user who wants a greater understanding of more sophisticated formulas & functions within Excel.



Working with Multiple Sheets

  • Grouping sheets for editing & linking data from multiple sheets
  • Create 3 dimensional formulae
  • Manage multiple sheets with data consolidation

Excel Formula & Functions

  • Scoping a formula
  • Working with specific function groups including -

    • Text
    • Date/time
    • Statistical
    • Maths
    • Financial
    • Lookup & reference
    • Logical
  • Nesting & combining functions
  • Formula referencing

Cell Referencing

  • Working with labels and names


  • Protecting worksheets
  • Protecting workbooks


Learning outcomes

On completion of this course participants will be able to use multiple files, link these with formulae and work with three dimensional ranges.

They will have an understanding of a wide range of functions and their application and how to build complex formulae and functions.


Completion of Microsoft Excel Introduction and Intermediate course or equivalent knowledge is required.



1 day


Software versions

Available for 2010, 2013, 2016 & 365



Book Now





Course Information


  • Interactive, practical and hands on learning
  • Facilitator led training
  • Comprehensive take-home training and reference manual
  • Post-course Help Desk support
  • Certificate of Attendance for participants
  • Morning & afternoon refreshments
  • Delicious cafe lunch
  • Post course follow up

Enjoy Perth's best CBD training venue:

Cloisters Level 1, 863 Hay Street
Perth CBD

Real People, Real Conversations, Real Results

Roving Training

Need IT Training? Don't have time to go on a course? We are happy to come to you!

One of our expert instructors roams your workplace calling in any users that require coaching in any desktop applications. 

Roving training is perfect if numerous employees need some tips and tricks on various programs. Training is tailored to your individual needs and we are able to train using your own documents.   


Customised Solutions

We understand one size does not always fit all. Our team of qualified trainers can create a customised solution tailored to your specific needs.

We are happy to offer closed group sessions or additional dates as you require.

To discuss customisation training, simply call 08 9218 9059 or email


Logo Bulb

Enriching lives.
Empowering organisations.