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 ...
Read More
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.
Read Less
This book was an answer to my prayers. I have limited understanding of pivots and a healthy fear of them.This book helped me understand and start using pivots.
