{"product_id":"excel-2011-for-mac-pivot-tables-tech-102-paperback","title":"Excel 2011 for Mac Pivot Tables (Tech 102) - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eTim Hill\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eThe jargon associated with Microsoft Excel's pivot tables (\"\u003ci\u003en\u003c\/i\u003e-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.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCreate pivot tables from worksheet databases.\u003c\/li\u003e\n\u003cli\u003eRearrange pivot tables by dragging, swapping, and nesting fields.\u003c\/li\u003e\n\u003cli\u003eCustomize pivot tables with styles, layouts, totals, and subtotals.\u003c\/li\u003e\n\u003cli\u003eCombine numbers, dates, times, or text values into custom groups.\u003c\/li\u003e\n\u003cli\u003eCalculate common statistics or create custom formulas.\u003c\/li\u003e\n\u003cli\u003eFilter data that you don't want to see.\u003c\/li\u003e\n\u003cli\u003eUnlink a pivot table from its source data.\u003c\/li\u003e\n\u003cli\u003eControl references to pivot table cells.\u003c\/li\u003e\n\u003cli\u003ePlenty of tips, tricks, and timesavers.\u003c\/li\u003e\n\u003cli\u003eFully indexed and cross-referenced.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cb\u003eContents\u003c\/b\u003e\u003cbr\u003e1. Pivot Table Basics\u003cbr\u003e2. Nesting Fields\u003cbr\u003e3. Grouping Items\u003cbr\u003e4. Calculations and Custom Formulas\u003cbr\u003e5. Filtering Data\u003cbr\u003e6. Tricks with Pivot Tables\u003c\/p\u003e\u003cp\u003e\u003cb\u003eAbout the Author\u003c\/b\u003e\u003cbr\u003eTim 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 \u0026amp; Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 66\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.14 x 8.5 x 5.5 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e October 30, 2014\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":48264843985145,"sku":"9781937842031","price":14.83,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/M2wME7aTe-9781937842031.webp?v=1775758577","url":"https:\/\/bookscloud.io\/products\/excel-2011-for-mac-pivot-tables-tech-102-paperback","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}