(08) 9383 8000
Excel - Intermediate Functions
Well-structured formulas make it easier to analyse information, perform calculations and work accurately with data in Excel.
This practical one-day course expands your knowledge of Microsoft Excel functions and formula structure. You will work with relative and absolute cell references, named ranges, common functions, Insert Function and formula auditing tools.
What to expect
You will work through practical examples to understand how formulas and functions are structured. You will apply relative and absolute references, create named ranges and use a range of functions for calculating, counting, looking up, rounding and working with dates.
The course also introduces the Insert Function feature and formula auditing tools. These features can help you locate suitable functions, check how formulas work and troubleshoot common errors.
Is this course for you
This course is for anyone who is comfortable with basic Excel and wants to create and use formulas with greater confidence. It is suited to people who use Excel for day-to-day calculations and want to strengthen the structure and accuracy of their work.
This course is suited to individuals who want to
create clearer and more accurate formulas
understand relative and absolute cell references
use named ranges to make formulas easier to manage
apply common functions to workplace data
locate suitable functions using Insert Function
check formulas and troubleshoot errors
What you will explore
During this training course, you will develop skills in building structured, reliable Excel formulas. The course focuses on referencing, named ranges and the use of functions within formulas, helping participants work more accurately and efficiently with business data.
This course offers the opportunity to:
Create well-structured formulas using relative and absolute referencing and named ranges
Understand and use functions within formulas
Where this course can take you
Level – Advanced.
Designed for users ready to deepen their Power BI capability, this course builds on Level 1 and strengthens your ability to work with advanced DAX, time-based analysis and dynamic visualisation tools.
You’ll learn techniques that support richer insights and more flexible reporting.
Level – Intermediate.
If you want your documents to look more polished and professional, this course helps you build the skills to manage layouts, visuals and formatting with confidence.
You will learn how to work with tables, images and diagrams to create clearer, more engaging documents.
Level – Fundamental.
If you’re new to Microsoft Project, this course helps you plan and track work with confidence.
You will learn how to set up schedules, allocate resources and monitor progress so your projects stay organised and on track.
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.