This financial modeling course covers Financial Modeling Fundamentals plus Advanced Excel for Financial Modeling.
Our financial modelling course provides a sound understanding of both the principles of financial modelling and the practical application of these to real-world situations by using Excel to build financial models.
The course builds upon the financial modelling principles and practices learned to apply these to company or project valuations. In this, participants improve their mastery of valuation principles and concepts, and learn how to apply these in real-life situations.
Finally, participants will receive training in how to both detect and prevent errors from occurring.
Excel is the tool of choice for most financial modellers so before we start building financial models, it’s critical that we have a good understanding of the key functions and tools in Excel that can help us build models that are robust, easy-to-use, and flexible.
Here are just some of the areas we cover in our in-depth, hands-on workshop:
● Working with large data sets
● Summarising and aggregating data
● Extracting data that matches criteria using flexible formulas
● Error handling
● Ways of improving structure
● Techniques for keeping formulas constant yet flexible
● Combining and splitting cells according to the content they contain
● Advanced techniques for creating automatically expanding charts and ranges
● Introduction to macros & when to use these
We then apply and practise these functions during the remainder of the course.
Duration Learning Credits
2 days – 16 hours of 16 PDU’s
Session
Public Classroom Pricing:
Early Bird Price: AUD 1695.00
Regular Price: AUD 1795.00
Instructor-Led Virtual Live Pricing:
Early Bird Price: AUD 1295.00
Regular Price: AUD 1495.00
Private Group/ In-House Learning:
Have a group of 3 or more people?
Register yourself with a special pricing and
request the training exclusively
Bring Your Models!
Everyone’s models are different. As such, participants are encouraged to bring along their own financial models to obtain assistance, ideas, guidance and suggestions from the trainer in private.
This is a key step in applying the concepts learned on the course to improve real-life models so please take the opportunity to draw on the trainer’s experience and expertise!
● Business & Finance Analysts
● Finance Managers
● Investment Managers
● Investment Analysts
● CFO’s
● Financial Modellers
● Project Managers
● Project Accountants
● Investment & Corporate Bankers
● Corporate Finance Managers
● Finance Professionals
● Accountants
● An excellent working knowledge of financial modelling functions in Excel that allow you to efficiently create robust and flexible models.
● A sound understanding of financial modelling and valuation concepts.
● Practical experience in designing solutions to real-world financial modelling challenges by building financial models in Excel.
● A solid foundation for Excel-based financial modelling.
● Excel tools and techniques that are essential for modelling to make your models robust, user-friendly, and efficient.