Excel - Advanced Functions

Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.

Location
Date
Duration

2 Days

Time (AWST)
Address
Participants
Total

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.
Related Results

Level - Advanced
If you need to quickly and accurately make sense of your company's raw data, this Excel - KPI Dashboards course is for you. It introduces you to KPIs and dashboard design processes and will help you build an interactive KPI Dashboard.

Level - Intermediate
If you have used Microsoft Excel for some time and need to learn more, this Perth based training course provides you with additional skills. Take your basic knowledge to the next level and learn how to improve your Microsoft Excel skills.

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. 

Level - Fundamental
Using Microsoft Word efficiently will help you create good looking documents quickly. This course develops essential Word skills needed to create, edit, format and print documents.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs