Structured References

Added in 2007
The syntax was changed slightly in Excel 2010.
Easier to read than Standard References (A1, B2, B1:C20).
Makes it simpler to work with cell references inside tables
Allows table formulas to be very dynamic
They adjust automatically when data is added or removed
Structured references automatically adjust as rows are added or removed from the table.

Structured references will be inserted automatically when you click or select different parts of a table instead of typing the explicit cell references

Allows you to reference columns, header rows and total rows without using the explicit cell references (A1 or R1C1 notation)

The combination of the table name and the column name is called a structured reference

Options

Formulas tab - "use table names in formulas"

Tables

The header row should always be displayed
Creating tables (Insert > Table) (Ctrl + T)
Create table dialog box
select whole table - top left corner
how to select individual columns