Excel Data AnalysisLesson 31Free preview

Excel Tables

This lesson is part of Excel · All levels

Summary

Excel Table converts a regular range into a table object with a header, automatic filter, and mapping format. The formula uses structured references like Table1[Price] to make it easier to read, and when you type the data right underneath it, the table automatically widens. The table also supports Total Row for a quick summary at the bottom.

Key points

Create a table with Ctrl+T or Home > Format as Table
Structured Table1[Column] references are more informative than A1:A10
The table automatically expands when a new line is added underneath it
Header, filter, and format banded rows to automatically adjust

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.