Excel 2007 PivotTables and PivotCharts

* Excel is the standard among spreadsheet applications with an installed base of hundreds of millions, and has proven to be a valuable tool in many different industries
* This book helps readers take their Excel 2007 skills to the next level by offering key information on PivotTables and PivotCharts, which are powerful tools within Excel used for analyzing, summarizing, and organizing data to reveal meanings that would not otherwise be visible
* Walks readers through the untapped capabilities of PivotTables and PivotCharts by combining both reference and tutorial approaches
* Many chapters include a case study that illustrates how to apply Excel solutions in the real world
* Demonstrates how to work with PivotTable components, confidently use PivotCharts, use PivotTables with multi-dimensional data, get hard data from a PivotTable, and more

 

 

Table of Contents

Acknowledgements.

Author Biographies.

Introduction.

1. Understanding PivotTables and Charts.

2. Understanding Datasources for PivotTables.

3. Using PivotTable Tools and Formatting. PivotTables and Charts: Going Beyond the Basics.

4. Understanding and Using PivotChart.

5. More About PivotTable Components.

6. Understanding and Using PivotChart.

7. Using PivotTables with Multidimensional Data.

8. Getting Data from a PivotTable.

9. PivotTable Alternatives.

10. Programming PivotTables with VBA

Appendix A. Troubleshooting PivotTables and PivotCharts.

Appendix B. Excel Version Differences for PivotTables.

Appendix C. An Excel Chart Primer.

Index.

Note Pages.

Coupons.

L. License Agreement(S).

CDI. CD Installation Instructions.