This course is part of the Financial Modelling Online Series:
- Financial Modelling for Non Financial Modellers (Financial Modelling for Dummies)
- Best Practice Financial Modelling in Excel (Intermediate)
- Practical Financial Modelling in Excel (Advanced)
Buy all three courses at once and save 35%.
In the ever-changing business environment, being able to accurately model and forecast the volatile economic inputs is a critical skill for business professionals. Build on your existing modelling skills and apply new techniques to better analyse financial data, predict revenues and cost and assess risks to justify business decisions in the most time-efficient and effective way.
More detail about how the online courses work
Who should complete this course?
The course material includes extensive use of Excel and participants will gain the maximum benefit from this course if they are already competent spreadsheet users. It is designed for those who have already undertaken the Introduction and/or Intermediate Financial Modelling in Excel courses or users who do use Excel on a regular basis, and are comfortable with using its tools and functions.
What are the prerequisites for taking this course?
At minimum, it is assumed that participants will know how to:
• Navigate confidently in Excel
• Use absolute cell references (e.g. =$A$1)
• Create and use advanced Excel tools and functions on a regular basis
This course builds on students’ advanced knowledge of Excel tools and functions and incorporates these into complex and dynamic financial models.
More detail about how the online courses work
Testimonials
Hear what past students have to say about the online Advanced Financial Modelling course:
What’s Included?
- 12 months access to course materials
- 3+ hours of video lessons
- Downloadable PDFs and Excel templates
- 12 months access to the support centre
What’s in the case study?
- Building on the tools and techniques covered, we will learn to apply advanced modelling skills to build complex, yet robust and user-friendly financial models.
Factory Rollout Model
- Working on a startup funding model from start to finish we will evaluate input assumptions, calculate revenue and costs of production to calculate cash requirements. From this, we build a full set of financial statement with particular emphasis on linking the profit & loss statement, cash flow statement and balance sheet together.
- Utilising the tools and techniques covered in the first part of the course, participants will build their own financial model case study, performing stress testing, scenario and sensitivity analysis on their model.
Price: A$240 ex GST. Purchase this course.
