An introduction to the key parts of using Excel to perform what if analysis
Excel What If Analysis
The What If Analysis course shows you how to run what ifs and sensitivities in Excel using the built in tools like Data Tables, Goal Seek, Solver and Scenario Manager. We also cover the tips and tricks associated with running what if scenarios.
If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar
How to use the Excel Goalseek tool to find what needs to change in order to achieve a particular solution
How to use the Excel Data table tool to run one, two or more variable sensitivities
How to use the Excel Scenario Manager Tool to run scenarios through your models.
How to use Excel's Solver tool to determine an outcome based on making changes to multiple inputs