0
Your cart

Your cart is empty

Books > Computing & IT > Computer software packages > Spreadsheet software

Buy Now

Excel 2013 Pivot Tables (Tech 102) (Paperback) Loot Price: R277
Discovery Miles 2 770
Excel 2013 Pivot Tables (Tech 102) (Paperback): Tim Hill

Excel 2013 Pivot Tables (Tech 102) (Paperback)

Tim Hill

 (sign in to rate)
Loot Price R277 Discovery Miles 2 770

Bookmark and Share

Expected to ship within 10 - 15 working days

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 miner based in Las Vegas, Nevada. When he's not crunching numbers, Tim plays poker, hikes canyons, and avoids malls.

General

Imprint: Questing Vole Press
Country of origin: United States
Release date: October 2012
First published: October 2012
Authors: Tim Hill
Dimensions: 216 x 140 x 4mm (L x W x T)
Format: Paperback - Trade
Pages: 76
ISBN-13: 978-1-937842-05-5
Categories: Books > Computing & IT > Computer software packages > Spreadsheet software > General
Promotions
LSN: 1-937842-05-3
Barcode: 9781937842055

Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

Does this product have an incorrect or missing image? Send us a new image.

Is this product missing categories? Add more categories.

Review This Product

No reviews yet - be the first to create one!

Partners