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
- ISBN13 9781118079447
- Publish Date 17 June 2011 (first published 2 November 2007)
- Publish Status Out of Print
- Out of Print 9 August 2014
- Publish Country US
- Imprint Visual
- Edition 2nd Revised edition
- Format eBook (EPUB)
- Pages 290
- Language English
- URL http://wiley.com