A table is a feature in Excel that makes it easier to format and analyze a set of data points in a spreadsheet. Tables were introduced in Excel 2007 as an extension of the ‘Lists’ feature in the earlier versions. In Excel 2007 onwards, you can also use the table formulas to extract data from a table.
Table Formulas let you access table in a easy and intuitive manner. You can then refer to and use the entire table, individual columns, rows, data range, headers or totals in your formulas.