Our Day 3 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

Date: Friday, 25 June

Time: 09:00-10:30 BST / UK Time

Masterclass Lead: Matthew Bernath, Head of Data Analytics at Rand Merchant Bank, Host of the Financial Modelling Podcast

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 teaches 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

Date: Friday, 25 June

Time: 10:45-12:15 BST / UK Time

Masterclass Lead: Giles Male and Myles Arnott, Co-Founders of Full Stack Modeller

In this session Giles Male and Myles Arnott 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

Date: Friday, 25 June

Time: 13:00-14:30 BST / UK Time

Masterclass Lead: Matthew Bernath, Head of Data Analytics at Rand Merchant Bank, Host of the Financial Modelling Podcast

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.

Date: Friday, 25 June

Time: 14:45-16:15 BST / UK Time

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

In this hands on, practical session, Project Finance Institute Co-Founder Kenny Whitelaw-Jones teaches some core PF modelling concepts. Worked example models will be made available to all participants.

Masterclass V: Data Visualisation for Financial Modelling

Date: Friday, 25 June

Time: 16:30-18:00 BST / UK Time

Masterclass Lead: Jordan Goldemeier, Microsoft MVP, Book Author

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.