Pivot Table Data Crunching Microsoft Excel 2007

Download files for Pivot Table Data Crunching Microsoft Excel 2007

Thanks for buying Pivot Table Data Crunching Microsoft Excel 2007.

Mike Alexander and I used a new dataset for this book in order to show off the 1.1 million rows. The files below are the data files used when creating the book. In many cases, the files are similar from chapter to chapter. The files are saved as an Excel 2007 file using the final, Release-To-Manufacturing version of Excel 2007. If you have a version of beta 1 or beta 2, this file may not open in your version of Excel.

• Click here to download the sample file used in most chapters. This should be the dataset used in Chapters 1, 2,
• PT2007Intro.zip is the dataset used in both case studies in the Introduction.
• PT2007Chap3.zip contains the dataset for Figure 3.1 through 3.24
• PT2007Chap3a.zip contains the dataset for Figure 3.25 through 3.33 and 3.43 through 3.49.
• PT2007Chap3StdDev.zip contains the dataset from Figure 3.29.
• PT2007Chap3b.zip contains the dataset for Figure 3.34 through 3.41.
• PT2007Chap3Index.zip contains the dataset from Figure 3.42.
• PT2007Chap4.zip contains the dataset from Figure 4.1 through 4.07
• PT2007Chap4Group2Dates.zip contains the dataset from Figure 4.8
• PT2007Chap4GroupNumerics.zip contains the dataset from Figures 4.9 - 4.10
• PT2007Chap4GroupText.zip contains the dataset from Figures 4.11 - 4.18
• PT2007Chap4Sorting.zip contains the dataset from Figures 4.19 - 4.40
• PT2007Chap5Case.zip contains Chapter 5 Case Study
• PT2007Chap7.zip contains the dataset from Chapter 7
• PT2007Chap7DB.zip contains the Access database from Chapter 7 (updated 12/10/2007)
• PT2007Chap8.zip contains a legacy Excel file that supported interactivity
• Click here to download the VBA macros from chapter 11.

Or, download All Files (73MB).