Our Masterclasses are hands-on, in-depth, expert-led sessions, designed to take your skillset and financial modelling approach to the next level. Our Masterclass leads are here to tell you everything they know — and how they learned it. Explore:
Masterclass I: Introduction to VBA for Financial Modellers
- Masterclass Lead: Matthew Bernath, Head of Data Analytics at Rand Merchant Bank, Host of the Financial Modelling Podcast
- Masterclass Description: VBA is the programming language allowing you to fully automate your financial models and simplify complex tasks like calculating Debt Service Reserve Accounts. This masterclass will teach you the fundamentals of Excel VBA. Learn what VBA is, how it interacts with Excel and how to take your recorded Macros to the next level.
Masterclass II: The Fundamentals of Best Practice Financial Modelling
- Masterclass Lead: Giles Male and Myles Arnott, Co-Founder of Full Stack Modeller
- Masterclass Description: In this session Giles and Myles look at some practical examples and exercises of best practice financial modelling, with a particular focus on the FAST Standard.
Masterclass III: Financial Modelling for Startups
- Masterclass Lead: Matthew Bernath, Head of Data Analytics at Rand Merchant Bank, Host of the Financial Modelling Podcast
- Masterclass Description: Learn why a financial model is crucial to start, fund and scale your business
Masterclass IV: Project Finance Modelling: Introduction to debt sizing, debt sculpting, cover ratios and debt service reserve accounts.
- Masterclass Lead: Kenneth Whitelaw-Jones, Partner at Gridlines, Head of Financial Modelling at Cranmore Partners, Co-Founder of Project Finance Institute and Full Stack Modeller
- Masterclass Description: In this hands on, practical session, Project Finance Institute Co-Founder Kenny Whitelaw-Jones teaches you some core PF modelling concepts. Worked example models will be made available to all participants.
Masterclass V: Data Visualisation for Financial Modelling
- Masterclass Lead: Jordan Goldemeier, Microsoft MVP, Book Author
- Masterclass Description: In this class, Jordan focuses on what financial modelers need to know to communicate data effectively. The first part of the class reviews important data visualization principles. In the second part of the class, Jordan focuses on creating interactive data visualizations in Microsoft Excel that you can start using immediately.