Excel Tables

Convert a dataset into a table using:

Ctrl + T

Benefits

  • Automatic formatting
  • Automatic expansion
  • Filters
  • Total Row
  • Structured References

Example:

=SUM(Table1[Sales])

Named Ranges

A named range gives a meaningful name to a cell or range.

Example:

B2:B100 → SalesData

Formula:

=SUM(SalesData)

Dynamic Ranges

Dynamic ranges automatically adjust when data is added or removed.

Example using an Excel Table is often the simplest modern approach because the table expands automatically.

Practice

Convert the business dataset into an Excel Table and create named ranges for important fields.

PreviousNext