Microsoft Excel

Worksheet Tables

Working with tables is easier than ever. A table is just a rectangular range of cells that usually contains column headers. The designers of Excel 2007 realized that such tables are widely used in Excel, and they've taken the concept to a new level.

Once you designate a particular range to be a table using the Insert > Tables > Table command, Excel provides you with some very efficient tools that work with the table:

  • You can apply attractive formatting with a single click.

  • You can easily insert summary formulas in the table's total row.

  • If each cell in a column contains the same formula, you can edit one of the formulas, and the others change automatically.

  • You can easily toggle the display of the table's the header row and totals row.

  • Removing duplicate entries is easy.

  • Auto filtering and sorting options have been expanded.

  • If you create a chart from a table, the chart will always reflect the data in the table-even if you add new rows.

  • If you scroll a table downwards so that the header row is no longer visible, the column headers now display where the worksheet column letters would be.

Improved Pivot Tables

Excel’s pivot table feature is probably one of its most underutilized features. A pivot table can turn a large range of raw data into a useful interactive summary table with only a few mouse clicks. Microsoft hopes to make this feature more accessible by improving just about every aspect of pivot tables in Excel 2007.

Charts created from pivot tables (pivot charts) now retain their formatting when they’re updated. This loss of formatting had been a frustration for hundreds of thousands of users, and Microsoft finally did something about it.