Excel Named Ranges & Readable Models: Constants, Names and the Name Box
Replace $B$1 with TaxRate: use named constants, name ranges in the Name box, look up in named tables, drive scenarios from a named assumption block, follow Excel's naming rules, refactor a cell-reference model and build a named-range dashboard with a chart, in 8 hands-on labs checked cell by cell.
The first lesson is free — no account needed.
About this course
An Excel named ranges course that turns the spreadsheets of one fictional bike shop, Orchard Lane Cycles, into models anyone can read, for Excel users tired of decoding $B$1 and anyone who builds templates for colleagues. You calculate tax once with an absolute reference and once with the name TaxRate, price web-shop orders with four named constants and no $ sign, define range names in the Name box and use them in SUM, AVERAGE, COUNTIF and SUMIF, look up prices and volume discounts in named tables with VLOOKUP and XLOOKUP, drive a five-year e-bike plan from a named scenario switch, repair invalid names and #NAME? errors under Excel's naming rules, refactor a cell-reference profit model into names and finish with a dashboard and chart built only from names. The first lab is free.
Lessons
- Why Names? $B$1 versus TaxRateFree
- Using Named Constants: TaxRate, ShipFee, FreeShipFrom & MemberDiscount Pro
- Naming Ranges with the Name Box: SUM, AVERAGE, COUNTIF and SUMIF Pro
- Names in Lookups: VLOOKUP and XLOOKUP on Named Tables Pro
- Assumption Blocks and Scenario Inputs with Names Pro
- Naming Rules, Conventions, Scope and #NAME? Errors Pro
- Refactoring a Model from Cell References to Names Pro
- Capstone: A Named-Range Dashboard and Chart Pro