Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.
This handy guide teaches you how to use Excel's most powerful feature to crunch large amounts of data, without having to write new formulas, copy and paste cells, or reorganize rows and columns.
In this book, Debra Dalgleish, Microsoft Office Excel MVP since 2001 as well as 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 ...
Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will • Dramatically increase your productivity—saving you 50 hours a year or more • Present proven, ...
This book addresses this need by providing complete coverage of Excel PivotTables and pivot charts starting with the simplest and most basic uses and working up to complex and sophisticated scenarios.
Create advanced charts and graphs Present compelling graphical representations of data integrate with PowerPoint and Word Excei2007 Charts IVIae EASY Kathy Jacobs Curtis Frye Douglas Frye Excel® 2007 Charts Made EASY Kathy Jacobs Curt ...
Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand.
Excel, the top number-crunching tool, now offers a vastly improved charting function to help you give those numbers dimension and relativity. John Walkenbach, a.k.a.
Find out what the manual doesn't always tell you in this insider's guide to using Excel in the real world. What are the secrets of pro users? Are there shortcuts for repetitive tasks?
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
Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentations Now revised with over 30 ...