(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.
Level - Advanced
This course introduces additional skills to develop your knowledge of Microsoft Excel by focusing on advanced functions and productivity tools.
Level - Intermediate
Do you want to create presentations with a difference? Including movie clips and sound tracks is easier than you might think. They bring presentations to life and can make your message truly memorable.
Level - Intermediate
This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.
This course provides an in-depth understanding of the advanced features of Teams, enabling participants to enhance workplace collaboration, communication, and effectiveness.