Convert a range to an Excel Table (Ctrl+T) for automatic filter buttons, structured references, and expanding formulas.
Benefits
- Auto-fill formulas down the column
- Structured refs:
=SUM(Table1[Revenue]) - Named table for Power Query and pivots
Create
Select data with headers → Insert → Table → check "My table has headers".
Important interview questions and answers
- Q: Structured reference?
A: Uses table name and column header in formulas. - Q: Ctrl+T?
A: Create table from range.
Self-check
- Why convert data to a Table?
- Give an example structured reference.
Tip: Name tables on the Table Design tab (e.g. tblSales) for clearer formulas.
Interview prep
- Ctrl+T?
Creates structured Excel Table from range.