How to Use Excel Tables Structured References: Excel learning resource

Practice workflow

1. Convert the range to a table and give it a meaningful name.
2. Add a calculated column and confirm the formula fills down automatically.
3. Use structured references in one summary formula.
4. Add new rows and confirm formulas, formatting, and references expand.

Quality checks

• Every column has a unique, descriptive header.
• The table name describes the data, not the sheet.
• Summary formulas still work after adding rows.

Common mistakes

• Leaving blank columns inside a table.
• Using vague table names like Table1 in important formulas.
• Turning a range into a table before fixing merged cells or broken headers.

Next actions

• Replace one normal range in an existing workbook with a table.
• Use the table as the source for a PivotTable or chart.