Excel 2010 Pivot Tables Excel 2010 Pivot Tables

Excel 2010 Pivot Tables

Tech 102

    • 3.0 • 1 Rating
    • $7.99
    • $7.99

Publisher Description

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, linked, and searchable.


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, Excel Loan & Mortgage Formulas, and Excel Pivot Tables. When he's not crunching numbers, Tim climbs rocks, hikes canyons, and avoids malls.

  • GENRE
    Computing & Internet
    RELEASED
    2011
    2 September
    LANGUAGE
    EN
    English
    LENGTH
    74
    Pages
    PUBLISHER
    Questing Vole Press
    SELLER
    Questing Vole Press
    SIZE
    2.9
    MB

    More Books Like This

    Excel 2016 for Windows Pivot Tables Excel 2016 for Windows Pivot Tables
    2015
    Excel 2016 for Mac Pivot Tables Excel 2016 for Mac Pivot Tables
    2015
    Pivot Tables In Depth For Microsoft Excel 2016 Pivot Tables In Depth For Microsoft Excel 2016
    2017
    Excel PivotTables and PivotCharts Excel PivotTables and PivotCharts
    2011
    Excel Power Pivot & Power Query For Dummies Excel Power Pivot & Power Query For Dummies
    2022
    Excel Data Analysis For Dummies Excel Data Analysis For Dummies
    2018

    More Books by Tim Hill

    Excel 2013 Pivot Tables Excel 2013 Pivot Tables
    2012
    Excel 2016 for Mac Pivot Tables Excel 2016 for Mac Pivot Tables
    2015
    Excel 2016 for Windows Pivot Tables Excel 2016 for Windows Pivot Tables
    2015
    Essential Algebra Essential Algebra
    2013
    Excel 2011 for Mac Pivot Tables Excel 2011 for Mac Pivot Tables
    2012
    Essential Trigonometry Essential Trigonometry
    2013

    Customers Also Bought