A Complete Guide to PivotTables: A Visual Approach
Select Format
Select Condition 
Book Overview
Pivot Tables are powerful data analysis tools, yet most Excel users don't use them to their fullest potential. A Complete Guide to PivotTables shows you why Pivot Tables are so versatile for data analysis and how you can leverage Pivot Tables to rapidly spot trends and make fast business decisions on mountains of data.
Customer Reviews
Rated 5 starsGood book for beginners
If you are an excel or access user who does not make use just yet of pivot tables and charts, this book is for you. It explains at a very basic level how to use pivot tables. Why is a matter of what you do and your math and imagination abilities. I recommend it for people who do not use them, because many people are still unfamiliar with the power of these tools and they truly are powerful and time savers. Power users...
0Report
Rated 5 starsGreat for Beginners
If you just have a basic understanding of Excel, like I do, this is an excellent guide. Very understandable for non-technical types. Gives you step-by-step instructions. If you are an expert programmer, this book is probably not for you. I thought the screen shots and demo data was particularly helpful in understanding the basics of how to use Pivot tables. Of course, like anything else, you have to apply your own practical...
0Report
Rated 4 starsthink of SQL view
Spreadsheets and SQL databases are represented as tables. That is, as rectangular grids of data. But in many ways, the common spreadsheet view is quite limited, though powerful within its context. Spreadsheet functions are often tied to specific cells as inputs. Then, interchanging two rows might cause the result to be different. A SQL view is more robust. Typically, you use data in a given column. The rows from which you...
0Report
Rated 4 starsMore about the how, less about the why
I was hoping to hear more about why I should use pivot tables and under what circumstances they are useful. There is some material on that to be sure but in general the book focuses on how to use the Pivot Table features of Excel. The advanced material is on how to script Pivot Tables using VB. The text is well written. The book is a little screenshot heavy, but you would expect that from this type of book. It's a good book,...
0Report
Rated 5 starsA well-researched tutorial on PivotTables
Like most people, I've only scratched the surface (well, maybe I gouged it a bit) of the capabilities of the Microsoft Office products. There are more features buried in them than most users ever discover. I use Microsoft Excel frequently in my job to analyze all sorts of data. When they came out with PivotTables, I dabbled in them and found several uses for them. However, documentation being what it is, I never really got...
0Report
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
