Excel, of course, has always been able to deal with tables. A table is just a rectangular range of cells that (usually) contain 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. Working with tables is easier than ever.

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. For example:

• 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.
• AutoFiltering 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.

FIGURE 12-1
Working with tables of data has never been easier.

• 4 Types of Boats If you are looking for a fun and enjoyable activity for yourself, your friends or your family, then give boat...
• Track Your Money with Excel Many people utilize the software program known as Excel to set up their budget as well as to manage it....
• Google Fusion Tables Could be a Game Changer Google has been very busy lately with many new products recently. Many of them, such as Google Public DNS, Google...
• JOOLA ROSSI Three-Star White 40mm Table Tennis Balls, 6-Count User Reviews Send this to a friend JOOLA ROSSI Three-Star White 40mm Table Tennis Balls, 6-Count Manufacturer: JOOLA Customer Rating:...
• got a new table This table I was bought and build it yesterday at 10.42pm. And done at 11.50 pm or so.The thing is...