What-If Analysis in Excel: Mini Excel Masterclass Series

Overview
This Excel mini masterclass looks at how to use the What-If Analysis tools in Excel.
The What-If Analysis tools in Excel are essential to exploring different scenarios, optimising decision-making, and gaining deeper insights into your data. Whether you're a financial analyst projecting future revenues, a project manager evaluating risks, or a scientist studying various hypotheses, Excel's What-If Analysis tools provide the flexibility and precision you need to make informed choices and achieve your objectives.
Learning Outcomes
- Use Goal Seek to work backwards from a result to determine an input value.
- Compare a range of possible inputs into a calculation using the less common What-If Analysis tool, Data Table.
- Create a high, medium, and low scenario using Scenario Manager to view a set mortgage payment that varies based on inflation rates.
Audience
Anyone looking to improve their knowledge of What-If Analysis in Excel.