An Excel Table is a new feature in Excel 2007, similar to the List feature in Excel 2003. An Excel Table makes it easy for you to sort, filter, and review your data, whether it’s a few rows and columns, or thousands.
You can also use an Excel Table as the source for a Pivot Table, [...]

When you add a field to the pivot table Data area, it automatically gets a custom name, such as Sum of Units or Count of Units.

Instead of “Sum of Units”, you might want the name to show as “Units”, so it’s easier to read and the column is narrower.
Unfortunately, if you select the [...]

While working in the pivot table source data, you might add new items. For example, if you start selling a new product, that product will appear in the list of orders. If your pivot table is based on that list of orders, the new product will also appear in the pivot table, when you refresh [...]

If your pivot table is based on an Excel list, and you probably add records to the existing source data table. You’d like the source data range to automatically expand to include any new rows and columns. You don’t want to manually change the pivot table range every time you add new data.
Create a Dynamic [...]

You might have to make changes to a workbook that contains a pivot table. If someone else created that workbook, you may not be sure where to find the Excel table that was used as the pivot table’s source data. In some workbooks there can be several Excel tables, and it’s not immediately obvious which [...]