CHAPTER 7Creating a Pivot Tablefrom External Data

So far, you've created pivot tables from data that is stored in Excel tables. You can also create a pivot table in Excel from many kinds of external data sources. In this chapter, you'll connect to data that is outside Excel, and you'll create pivot tables from that data. You can download and work with a text file, an OLAP cube, and a Microsoft Access query to see how the pivot table creation process is slightly different depending on the source data. You'll also see some differences in pivot tables that are created from external data sources compared to pivot tables based on Excel data.

To create a pivot table from data that is outside Excel, you can import the data to a worksheet and create ...

Get Beginning Pivot Tables in Excel 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.