Excel 2007 PivotTables and PivotCharts

Welcome to the only guidebook series that takes a visual approachto professional-level computer topics. Open the book and you'lldiscover step-by-step screen shots that demonstrate over 130 keytechniques for working with PivotTables and PivotCharts, including:

* Building PivotTables from Excel ranges * Customizing PivotTable field lists * Converting PivotTables to regular data * Grouping numeric, text, or date/time values * Developing various summary calculations * Turning a PivotTable into a PivotChart * Displaying data tables with a PivotChart * Creating an OLAP cube data source * Exporting Access(r) PivotTable(r) forms to Excel * Using Microsoft Query with PivotTables
EXTRA Apply It * „Apply It“ and „Extra“ sidebars highlight useful tips * High-resolution screen shots demonstrate each task * Succinct explanations walk you through step by step * Two-page lessons break big topics into bite-sized modules