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.

Location

Date

Duration

2 Days

Time (AWST)

Address

Participants

Total

What to expect

Advanced functions allow you to manage data with far greater precision and control. This course builds on your existing knowledge and introduces the formulas used to match data, clean information, return flexible results and automate repetitive steps across your spreadsheets.

Through guided demonstrations and hands-on practice, you will use lookup, logical, text and date functions to streamline data preparation and analysis. You’ll explore how these functions work together, how to nest them effectively and how to structure formulas so they remain clear and reliable.

You will also learn how to audit formulas, interpret errors and apply spill formulas for more efficient outputs. By the end of the course, you’ll have practical skills that help you build robust spreadsheets and work more confidently with complex data.

Is this course for you

This course is ideal for those who already use Excel formulas and want to expand into advanced functions to boost productivity and accuracy.

This course is suited to individuals who want to:

use advanced Excel functions with confidence
improve accuracy in calculations and analysis
increase efficiency through smarter formula use
apply advanced functions to real workplace tasks

What you will explore

During this training course, you will develop advanced Excel formula skills to work more efficiently and accurately with data. The course focuses on building and combining powerful functions, cleaning and formatting data, applying logical tests, and confidently troubleshooting and auditing formulas to support reliable analysis and reporting.

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

Build well-structured formulas using advanced functions such as VLOOKUP, HLOOKUP, INDEX and MATCH
Combine multiple functions into nested formulas for more flexible results
Use text and date functions to clean and format data
Apply conditional logic to test for different outcomes
Troubleshoot and audit formulas with confidence

Where this course can take you

During this training course, you will explore defined name ranges and techniques for structuring data to improve clarity and efficiency in Excel. You will learn how and when to apply advanced functions, including logical functions such as IF, OR, and AND, along with lookup functions like VLOOKUP, HLOOKUP, XLOOKUP, INDEX, and MATCH.

The course also focuses on working with dates using functions such as DAY, MONTH, YEAR, and DATE, and using text functions to clean and manipulate data imported from external sources. You will develop skills in using spill formulas effectively and applying formula auditing tools to identify, trace, and resolve errors.