(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 - Fundamental
Explore key project management terminology and Microsoft Project's main features, including how to set up a schedule and resource pool, assign resources to tasks and how to track projects.
This course is designed for professionals looking to improve their practical use of Microsoft Teams, an increasingly common tool for modern workplace collaboration.
Level - Advanced
Working with long documents in Microsoft Word can be a challenge. We will show you how to format documents quickly and consistently, how to add numbered headings, create a table of contents, an index, table or figure captions and cross-references.
Level - Intermediate
This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.