An introduction to the key parts of using Excel to perform what if analysis
Excel 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.
- Time Req – 1 hr
- Skill Score >5
- FAQ
- All Online Courses
- Live Course Options
- Ask a Question
If you prefer to attend a live session, visit the MS Excel Advanced Courses Calendar
Modules
What If Tips and Tricks
Lessons
Goalseeking a solution
How to use the Excel Goalseek tool to find what needs to change in order to achieve a particular solution
Lessons
Data Tables in Excel
How to use the Excel Data table tool to run one, two or more variable sensitivities
Lessons
Excel Scenario Manager
How to use the Excel Scenario Manager Tool to run scenarios through your models.
Lessons
Excel Solver
How to use Excel's Solver tool to determine an outcome based on making changes to multiple inputs
