(08) 9383 8000
Excel - Advanced Functions
Advanced Excel functions can help you analyse, clean and manipulate business data with greater efficiency and accuracy.
This practical one-day course develops your ability to build well-structured, complex formulas. You will work with advanced logical, lookup, reference, statistical, date and text functions, along with defined names, nested functions, Flash Fill, spill formulas and dynamic arrays.
What to expect
You will work through practical examples using business data to understand how advanced formulas are structured, combined and applied. You will explore functions such as IF, AND, OR, XLOOKUP, XMATCH, FILTER, PIVOTBY and GROUPBY.
The course also examines how defined names can improve formula structure, how functions can be nested to address more complex requirements and how spill formulas work within dynamic arrays. You will use date, text and Flash Fill tools to organise, transform and clean data
Is this course for you
This course is for anyone who already uses Excel formulas and wants to expand into advanced functions. It is suited to people who work with business data and want to improve the productivity, structure and accuracy of their Excel work.
This course is suited to individuals who want to
build more complex and reliable Excel formulas
use advanced functions across different categories
combine functions to address more complex data requirements
retrieve, analyse and summarise information more efficiently
clean and transform data imported from other sources
work with dynamic arrays and spill formulas
What you will explore
During this training course, you will develop skills in building complex Excel formulas to work more efficiently with data. The course focuses on structured formula design, nested functions and data transformation, helping participants improve the accuracy and productivity of their Excel work.
This course offers the opportunity to:
Build well-structured, complex formulas to work more efficiently with data
Use functions and nested functions
Use Flash Fill to transform and clean data
Where this course can take you
Level - Advanced.
Turn Excel into a decision-making tool. Transform the way you work with data by using Excel’s advanced analytic functions and modelling tools.
You’ll build the skills to compare scenarios, optimise results and interpret complex information with confidence.
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.
Built for users who want to turn data into clear, interactive visuals, this course introduces the core features of Power BI Desktop.
You’ll learn how to connect to data, work with the data model and create dynamic reports using DAX measures and built-in visualisations.
Level – Advanced.
If you work with long or detailed documents, this course builds the skills to structure, format and manage them with confidence.
You will learn how to keep reports consistent, add references and produce polished, professional outputs.