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.