The jargon associated with Microsoft Excel's pivot tables ("n-dimensional cross tabulations") 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.
Contents
1. Pivot Table Basics
2. Nesting Fields
3. Grouping Items
4. Calculations and Custom Formulas
5. Filtering Data
6. Charting Pivot Tables
7. Tricks with Pivot Tables
About the Author
Tim Hill is a data scientist living in Boulder, Colorado. He holds degrees in mathematics and statistics from Stanford University and the University of Colorado. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.
"synopsis" may belong to another edition of this title.
Shipping:
FREE
Within U.S.A.
Book Description Paperback. Condition: New. Brand New! This item is printed on demand. Seller Inventory # 1515010732
Book Description Condition: New. Seller Inventory # ABLIING23Mar2716030297822
Book Description Paperback. Condition: new. New. Fast Shipping and good customer service. Seller Inventory # Holz_New_1515010732
Book Description Paperback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days. Seller Inventory # C9781515010739
Book Description Paperback. Condition: New. New copy - Usually dispatched within 4 working days. Seller Inventory # B9781515010739
Book Description Paperback. Condition: new. New. Seller Inventory # Wizard1515010732
Book Description Paperback. Condition: new. New Copy. Customer Service Guaranteed. Seller Inventory # think1515010732