Assumption Blocks and Scenario Inputs with Names
This lesson is part of the course
In this lesson
You drive a 5-year e-bike revenue plan from a named scenario switch: pick the active growth and price increase with INDEX/MATCH, name them, and project units, prices and revenue.
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
- Why Names? $B$1 versus TaxRate Locked
- Using Named Constants: TaxRate, ShipFee, FreeShipFrom & MemberDiscount Locked
- Naming Ranges with the Name Box: SUM, AVERAGE, COUNTIF and SUMIF Locked
- Names in Lookups: VLOOKUP and XLOOKUP on Named Tables Locked
- Assumption Blocks and Scenario Inputs with Names Locked
- Naming Rules, Conventions, Scope and #NAME? Errors Locked
- Refactoring a Model from Cell References to Names Locked
- Capstone: A Named-Range Dashboard and Chart Locked