+612 9045 4394
Excel 2007 Pivottables Recipes : A Problem-Solution Approach - Debra Dalgleish

Excel 2007 Pivottables Recipes

A Problem-Solution Approach

Paperback Published: 1st December 2007
ISBN: 9781590599204
Number Of Pages: 245

Share This Book:
Ships in 5 to 9 business days

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.

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
Table of Contents provided by Publisher. All Rights Reserved.

ISBN: 9781590599204
ISBN-10: 1590599209
Series: Expert's Voice in .NET
Audience: General
Format: Paperback
Language: English
Number Of Pages: 245
Published: 1st December 2007
Publisher: Apress
Country of Publication: US
Dimensions (cm): 23.47 x 17.98  x 1.65
Weight (kg): 0.45