World Famous Comics: Excel PivotTables and Charts (Mr Spreadsheet)
Excel PivotTables and Charts (Mr Spreadsheet)
By: Peter G. Aitken Publisher: Wiley Average Rating: Binding: Paperback Label: Wiley Number of Items: 1 Number of Pages: 288 Publication Date: January 11, 2006
Product Description: These are powerful, flexible, and complex tools, and most Excel users never tap their full potential. But you can, with Peter Aitken's step-by-step tutorials, understandable instructions, and detailed explanations. You'll learn to create and use PivotTables and charts from the simplest to the most complex.
This book will help you get more from Excel than ever before.
Chart Topper # 1 Creating a PivotTable Report
Chart Topper # 3 Using Special PivotTable(r) Tools
Chart Topper # 6 Understanding and Using PivotCharts
Chart Topper # 7 Working with Multidimensional Data
Chart Topper # 10 Programming PivotTables with VBA
Comprehensive Pivot Tabling This book contains the basics of Excel pivot table construction. It shows the components of pivot tables and charts and how to use them to create simple pivots. However, it does not provide much insight into the data analysis aspects of pivoting data nor does it go into depth conceptually enough for a book dedicated to pivot tables. After studying this book, you may find yourself looking for more detail and insight.
Recommended with reservation. dw
Clean and useful While I already use pivot's extensively, a few hours with this book and I'm already excited about taking them to the next level.
I don't know vba extensively - just record macros and sometimes tweak the code. However, the info here about automating pivots with VBA could really make a difference in the work I do.
This was easy to use - and will be a reference on my desk going forward.
A real lifesaver. After struggling with pivot tables this book finally helped me to understand them. It's clear and has lots of examples. It deals with the problems you can run into also. It has really helped me at work where I need to use Excel for a lot of things.