We have partnered with Chartered Accountants Australia and New Zealand to bring to you this two day course that will help you quickly progress from simply working with spreadsheets to fully mastering the principles and benefits of financial modelling and focused analysis. You will learn how to decrease risk in your use of Excel and financial models and be able to confidently repair models that are broken.
Pre-requisite knowledge
Those wanting to attend this course should be comfortable with the Excel functions and features listed below as well as keyboard shortcuts for speed and efficiency. These are covered in our Excel Diploma for Chartered Accountants course.
Functions
-
Essential calculation functions – SUM, AVERAGE, COUNT
-
Date calculations – EOMONTH, EDATE, YEAR, MONTH, DATE
-
Logical statements – IF, AND, OR
-
Lookup functions – LOOKUP, INDEX and MATCH
-
Advanced data functions – SUMIF, SUMPRODUCT
Features
-
Data tables
-
Conditional formatting
-
Data validation
-
Named ranges
-
Styles
Laptop set-up: Please note you are required to bring your own laptop, power cord and external mouse to this course. We strongly recommend using a PC over a Mac due to the difference in shortcuts, however if you are confident using a Mac then this will be fine.
To view the course outline, expand the link below.