Excel - Formulas and Functions

Level - Intermediate.

Strengthen your ability to analyse and calculate with Excel.

Designed for those ready to move beyond the basics, this course shows you how to use formulas and functions that make your spreadsheets smarter and easier to work with.

You’ll learn how to structure formulas well, use named ranges and troubleshoot errors so your calculations stay accurate and reliable.

Location

Date

Duration

1 Day

Time (AWST)

Address

Participants

Total

What to expect

Formulas and functions sit at the heart of Excel, enabling you to calculate, analyse and organise information with accuracy. This course builds on your existing skills and introduces the techniques that make formula writing clearer, faster and more dependable.

You’ll explore the structure of formulas, work with relative and absolute references and use named ranges to simplify calculations. Through guided practice, you will apply commonly used functions and learn how to choose the right one for the task at hand.

The course also covers troubleshooting so you can identify and resolve errors using formula auditing tools. By the end of the program, you’ll be able to create well-structured formulas, work confidently with functions and manage spreadsheets with greater accuracy.

Is this course for you

This course is ideal for those who are comfortable with Excel basics and want to build greater confidence in creating and using formulas for day-to-day tasks.

This course is suited to individuals who want to:

create and use Excel formulas with confidence
improve accuracy and efficiency in everyday spreadsheet tasks
apply formulas to solve common workplace problems
strengthen practical Excel skills for daily use

What you will explore

During this training course, you will build confidence in creating and managing Excel formulas to analyse data accurately and efficiently. The course focuses on using relative and absolute references, applying named ranges, working with key functions, and troubleshooting common formula errors.

By the end of this training course, you should be able to:

Create formulas using relative and absolute references
Apply named ranges for easier formula management
Work with a variety of Excel functions to analyse data
Use the Insert Function feature to streamline your work
Troubleshoot and fix formula errors effectively

Where this course can take you

During this training course, you will explore relative and absolute cell referencing and learn how to create and use named ranges in formulas. You will develop a clear understanding of the structure of formulas and functions and calculate totals efficiently using AutoSum.

The course also focuses on commonly used functions such as SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, COUNTIF, SUMIF, and VLOOKUP. You will learn how to use the Insert Function feature and apply formula auditing tools to troubleshoot and resolve formula errors.