Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 130 key techniques 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