Excel Named Ranges & Readable Models: Constants, Names and the Name Box

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• 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.
• Price eight web-shop orders with four named constants: member discount, free-shipping threshold, shipping fee and tax, without a single $ sign.
• Summarise twelve bike orders with range names: two are given (Store, Revenue), two you define yourself in the Name box (Category, Units).
• Price a dealer order with lookups on the named price list (PriceList, Codes, Prices) and find the volume discount in a tier table you name yourself.
• 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.
• Repair invalid names, fix a formula with a misspelt name and avoid the classic "name inside quotes" error in COUNTIF.
• Rebuild a gravel-bike profit model whose formulas only used cell addresses: same results, but every formula now reads like the business logic.
• Build the shop's 2026 dashboard only from names (total profit, best month, months on target) and chart revenue against costs.