Excel Pivot Tables and Pivot Charts: Your visual blueprint for creating dynamic spreadsheets (Visual Blueprint)

By Paul McFedries

Book Overview

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

• Format: Paperback
• Language: English
• ISBN: 0471784893
• ISBN13: 9780471784890
• Release Date: March 2006
• Publisher: Visual
• Length: 291 Pages
• Weight: 1.50 lbs.
• Dimensions: 0.8" x 8.0" x 9.0"