Items related to Excel 2010 Pivot Tables (Tech 102)
Synopsis
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.
- Create pivot tables from worksheet databases.
- Rearrange pivot tables by dragging, swapping, and nesting fields.
- Customize pivot tables with styles, layouts, totals, and subtotals.
- Combine numbers, dates, times, or text values into custom groups.
- Calculate common statistics or create custom formulas.
- Filter data that you don't want to see.
- Create and customize pivot charts.
- Unlink a pivot table from its source data.
- Control references to pivot table cells.
- Plenty of tips, tricks, and workarounds.
- Fully indexed and cross-referenced.
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 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 & Combinations, Mathematics of Money, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.
"synopsis" may belong to another edition of this title.
Search results for Excel 2010 Pivot Tables (Tech 102)
Stock Image
Excel 2010 Pivot Tables (Tech 102)
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. 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. Create pivot tables from worksheet databases. Rearrange pivot tables by dragging, swapping, and nesting fields. Customize pivot tables with styles, layouts, totals, and subtotals. Combine numbers, dates, times, or text values into custom groups. Calculate common statistics or create custom formulas. Filter data that you don't want to see. Create and customize pivot charts. Unlink a pivot table from its source data. Control references to pivot table cells. Plenty of tips, tricks, and workarounds. Fully indexed and cross-referenced. 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 AuthorTim 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. Seller Inventory # 00105376044
Seller Image
Excel 2010 Pivot Tables (Tech 102)
Seller: Rarewaves.com USA, London, LONDO, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: New. Seller Inventory # LU-9781937842949
Buy New
US$ 16.92
Free Shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: Over 20 available
Stock Image
Excel 2010 Pivot Tables Tech 102
Print on DemandSeller: PBShop.store US, Wood Dale, IL, U.S.A.
Seller rating 5 out of 5 stars
PAP. Condition: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781937842949
Stock Image
Excel 2010 Pivot Tables (Tech 102)
Seller: World of Books Inc, Montgomery, IL, U.S.A.
Seller rating 4 out of 5 stars
Paperback. Condition: Good. 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. Create pivot tables from worksheet databases. Rearrange pivot tables by dragging, swapping, and nesting fields. Customize pivot tables with styles, layouts, totals, and subtotals. Combine numbers, dates, times, or text values into custom groups. Calculate common statistics or create custom formulas. Filter data that you don't want to see. Create and customize pivot charts. Unlink a pivot table from its source data. Control references to pivot table cells. Plenty of tips, tricks, and workarounds. Fully indexed and cross-referenced. 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 AuthorTim 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. Seller Inventory # CIN1937842940G
Stock Image
Excel 2010 Pivot Tables (Tech 102)
Print on DemandSeller: California Books, Miami, FL, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Print on Demand. Seller Inventory # I-9781937842949
Stock Image
Excel 2010 Pivot Tables Tech 102
Print on DemandSeller: PBShop.store UK, Fairford, GLOS, United Kingdom
Seller rating 5 out of 5 stars
PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781937842949
Buy New
US$ 17.14
US$ 4.41 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: Over 20 available
Stock Image
Excel 2010 Pivot Tables (Tech 102)
Print on DemandSeller: THE SAINT BOOKSTORE, Southport, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days. Seller Inventory # C9781937842949
Buy New
US$ 18.41
US$ 16.35 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: Over 20 available
Seller Image
Excel 2010 Pivot Tables (Tech 102)
Published by
INGRAM INTERNATIONAL INC Dez 2011, 2011
ISBN 10: 1937842940
ISBN 13: 9781937842949
New
Taschenbuch
Seller: AHA-BUCH GmbH, Einbeck, Germany
Seller rating 5 out of 5 stars
Taschenbuch. Condition: Neu. Neuware. Seller Inventory # 9781937842949
Buy New
US$ 30.50
US$ 39.17 shipping
Ships from Germany to U.S.A.
Ships from Germany to U.S.A.
Quantity: 2 available
Seller Image
EXCEL 2010 PIVOT TABLES (TECH
Seller: moluna, Greven, Germany
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 905874839
Buy New
US$ 22.67
US$ 54.83 shipping
Ships from Germany to U.S.A.
Ships from Germany to U.S.A.
Quantity: Over 20 available
Stock Image
Excel 2010 Pivot Tables (Tech 102)
Seller: BennettBooksLtd, Los Angeles, CA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: New. In shrink wrap. Looks like an interesting title! Seller Inventory # Q-1937842940