This recorded webinar covers advanced financial modelling techniques using Excel.
Key topics:
Using a ‘one cell to rule them all’ methodology participants will learn how to create an financial model which changes based on the contents of a single cell.
Create one off event scenarios which add a one off event to your forecast, then take that event out of all future years so projections are not over stated.
Generate scenario analysis using the Excel goal seek tool
Objectives
Set up a scenario sheet so its flexible (run multiple scenarios)
Build in a one off event in a particular year
Create an intelligent calculation around the one off event
Isolate the calculations of an entire sheet to look at one cell
Consolidate the model so multiple P&Ls can be consolidated
Generate some scenario analysis using the Excel goal seek tool
Work through detailed tasks accompanying the webinar to test knowledge acquired
Audience
Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.
Details
46760597
365 Days
English
System is currently experiencing issues and we are working on a solution. If you encounter an error, please come back shortly and try again.
