iTunes

Opening the iTunes Store.If iTunes doesn’t open, click the iTunes icon in your Dock or on your Windows desktop.Progress Indicator
Opening Apple Books.If Apple Books doesn't open, click the Books app in your Dock.Progress Indicator
iTunes

iTunes is the world's easiest way to organize and add to your digital media collection.

We are unable to find iTunes on your computer. To download from the iTunes Store, get iTunes now.

Do you already have iTunes? Click I Have iTunes to open it now.

I Have iTunes Free Download

Excel 2010 Pivot Tables

Tech 102

This book can be downloaded and read in Apple Books on your Mac or iOS device.

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.

Screenshots

screenshot 1
screenshot 2
screenshot 3
screenshot 4
screenshot 5
Excel 2010 Pivot Tables
View in iTunes
  • £4.49
  • Available on iPhone, iPad, iPod touch, and Mac.
  • Category: Software
  • Published: 02 September 2011
  • Publisher: Questing Vole Press
  • Print Length: 74 Pages
  • Language: English
  • Requirements: This book can only be viewed on an iOS device with Apple Books on iOS 12 or later, iBooks 1.3.1 or later and iOS 4.3.3 or later or a Mac with iBooks 1.0 or later and OS X 10.9 or later.

Customer Ratings

We have not received enough ratings to display an average for this book.