Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.
2 Days
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.
Participants should be able to:
Level - Fundamental
In this course you will learn how to add data, edit and move data and how to format and print spreadsheets. You will create charts and use formulas and functions for simple calculations.
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 - Intermediate
If you have used Microsoft Excel for some time and need to learn more, this Perth based training course provides you with additional skills. Take your basic knowledge to the next level and learn how to improve your Microsoft Excel skills.
Level - Advanced
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.