Advanced financial modelling techniques using Excel

In this recorded webinar, you will learn advanced financial modelling techniques using Excel. You will need to have knowledge of formula and functions in Excel and an understanding of financial modelling to follow along. The webinar will use a hands-on approach to demonstrate how to construct an advanced and flexible financial model that can be spun around a single cell. You will learn how to create scenarios, use advanced formulas and functions, build one-off events, and conduct consolidations based on cost centres. Additionally, you will learn how to use a single cell to control multiple calculations, generate a goal seek tool, and add VBA programming to your models. 

Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.  

Key topics:

• How to set up a flexible scenario and financial model
• Using a one cell to rule them all methodology
• Add a one-off event to your forecast
• Consolidate multiple P&Ls into your model
• Generate scenario analysis using the Excel goal seek tool

As part of this webinar you will receive,

• Downloadable worksheets with practical tasks to embed the knowledge
• A learning manual with step-by-step instructions

This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Clickherefor Marcus' biography.

Course updated: May 2023