Articles liés à 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.
Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.
Résultats de recherche pour Excel 2010 Pivot Tables (Tech 102)
Image d'archives
Excel 2010 Pivot Tables (Tech 102)
Edité par
Questing Vole Press, 2011
ISBN 10 : 1937842940
ISBN 13 : 9781937842949
Ancien ou d'occasion
Paperback
Vendeur : World of Books (was SecondSale), Montgomery, IL, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Paperback. Etat : 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. N° de réf. du vendeur 00105376044
Acheter D'occasion
EUR 15,56
Livraison gratuite
Expédition nationale : Etats-Unis
Expédition nationale : Etats-Unis
Quantité disponible : 1 disponible(s)
Image fournie par le vendeur
Excel 2010 Pivot Tables (Tech 102)
Vendeur : Rarewaves.com USA, London, LONDO, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
Paperback. Etat : New. N° de réf. du vendeur LU-9781937842949
Acheter neuf
EUR 15,57
Livraison gratuite
Expédition depuis Royaume-Uni vers Etats-Unis
Expédition depuis Royaume-Uni vers Etats-Unis
Quantité disponible : Plus de 20 disponibles
Image d'archives
Excel 2010 Pivot Tables Tech 102
impression à la demandeVendeur : PBShop.store US, Wood Dale, IL, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
PAP. Etat : New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. N° de réf. du vendeur L0-9781937842949
Acheter neuf
EUR 15,57
Livraison gratuite
Expédition nationale : Etats-Unis
Expédition nationale : Etats-Unis
Quantité disponible : Plus de 20 disponibles
Image d'archives
Excel 2010 Pivot Tables (Tech 102)
Edité par
Questing Vole Press, 2011
ISBN 10 : 1937842940
ISBN 13 : 9781937842949
Neuf
Couverture souple
Vendeur : California Books, Miami, FL, Etats-Unis
Évaluation du vendeur 5 sur 5 étoiles
Etat : New. Print on Demand. N° de réf. du vendeur I-9781937842949
Acheter neuf
EUR 15,64
Livraison gratuite
Expédition nationale : Etats-Unis
Expédition nationale : Etats-Unis
Quantité disponible : Plus de 20 disponibles
Image d'archives
Excel 2010 Pivot Tables (Tech 102)
Edité par
Questing Vole Press, 2011
ISBN 10 : 1937842940
ISBN 13 : 9781937842949
Ancien ou d'occasion
Paperback
Vendeur : World of Books Inc, Montgomery, IL, Etats-Unis
Évaluation du vendeur 4 sur 5 étoiles
Paperback. Etat : 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. N° de réf. du vendeur CIN1937842940G
Acheter D'occasion
EUR 17,40
Livraison gratuite
Expédition nationale : Etats-Unis
Expédition nationale : Etats-Unis
Quantité disponible : 1 disponible(s)
Image d'archives
Excel 2010 Pivot Tables (Tech 102)
Edité par
Questing Vole Press, 2011
ISBN 10 : 1937842940
ISBN 13 : 9781937842949
Ancien ou d'occasion
paperback
Vendeur : AwesomeBooks, Wallingford, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
paperback. Etat : Very Good. Excel 2010 Pivot Tables (Tech 102) This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. . N° de réf. du vendeur 7719-9781937842949
Acheter D'occasion
EUR 12,76
Expédition à EUR 4,87
Expédition depuis Royaume-Uni vers Etats-Unis
Expédition depuis Royaume-Uni vers Etats-Unis
Quantité disponible : 1 disponible(s)
Image d'archives
Excel 2010 Pivot Tables Tech 102
impression à la demandeVendeur : PBShop.store UK, Fairford, GLOS, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
PAP. Etat : New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. N° de réf. du vendeur L0-9781937842949
Acheter neuf
EUR 15,10
Expédition à EUR 3,89
Expédition depuis Royaume-Uni vers Etats-Unis
Expédition depuis Royaume-Uni vers Etats-Unis
Quantité disponible : Plus de 20 disponibles
Image d'archives
Excel 2010 Pivot Tables (Tech 102)
Edité par
Questing Vole Press -, 2011
ISBN 10 : 1937842940
ISBN 13 : 9781937842949
Ancien ou d'occasion
paperback
Vendeur : Bahamut Media, Reading, Royaume-Uni
Évaluation du vendeur 4 sur 5 étoiles
paperback. Etat : Very Good. Shipped within 24 hours from our UK warehouse. Clean, undamaged book with no damage to pages and minimal wear to the cover. Spine still tight, in very good condition. Remember if you are not happy, you are covered by our 100% money back guarantee. N° de réf. du vendeur 6545-9781937842949
Acheter D'occasion
EUR 12,76
Expédition à EUR 8,25
Expédition depuis Royaume-Uni vers Etats-Unis
Expédition depuis Royaume-Uni vers Etats-Unis
Quantité disponible : 1 disponible(s)
Image d'archives
Excel 2010 Pivot Tables (Tech 102)
Edité par
Questing Vole Press, 2011
ISBN 10 : 1937842940
ISBN 13 : 9781937842949
Neuf
Couverture souple
Vendeur : Ria Christie Collections, Uxbridge, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
Etat : New. In English. N° de réf. du vendeur ria9781937842949_new
Acheter neuf
EUR 14,96
Expédition à EUR 11,07
Expédition depuis Royaume-Uni vers Etats-Unis
Expédition depuis Royaume-Uni vers Etats-Unis
Quantité disponible : Plus de 20 disponibles
Image d'archives
Excel 2010 Pivot Tables (Tech 102)
impression à la demandeVendeur : THE SAINT BOOKSTORE, Southport, Royaume-Uni
Évaluation du vendeur 5 sur 5 étoiles
Paperback. Etat : New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days. N° de réf. du vendeur C9781937842949
Acheter neuf
EUR 16,23
Expédition à EUR 14,41
Expédition depuis Royaume-Uni vers Etats-Unis
Expédition depuis Royaume-Uni vers Etats-Unis
Quantité disponible : Plus de 20 disponibles