Scenario Selector: Base, Best and Worst with CHOOSE and INDEX
This lesson is part of the course
In this lesson
You keep three scenarios side by side, pick one by name and let a Live column feed the model – a live version of Excel's Scenario Manager.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Input-Driven Models: Inputs vs Calculations Locked
- Scenario Selector: Base, Best and Worst with CHOOSE and INDEX Locked
- One-Variable Data Table, Built with Formulas Locked
- Two-Variable Data Table with Mixed References Locked
- Goal Seek by Hand: Bisection Table vs the Algebraic Solution Locked
- Break-Even and Target Profit: Solve Instead of Seek Locked
- Tornado Sensitivity: Which Driver Moves Profit Most? Locked
- Monte-Carlo-Style Scenarios: Expected Value and the Chance of a Loss Locked