Excel - Formulas and Functions

Level - Intermediate
This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.

Location

Date

Duration

1 Day

Time (AWST)

Address

Participants

Total

Overview

The Excel - Formulas and Functions course will help you to create well-structured formulas using relative and absolute referencing and named ranges. It will help you to understand and use various functions in formulas, including the Insert Function feature.

Content

Understand relative and absolute cell referencing in formulas
Create and use named ranges in formulas
Understand the structure of formulas and functions
Calculate totals using AutoSum
Use functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, COUNTIF, SUMIF and VLOOKUP
Use the Insert Function feature
Trouble-shoot formula errors using formula auditing.

Learning Outcomes

Participants should be able to:

Create well-structured formulas using relative and absolute referencing, and using named ranges.
Understand and use functions in formulas.

Related Results

Excel - Advanced

Level - Advanced
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.

See course page

Excel - Intermediate

Level – Intermediate. Move beyond the basics and streamline your work.

Designed for people who want Excel to work faster and smarter, this course introduces tools and techniques that improve efficiency, accuracy and presentation. You’ll learn how to use time-saving features, create stronger visuals and manage data across multiple sheets and workbooks.

See course page

PowerPoint - Skills for Designers - Visual, Data & Multimedia Creation

Level – Fundamental.

If you want your presentations to look clearer and more polished, this course helps you build the practical design skills to create slides that communicate with impact.

You will learn how to structure layouts, use templates effectively and enhance content with data visuals and multimedia elements that support clear, engaging communication.

See course page

Excel - Advanced Functions

Ready to lift your Excel capability?

This course helps you use advanced functions with confidence so you can clean data, match information and create reliable results.

You’ll learn to structure, nest and troubleshoot formulas that simplify complex tasks and improve the quality of your analysis.

See course page

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs