Why Names? $B$1 versus TaxRate
This lesson is part of the course
In this lesson
You calculate the tax on Orchard Lane Cycles' price list twice, once with an absolute reference and once with the defined name TaxRate, and see why a name is easier to read and harder to break.
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