Introduction to Structured References and Tables

Tip: Introduction to Structured References and Tables

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.

Duration 
3:35
Author 

Related shortcuts

CtrlT

T

CtrlShift%

%

Leave a Reply

Your email address will not be published. Required fields are marked *