Financial Modelling in Excel (Online)

Can't make it to a workshop?  Enrol in the online version of the Financial Modelling course, and start straight away!  Complete the course at your own pace.

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

Modules in this Course

Price: $175.00 ex GST