What-If Analysis: Scenarios, Data Tables & Goal Seek
Build input-driven models, scenario selectors, one- and two-variable data tables, goal seek by bisection, break-even solving, tornado charts and a Monte-Carlo-style simulation, every cell checked live.
The first lesson is free — no account needed.
About this course
This Excel what-if analysis course teaches you to build models that answer "what happens if…" questions, using one desk-lamp maker as the case. You separate inputs from calculations, switch between base, best and worst scenarios with CHOOSE and INDEX, build one- and two-variable data tables with formulas, find a target with a bisection table that does what Goal Seek does and then solve it exactly, calculate break-even and target-profit volumes, rank the drivers in a tornado chart and turn random numbers into a Monte-Carlo-style estimate of the chance of a loss. The first lab is free.
Lessons
- Input-Driven Models: Inputs vs CalculationsFree
- Scenario Selector: Base, Best and Worst with CHOOSE and INDEX Pro
- One-Variable Data Table, Built with Formulas Pro
- Two-Variable Data Table with Mixed References Pro
- Goal Seek by Hand: Bisection Table vs the Algebraic Solution Pro
- Break-Even and Target Profit: Solve Instead of Seek Pro
- Tornado Sensitivity: Which Driver Moves Profit Most? Pro
- Monte-Carlo-Style Scenarios: Expected Value and the Chance of a Loss Pro