Refactoring a Model from Cell References to Names
This lesson is part of the course
In this lesson
You rebuild a gravel-bike profit model whose formulas only used cell addresses: same results, but every formula now reads like the business logic.
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