What IF analysis using Excel

In this recorded webinar, you will learn how to display your data in chart form and add trend lines using inbuilt analysis to project future data. Additionally, you will explore advanced scenarios such as goal seek, scenario manager, solver, and regression analysis. You will discover how to automate processes, create scenarios with varying outputs, and use algorithms to optimise your results.

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:

• Set up a worksheet to be used with the solver tool (Excels solver algorithm makes the calculations for you while generating a report to show workings)
• The creation of scenarios using the scenario manager
• The setup of a workbook to use goal seek to work out predefined ratios
• A demonstration of how regression analysis can be used with the FORECAST formula to make projections

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