Excel PivotTables and PivotCharts - Your Visual Blueprint for Creating Dynamic Spreadsheets

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 100 key techniques for creating PivotTables and PivotCharts, including:

• Building a basic PivotTable report
• Pivoting fields to different areas
• Filtering PivotTable data
• Organizing PivotTable data into groups
• Formatting a PivotTable
• Changing the summary calculation
• Creating custom calculations
• Publishing a PivotTable to the Web
• Creating a PivotChart® from a PivotTable
• Building a PivotTable from external data

"I was stuck on an Excel problem for two days. Finally I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."
Rob L. Meerscheidt (The Woodlands, TX)

• 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
• "Apply It" and "Extra" sidebars highlight useful tips