Guided Notes
What-If Analysis
Goal Seek, Scenario Manager, and data tables for testing different inputs.
Asking "what if?"
Slide 1 / 5What-if analysis tests how changing inputs changes results: What if we sell 10% more? What price do we need to break even? Which of three plans is best?
It only works on a well-built model: inputs (price, units, costs) in their own labeled cells, and results calculated by formulas that reference them — never typed-in totals.
The tools live under Data ▸ What-If Analysis: Goal Seek, Scenario Manager, and Data Table.