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.