(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 - Intermediate
This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured 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.
Level - Advanced
This course introduces the visualisation layer of Microsoft’s Power BI Desktop called Dashboards.
Level - Fundamental
Finding out how to use Microsoft Outlook as a time management tool, so you can manage the flow of emails and keep track of time, is probably the best decision you'll ever make!