Lesson 1 of 5
Named ranges & structured references
Named ranges turn unreadable cell references into meaningful labels. Instead of remembering that $B$2:$B$500 holds revenue, you name it Revenue. Structured references do the same inside Excel tables, so formulas read like natural language.
When a table grows, structured references expand automatically. A formula such as =SUM(Sales[Amount]) stays correct even as new rows are added below the table.
Example
A regional manager wants to roll up quarterly revenue. She names the table Q1_Sales and writes =SUM(Q1_Sales[Revenue]). The range updates itself when April data is appended.
