excel Worksheet databases

Generally, a rectangular range of data that contains column headers can be considered a worksheet database.
Excel 2007 was the first version that enabled you to specifically designate a range as a table.
Select any cell in your rectangular range of data and choose Insert➜Tables➜Table. Using a table
offers many advantages: an automatic summary row at the bottom, easy filtering and sorting,
auto-fill formulas in columns, and simplified formatting. In addition, if you create a chart from a
table, the chart expands automatically as you add rows to the table.