Pivot Table Data Crunching for Microsoft® Office Excel® 2007

Chapter 7. Analyzing Disparate Data Sources with Pivot Tables

<feature><title>In This Chapter</title>

• Using Multiple Consolidation Ranges 168

• Analyzing the Anatomy of a Multiple Consolidation Range Pivot Table 174

• Case Study: Consolidating and Analyzing Datasets 176

• Building a Pivot Table Using External Data Sources 179

• Next Steps 187

</feature>

Until this point, you have been working with one local table located in the worksheet within which you are operating. Indeed, it would be wonderful if every dataset you came across were neatly packed in one easy-to-use Excel table. Unfortunately, the business of data analysis does not always work out that way.

The reality is that some of the data you encounter will come from disparate data sources—meaning sets ...