Excel 2016 for Windows Pivot Tables

3.8 avg rating
( 5 ratings by Goodreads )
 
9781515010739: Excel 2016 for Windows Pivot Tables
View all copies of this ISBN edition:
 
 

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 timesavers.
  • Fully cross-referenced and indexed.

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.

Top Search Results from the AbeBooks Marketplace

1.

Hill, Tim
Published by Createspace Independent Publishing Platform (2015)
ISBN 10: 1515010732 ISBN 13: 9781515010739
New Quantity Available: > 20
Print on Demand
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description Createspace Independent Publishing Platform, 2015. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9781515010739

More information about this seller | Contact this seller

Buy New
US$ 7.16
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

2.

Hill, Tim
Published by CreateSpace Independent Publis (2018)
ISBN 10: 1515010732 ISBN 13: 9781515010739
New Paperback Quantity Available: > 20
Print on Demand
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publis, 2018. Paperback. Condition: New. Never used! This item is printed on demand. Seller Inventory # 1515010732

More information about this seller | Contact this seller

Buy New
US$ 11.32
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

3.

Tim Hill
Published by Createspace Independent Publishing Platform (2015)
ISBN 10: 1515010732 ISBN 13: 9781515010739
New Paperback Quantity Available: 10
Print on Demand
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description Createspace Independent Publishing Platform, 2015. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****. 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 timesavers. Fully cross-referenced and indexed. 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. Seller Inventory # APC9781515010739

More information about this seller | Contact this seller

Buy New
US$ 11.96
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

4.

Tim Hill
Published by Createspace Independent Publishing Platform (2015)
ISBN 10: 1515010732 ISBN 13: 9781515010739
New Paperback Quantity Available: 10
Print on Demand
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Createspace Independent Publishing Platform, 2015. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****.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 timesavers. Fully cross-referenced and indexed. 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. Seller Inventory # APC9781515010739

More information about this seller | Contact this seller

Buy New
US$ 12.12
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

5.

Hill, Tim
Published by Createspace Independent Publishing Platform (2015)
ISBN 10: 1515010732 ISBN 13: 9781515010739
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Createspace Independent Publishing Platform, 2015. 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 # IQ-9781515010739

More information about this seller | Contact this seller

Buy New
US$ 6.75
Convert currency

Add to Basket

Shipping: US$ 11.72
From United Kingdom to U.S.A.
Destination, rates & speeds

6.

Tim Hill
Published by CreateSpace Independent Publishing Platform
ISBN 10: 1515010732 ISBN 13: 9781515010739
New Paperback Quantity Available: > 20
Print on Demand
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publishing Platform. Paperback. Condition: New. This item is printed on demand. 72 pages. Dimensions: 10.0in. x 8.0in. x 0.2in.The jargon associated with Microsoft Excels pivot tables (n-dimensional cross tabulations) makes them look complex, but theyre really no more than an easy way to build concise, flexible summaries of long lists of raw values. If youre 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 Excels 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 authors 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 dont 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 timesavers. Fully cross-referenced and indexed. 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 miner based in Las Vegas, Nevada. When hes not crunching numbers, Tim plays poker, hikes canyons, and avoids malls. This item ships from La Vergne,TN. Paperback. Seller Inventory # 9781515010739

More information about this seller | Contact this seller

Buy New
US$ 18.57
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

7.

Tim Hill
Published by CreateSpace Independent Publishing Platform (2015)
ISBN 10: 1515010732 ISBN 13: 9781515010739
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description CreateSpace Independent Publishing Platform, 2015. Condition: New. book. Seller Inventory # M1515010732

More information about this seller | Contact this seller

Buy New
US$ 20.84
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds