Guided Notes

What-If Analysis

Goal Seek, Scenario Manager, and data tables for testing different inputs.

Asking "what if?"

Slide 1 / 5

What-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.

← PivotTables