Home | Power Analyst Boot Camp | Excel Tutorials | Access Tutorials | Xcelsius Tutorials | Freeware | DataPig BlogAbout  

Pivot Table Data Crunching For Excel 2007
The best selling book on
pivot tables has been updated for Excel 2007!  Both new and seasoned users will find value in this book, as it clearly explains the various new features and concepts of pivot tables in Excel 2007.  Covering everything from preparing your data for pivot table reporting to creating pivot tables with VBA, this book will make you the office expert on Excel pivot tables.  Easy to follow instructions and real-world examples ensure that you don't miss a beat in this "soup to nuts" approach to everything you will ever need to know about pivot tables.

  • Chapter 1:  Pivot Table Fundamentals

  • Chapter 2:  Creating a Basic Pivot Table

  • Chapter 3:  Customizing a Pivot Table

  • Chapter 4:  Controlling the Way You View Your Pivot Data

  • Chapter 5:  Performing Calculations Within Your Pivot Tables

  • Chapter 6:  Using Pivot Charts and Other Visualizations

  • Chapter 7:  Analyzing Disparate Data Sources with Pivot Tables

  • Chapter 8:  Sharing Pivot Tables with Others

  • Chapter 9:  Working with and Analyzing OLAP Data

  • Chapter 10:  Enhancing Your Pivot Table Reports with Macros

  • Chapter 11:  Using VBA to Create Pivot Tables

  • Chapter 12:  Common Pivot Table Issues and Questions

  • Appendix A:  Finding Pivot Table Commands on the Ribbon

 

 

Now Available
 

I need the 2003 version of this book


Read Excerpt:  Chapter 3

 
Copyright 2006  DataPig Technologies LLC. All rights reserved.