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 - 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 outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.

Level - Fundamental
This course provides you with the skills needed to create highly professional slides and presentations with Microsoft PowerPoint.

Level - Intermediate
Well-designed documents represent and showcase your organisation and can have a great impact. This course introduces you to important design ideas and principles and shows you techniques for effective document design using text, graphics and other visual elements.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs