Excel Tables

Excel Tables came into existence with Excel 2007. They are a powerful tool that can make life a lot simpler. The main strengths of tables are:

• They are dynamic (they automatically adjust as data is added or deleted)
• They address the elements in a number of ways.
• They automatically “copy down” formulas you enter.

Creating Tables

Data coming into a spreadsheet as a result of a query or data import will come in as a table. However, any existing range of data can be converted into a table. In this article, the following data are used