One-Variable Data Table, Built with Formulas
This lesson is part of the course
In this lesson
You test nine prices for the desk lamp in one table – units react to the price – and chart EBIT against price to see where profit peaks.
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