Overview
- PivotTables and PivotCharts have historically been hidden by Microsoft, but in Office 2007 they’re visible
- Users are working with more data on their desktop than ever before and are searching for tools to make sense of it
- Brings their data together with a greatly revised feature in Office and provides context, experience, and plenty of real-world, ready-to-use recipe examples so the user can immediately slice and dice their data as soon as they start reading
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents(11 chapters)
About this book
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.
About the author
Bibliographic Information
Book Title: Excel 2007 PivotTables Recipes
Book Subtitle: A Problem-Solution Approach
Authors: Debra Dalgleish
DOI: https://doi.org/10.1007/978-1-4302-0504-3
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: Debra Dalgleish 2007
Softcover ISBN: 978-1-59059-920-4Published: 07 December 2007
eBook ISBN: 978-1-4302-0504-3Published: 11 March 2008
Edition Number: 1
Number of Pages: 272
Topics: Microsoft and .NET, Software Engineering/Programming and Operating Systems