3.1. What Is an Excel Table?
Excel tables provide a way to keep your data in a coherent list format on an Excel spreadsheet. This list format is really somewhat like a database table, for those familiar with database terminology. It organizes the data into labeled columns with drop-down data-filtering controls that allow you reduce the data being displayed and to sort it in organized ways.
The tables are likely to be a popular tool with Excel 2007, since spreadsheets can hold one million rows in 2007! With all that data ending up in Excel, it really helps to be able to easily turn it into columns that help control the data display. It is in some ways an alternative to Excel PivotTables, which are not appropriate for all situations and, in fact, ...
Get Microsoft ® Office 2007 Business Intelligence now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
