Chapter 21. Organizing Data with Tables and PivotTables
In this chapter
Defining a Range as a Table 628
Sorting and Filtering Data in a Table 631
Importing and Exporting Data 643
Connecting a Worksheet to External Databases 645
Creating and Using Web Queries 649
Analyzing Information with PivotTables 651
When Should You Use a PivotTable? 655
Editing and Updating a PivotTable 657
Secrets of the Office Masters: Combining Data from Several Web Sources in a Custom Page 662
Defining a Range as a Table
Excel’s row-and-column structure makes it an ideal tool for organizing related information into a table ...
Get Special Edition Using Microsoft Office 2007 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.
