Pivot Tables are one of the Microsoft Excel spreadsheet’s hidden gems. They are simultaneously powerful and intimidating to Office users. They allow you to quickly summarize and analyze large amounts of data in lists and tables--independent of the original data layout in your spreadsheet--by dragging and dropping columns to different rows, columns, or summary positions. This ability to create neat, informative summaries out of huge lists of raw data is an immensely powerful tool, and one that is rapidly growing in popularity.

Pivot Tables are a growth area with huge numbers of people beginning to realize the powerful tools they have available on their desktops (as evidenced by the success of our previous Pivot Tables book (A Complete Guide to PivotTables: A Visual Approach, 1-59059-432-0). This book is a complement to that. It provides its readers with an indispensable quick-reference to solve the common problems that beset Excel users venturing into this area for the first time. It’s succinct problem-solution style, and willingness to discuss the practical details of Pivot Table use set it apart from the competition.

Beginning-Intermediate MS Office Power users