In this video, I’ll give a brief introduction to structured references.
A structured reference is a term for using a table name in a formula instead of a normal cell reference.
Structured references are optional, and can be used with formulas both inside or outside an Excel table.
Let’s look at some examples.
On this sheet, I have population data for 25 states in the US, based on the 2000 and 2010 census.
I’ll convert this data to an Excel Table, and name the table “states”.
Now let’s build some formulas that refer to the table.