Excel 2007 PivotTables and PivotCharts: Your visual blueprint for interpreting and presenting Excel data

Excel 2007 PivotTables and PivotCharts ePub (Adobe DRM)

by: Paul McFedries

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