Excel PivotTables And Charts (with source code)

PivotTables enable you to extract meaning from large amounts of data. This description is deceptively simple because in fact PivotTables are powerful and sophisticated tools that enable you to do things that would be impossible or difficult to do any other way.

A PivotTable enables you to take what seems to be an indecipherable mass of facts and extract any trends and patterns buried in the data. You can organize and summarize your data, perform comparisons, and extract meaningful information that can be invaluable to you and your organization.

These are powerful, flexible, and complex tools, and most Excel users never tap their full potential. But you can, with Peter Aitken's step-by-step tutorials, understandable instructions, and detailed explanations. You'll learn to create and use PivotTables and charts from the simplest to the most complex.

TABLE OF CONTENT:
Part 01 - Understanding PivotTables and Charts
Part 02 - Understanding Data Sources for PivotTables
Part 03 - Using PivotTable Tools and Formatting
Part 04 - Working with PivotTable Components
Part 05 - More About PivotTable Components
Part 06 - Understanding and Using PivotCharts
Part 07 - Using PivotTables with Multidimensional Data
Part 08 - Getting Hard Data from a PivotTable
Part 09 - PivotTable Alternatives
Part 10 - Programming PivotTables with VBA
Appendix A - Troubleshooting PivotTables and PivotCharts
Appendix B - Excel Version Differences for PivotTables
Appendix C - An Excel Chart Primer

Download here

Password:ganelon