Excel 2007 PivotTables and PivotCharts

Peter G. Aitken

  • 出版商: Wiley
  • 出版日期: 2007-04-16
  • 售價: $1,430
  • 貴賓價: 9.5$1,359
  • 語言: 英文
  • 頁數: 312
  • 裝訂: Paperback
  • ISBN: 0470104872
  • ISBN-13: 9780470104873
  • 相關分類: Excel
  • 已過版

買這商品的人也買了...

相關主題

商品描述

Description 

* 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.