(08) 9383 8000
Excel - Advanced Functions
Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.
2 Days
Overview
The Excel - Advanced Functions course will help you to build well-structured, complex formulas to work more efficiently with data. It will explore Logical, Lookup, Reference and Statistical functions and how they are used.
Content
- Understand Defined Name ranges
- Work with advanced functions
- Use Logical Functions: IF, OR, AND, plus more
- Learn how to use Lookup functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH
- Understand how Dates work and use appropriate functions: DAY, MONTH, YEAR, DATE, plus more
- Understand how to use Text functions to clean-up and manipulate text data imported from external databases
- Understand what a spill formula is and how to use them
- Use formula auditing tools to trouble-shoot errors in formulas.
Learning Outcomes
Participants should be able to:
- Build well-structured, complex formulas to work more efficiently with data
- Use functions and nested functions
- Use formula auditing tools to trouble-shoot errors in formulas.
Build practical confidence using Claude for everyday workplace tasks.
This course helps non-technical professionals use Claude to draft, summarise, analyse, structure and refine work with clearer prompts, stronger judgement and responsible AI practice.
Level - Advanced
This course introduces the visualisation layer of Microsoft’s Power BI Desktop called Dashboards.
Level - Intermediate
This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.
Level - Advanced
This course builds on the Power BI Desktop - Level 1 course. It introduces you to more advanced DAX (Data Analysis Expressions) concepts including variable and advanced functions.