The jargon associated with Microsoft Excel's pivot tables ( and " n -dimensional cross tabulations and ") makes them look complex, but they're really no more than an easy way to build concise, flexible summaries of long lists of raw values. If you're working with hundreds (or hundreds of thousands) of rows, then pivot tables are the best way to look at the same information in different ways, summarize data on the fly, and spot trends and relationships. 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. You can download the sample workbook to follow along with the author's examples. Contents1. Pivot Table Basics2. Nesting Fields3. Grouping Items4. Calculations and Custom Formulas5. Filtering Data6. Charting Pivot Tables7. Tricks with Pivot Tables About the AuthorTim Hill is a statistician living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. Tim has written self-teaching guides for Algebra, Trigonometry, Geometry, Precalculus, Advanced Precalculus, Permutations and u0026 Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.