Debra Dalgleish, Microsoft Office Excel "Most Valuable Professional" since 2001, and an expert and trainer in Excel, brings together a one-stop resource for anyone curious about representing, analyzing, and using their data with PivotTables and PivotCharts. You'll find this book inimitable when facing any new or difficult problem in PivotTables, covering the entire breadth of situations you could ever encounter, from planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting.

The author presents tips and techniques in this collection of recipes that can't be found in Excel's Help section, while carefully explaining the most confusing features of PivotTables to help you realize their powerful potential.

The chapters in this book have been organized into a collection of recipes to take you step by step from the problem you are experiencing to the solution you are aiming for. Without fuss, you'll find clear and precise information to help you assess your situation, whether common or unique, and solve your problem. Working examples of complex PivotTables and numerous PivotTable programming examples will help you solve problems quickly, without the need to digest heavy content. What you'll learn How to create and format PivotTables to be as attractive as they are useful How to reuse prepackaged recipe code to put PivotTables to work in a variety of data-driven scenarios How to determine why results of your computations and charting might not match what you expect and how to understand and fix those problems Related programming techniques using working examples of advanced PivotTables Who this book is for

This book is a must-have resource for anyone who uses Excel frequently. Table of Contents Creating a Pivot Table Sorting and Filtering Pivot Table Data Calculations in a Pivot Table Formatting a Pivot Table Grouping and Totaling Pivot Table Data Modifying a Pivot Table Updating a Pivot Table Pivot Table Security, Limits, and Performance Printing and Extracting Pivot Table Data Pivot Charts Programming a Pivot Table

Beginning PivotTables in Excel 2007 explains what PivotTables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a Pivot Table in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data.Carefully explains the benefits of using Pivot Tables for fast data analysis Provides a step-by-step approach to those new to Pivot Tables Offers tips and tricks that cannot be found elsewhere What you'll learn Summarize thousands of records in a PivotTable with a few clicks of the mouseQuickly change the PivotTable layout to view a different summary of the dataFilter a PivotTable to focus on one region or the top 10 productsAdd colors or icons to highlight the high or low resultsUse calculations to enhance the PivotTable summariesCreate visual impact with a pivot chart Who this book is for

This book is for Excel users who want to learn about PivotTables. If you work with financial data, logistics records, sales orders, customer service reports, web site statistics, resource tracking, event planning, or any other set of records, a PivotTable can help you review, analyze, monitor, and report on the data. When your reporting requirements change, you can make minor adjustments to the PivotTable, instead of starting a worksheet summary from scratch.

Pivot Tables are a huge growth area. This book gives people the fast-answers they need to succeed The book is far more detailed than any competing title. Readers of this book will be able to do more, and more quickly The book goes beyond basic explanations and includes real-world troubleshooting, performance and security information not provided elsewhere