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%
Learning Objectives
During the course, participants will create their own financial model to take away and use for future reference. You will learn how to design and create a user-friendly model which can then be used by anyone with limited knowledge of Excel.
You will learn how to:
- Build a financial model from scratch, or modify and improve an inherited model
- Reduce errors by building in error checks
- Prevent incorrect use of your model by protecting worksheets
- Validate data entry by setting data entry parameters
- Create a navigation page to help users find their way around your model
- Create drop-down boxes which enable a model to produce a series of results depending on scenario variable selected
- Mitigate liability by providing assumptions
- Present findings in a concise and meaningful way
Prerequisites
Students are expected to be reasonably regular Excel users, and should be comfortable with simple formulas and linking between workbooks.
More detail about how the online courses work
What does the course content look like?
If you’d like to see a 5 minute preview of one of the videos, take a look at the Skills Needed for Financial Modelling section. Each of the six modules in this course contains downloadable PDF course notes of between 15 and 30 pages long which contain extracts from Using Excel for Business Analysis, and step by step instructions.
For a shorter overview, watch here for a 70 second preview to give you an idea of the quality of the videos:
What’s Included?
- 12 months access to course materials
- 3.5+ hours of video lessons
- Downloadable PDFs and Excel templates
- 12 months access to the support centre
Price: A$240 ex GST. Purchase this course.
