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