You will learn advanced financial modelling techniques using Excel, including creating scenarios, using advanced formulas and functions, conducting consolidations, and controlling multiple calculations with a single cell.
Description
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. Click here for Marcus' biography.
Course updated: May 2023
Learning objectives
- Set up a flexible scenario and financial model
- Use a ‘one cell to rule them all’ methodology
- Apply a one-off event to your forecas
- Consolidate multiple P&Ls into your model
- Generate scenario analysis using the Excel goal seek tool
