Excel Pivot Tables And Charts

0.0

Excel is by far the most widely used spreadsheet program with an installed base of hundreds of millions. PivotTables and the related pivot charts are a powerful tool within Excel for analyzing, summarizing, and organizing data to reveal meanings that would not otherwise be visible. The use of these tools is not simple or intuitive, however, and the vast majority of Excel users have never tapped their power. This book addresses this need by providing complete coverage of Excel PivotTables andpivot charts starting with the simplest and most basic uses and working up to complex and sophisticated scenarios. The book combines both the reference and tutorial approaches. About The Author Peter Aitken has been writing books about computers and software since 1988 and has over 40 titles to his credit. He has also written extensively on these topics for magazines, newsletters, and web sites. He was for 20 years a member of the faculty at Duke University and currently retains a part-time position there. Peter is proprietor of PGA Consulting, providing application development, web design, and technical writing services to clients in business, academia, and government. Much of his consulting work focuses on Excel, including programming, custom templates, and troubleshooting. Table Of Contents Understanding PivotTables and Charts Understanding Data Sources for PivotTables Using PivotTable Tools and Formatting Working with PivotTable Components More about PivotTable Components Understanding and Using PivotCharts Using PivotTables with Multidimensional Data Getting Hard Data from a PivotTable PivotTable Alternatives Programming PivotTables with VBA Appendix A: Troubleshooting PivotTables and PivotCharts Appendix B: Excel Version Differences for PivotTables Appendix C: An Excel Chart Primer Index