Input-Driven Models: Inputs vs Calculations
This lesson is part of the course
In this lesson
You build the one-product profit model of Lumen & Co., a desk-lamp maker, so that every result is driven by the input block – the base for every what-if tool in this course.
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