Working with Excel Tables¶

An Excel Table (Insert → Table, or CtrlT) is a supercharged range. It's one of the most underused beginner features — and a game-changer.

A structured data table with banded rows and filter buttons

Why Convert a Range to a Table?¶

+Automatic banded-row styling for readability

+Filter and sort buttons on every header

+The table **auto-expands** when you add rows/columns

+Formulas auto-fill down the whole column

+A clear **name** you can reference (e.g. `Sales`)

−A plain range has none of this — you maintain it all by hand

Your data instantly gains a styled header with dropdown filters.

The headline benefit: tables let you write formulas with column names instead of cell addresses.

excel

3 lines

1=SUM(Sales[Revenue])              ← whole Revenue column
2=[@Revenue] - [@Cost]             ← this row's Revenue minus Cost
3=AVERAGE(Sales[Units])

Compare that to =SUM(C2:C5000) — structured references are self-documenting and never break when the table grows.

Feature	Benefit
Total Row	One-click sum/average/count footer
Auto-expand	New rows join the table automatically
Slicers	Visual filter buttons (Chapter 8)
Named table	Clean references in formulas & charts

Tip

Give every table a meaningful name: select it → Table Design tab → rename from Table1 to something like Sales. Your formulas become readable.