Excel 2013 Pivot Tables And Charts

Download Excel 2013 Pivot Tables And Charts full books in PDF, epub, and Kindle. Read online Excel 2013 Pivot Tables And Charts ebook anywhere anytime directly on your device. Fast Download speed and no annoying ads. We cannot guarantee that every ebooks is available!

Excel 2013 Pivot Table Data Crunching

Author : Bill Jelen
Publisher : Pearson Education
ISBN 13 : 0789748754
Total Pages : 432 pages
Book Rating : 4.7/5 (897 download)

DOWNLOAD NOW!

Book Synopsis Excel 2013 Pivot Table Data Crunching by : Bill Jelen

Download or read book Excel 2013 Pivot Table Data Crunching written by Bill Jelen and published by Pearson Education. This book was released on 2013-03-18 with total page 432 pages. Available in PDF, EPUB and Kindle. Book excerpt: PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this expert tutorial, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 35 combined years of Excel experience, they provide tips and tricks readers won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: * Creating PivotTables, customizing them, and changing the way you view them * Performing calculations within PivotTables * Using PivotCharts and other visualizations * Analyzing multiple data sources with PivotTables * Sharing PivotTables with others * Working with and analyzing OLAP data * Making the most of Excel 2013's powerful new PowerPivot feature * Using Excel 2013's Slicer to dynamically filter PivotTables * Enhancing PivotTables with macros and VBA code This book is part of the popular MrExcel's Library series, edited by Bill Jelen, world-renowned Excel expert and host of the world-renowned Excel help site, MrExcel.com.

Excel 2013 Pivot Table Data Crunching

Author : Bill Jelen
Publisher : Que Publishing
ISBN 13 : 0133259331
Total Pages : 432 pages
Book Rating : 4.1/5 (332 download)

DOWNLOAD NOW!

Book Synopsis Excel 2013 Pivot Table Data Crunching by : Bill Jelen

Download or read book Excel 2013 Pivot Table Data Crunching written by Bill Jelen and published by Que Publishing. This book was released on 2013-01-07 with total page 432 pages. Available in PDF, EPUB and Kindle. Book excerpt: CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES! Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours... understand exactly what’s going on in your business... take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function. Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. You’ll find simple, step-by-step instructions, real-world case studies, even complete, easy recipes for solving your most common business analysis problems. • Create, customize, and change your pivot tables and pivot charts • Transform gigantic data sets into crystal-clear summary reports • Summarize and analyze data even faster with new Excel 2013 recommended pivot tables • Instantly highlight your most (and least) profitable customers, products, or regions • Quickly filter pivot tables using slicers • Use dynamic dashboards using Power View to see exactly where your business stands right now • Revamp analyses on the fly by simply dragging and dropping fields • Build dynamic self-service reporting systems your entire team can use • Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets • Work with and analyze OLAP data, and much more About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will • Dramatically increase your productivity—saving you 50 hours a year or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make CATEGORY: Spreadsheets COVERS: Microsoft Office Excel 2013

Excel 2013 Pivot Tables and Charts

Author : BarCharts, Inc
Publisher :
ISBN 13 : 9781423222910
Total Pages : 0 pages
Book Rating : 4.2/5 (229 download)

DOWNLOAD NOW!

Book Synopsis Excel 2013 Pivot Tables and Charts by : BarCharts, Inc

Download or read book Excel 2013 Pivot Tables and Charts written by BarCharts, Inc and published by . This book was released on 2014-05-31 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: Make powerful data analysis simple with our newest Excel guide. Quickly select and move data fields between rows and columns, reorder data fields, summarize data, filter data, and display the results graphically in a PivotChart. Use your data to get results and get one step closer to being an Excel power user.

Excel 2013 Pivot Tables & Charts

Author : BarCharts, Inc
Publisher :
ISBN 13 : 9781423223337
Total Pages : 6 pages
Book Rating : 4.2/5 (233 download)

DOWNLOAD NOW!

Book Synopsis Excel 2013 Pivot Tables & Charts by : BarCharts, Inc

Download or read book Excel 2013 Pivot Tables & Charts written by BarCharts, Inc and published by . This book was released on 2014 with total page 6 pages. Available in PDF, EPUB and Kindle. Book excerpt:

Excel 2013 Pivot Tables

Author : Tim Hill
Publisher : Questing Vole Press
ISBN 13 : 1937842053
Total Pages : 86 pages
Book Rating : 4.9/5 (378 download)

DOWNLOAD NOW!

Book Synopsis Excel 2013 Pivot Tables by : Tim Hill

Download or read book Excel 2013 Pivot Tables written by Tim Hill and published by Questing Vole Press. This book was released on 2012-10-11 with total page 86 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Excel 2013 Pivot Tables: Including the Data Model

Author : Maayan Poleg
Publisher : CreateSpace
ISBN 13 : 9781511820875
Total Pages : 180 pages
Book Rating : 4.8/5 (28 download)

DOWNLOAD NOW!

Book Synopsis Excel 2013 Pivot Tables: Including the Data Model by : Maayan Poleg

Download or read book Excel 2013 Pivot Tables: Including the Data Model written by Maayan Poleg and published by CreateSpace. This book was released on 2015-04-19 with total page 180 pages. Available in PDF, EPUB and Kindle. Book excerpt: Excel 2013 Pivot TablesIncluding the "Data Model"A pivot table is a simple, yet powerful technique, that enables Excel's users to transform data overload into meaningful and organized knowledge.With pivot tables you can:* See the data in dozens of different ways with a simple mouse drag* Perform fast calculations with no need for formulas* Focus on another part of the data each time and get a clear picture* Show more trends and patterns* Create dozens of reports and charts to analyze your dataWhile reading the book and using the practice files, you will know to:Create a Pivot Tableo Select data from the current fileo Selec data from another Excel fileo Change the data sourceo Create a pivot table based on a dynamic data tablePerform Calculations:o Use sum, average, minimum, maximum and counto Show Percentage of a column total, row total and Grand totalo Display the running totalo Group numeric and date datao Use calculated field and calculated itemChange The Report Structureo Switching columns and rowso Adding columns or rowso Adding a page break between itemsFormat your Pivot Tableso Add totals and Subtotalso Sorto FilterYou will also know to* Add slicers and to manipulate then* Add a timelines and to manipulate it* Add charts to your pivot tables* Use the new and innovative feature: "The Data Model"And, of course, You will learn some cool tips and tricks!

Excel 2013 Pivot Tables: Including the Data Model (full Color)

Author : Maayan Poleg
Publisher : CreateSpace
ISBN 13 : 9781511954877
Total Pages : 180 pages
Book Rating : 4.9/5 (548 download)

DOWNLOAD NOW!

Book Synopsis Excel 2013 Pivot Tables: Including the Data Model (full Color) by : Maayan Poleg

Download or read book Excel 2013 Pivot Tables: Including the Data Model (full Color) written by Maayan Poleg and published by CreateSpace. This book was released on 2015-04-29 with total page 180 pages. Available in PDF, EPUB and Kindle. Book excerpt: Excel 2013 Pivot TablesIncluding the "Data Model"A pivot table is a simple, yet powerful technique, that enables Excel's users to transform data overload into meaningful and organized knowledge.With pivot tables you can:* See the data in dozens of different ways with a simple mouse drag* Perform fast calculations with no need for formulas* Focus on another part of the data each time and get a clear picture* Show more trends and patterns* Create dozens of reports and charts to analyze your dataWhile reading the book and using the practice files, you will know to:Create a Pivot Tableo Select data from the current fileo Selec data from another Excel fileo Change the data sourceo Create a pivot table based on a dynamic data tablePerform Calculations:o Use sum, average, minimum, maximum and counto Show Percentage of a column total, row total and Grand totalo Display the running totalo Group numeric and date datao Use calculated field and calculated itemChange The Report Structureo Switching columns and rowso Adding columns or rowso Adding a page break between itemsFormat your Pivot Tableso Add totals and Subtotalso Sorto FilterYou will also know to* Add slicers and to manipulate then* Add a timelines and to manipulate it* Add charts to your pivot tables* Use the new and innovative feature: "The Data Model"And, of course, You will learn some cool tips and tricks!

Excel 2013 Charts and Graphs

Author : Bill Jelen
Publisher : Que Publishing
ISBN 13 : 013325951X
Total Pages : 761 pages
Book Rating : 4.1/5 (332 download)

DOWNLOAD NOW!

Book Synopsis Excel 2013 Charts and Graphs by : Bill Jelen

Download or read book Excel 2013 Charts and Graphs written by Bill Jelen and published by Que Publishing. This book was released on 2013-02-20 with total page 761 pages. Available in PDF, EPUB and Kindle. Book excerpt: Use Excel 2013’s radically revamped charting and graphing tools to communicate more clearly, powerfully, and quickly... so you drive your message home, and get the decisions and actions you’re looking for! This book reveals data visualization techniques you won’t find anywhere else and shows you how to use Excel 2013 to create designer-quality charts and graphs that stand out from the crowd. It will help you make the most of new features ranging from Power View to Recommended Charts, and instantly share your insights with anyone, anywhere–even on the Web and social networks. Learning advanced Excel techniques has never been easier. You’ll find simple, step-by-step instructions, real-world examples and case studies, and more than a dozen YouTube videos, straight from MrExcel! • Create stunning data visualizations instantly with Excel 2013’s new Recommended Charts • Use charts to instantly reveal trends, differences, and relationships • Map your data with Excel 2013, MapPoint, and the new GeoFlow add-in • Quickly generate combo charts that once required complex, frustrating procedures • Use sparklines to imbue worksheets with more context and insight • Highlight and clarify the meaning of data with DataBars, color scales, icon sets, and other conditional formatting tools • Post charts to Facebook, Twitter, or LinkedIn, directly from Excel • Build stock charts that help you make smarter investments • Solve “non-standard” problems such as noncontiguous data or custom data sequences • Generate new charts automatically with Excel VBA • Uncover visual tricks that people use to lie with Excel About MrExcel Library: Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will: • Dramatically increase your productivity–saving you 50 hours a year or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make

Excel: Pivot Tables and Charts

Author : John Hales
Publisher :
ISBN 13 : 9781423216438
Total Pages : 0 pages
Book Rating : 4.2/5 (164 download)

DOWNLOAD NOW!

Book Synopsis Excel: Pivot Tables and Charts by : John Hales

Download or read book Excel: Pivot Tables and Charts written by John Hales and published by . This book was released on 2011-05-31 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: Among the many data analyzing features to be found in Microsoft's Excel software, PivotTables and PivotCharts are two of the most useful. Find out how they can work for you with our jam-packed 3-panel guide, which features step-by-step instructions and full-color screen shots for easy reference.

Pivot Table Data Crunching

Author : Bill Jelen
Publisher : Pearson Education
ISBN 13 : 0789746689
Total Pages : 581 pages
Book Rating : 4.7/5 (897 download)

DOWNLOAD NOW!

Book Synopsis Pivot Table Data Crunching by : Bill Jelen

Download or read book Pivot Table Data Crunching written by Bill Jelen and published by Pearson Education. This book was released on 2010-10-20 with total page 581 pages. Available in PDF, EPUB and Kindle. Book excerpt: PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen

101 Excel 2013 Tips, Tricks and Timesavers

Author : John Walkenbach
Publisher : John Wiley & Sons
ISBN 13 : 1118642325
Total Pages : 327 pages
Book Rating : 4.1/5 (186 download)

DOWNLOAD NOW!

Book Synopsis 101 Excel 2013 Tips, Tricks and Timesavers by : John Walkenbach

Download or read book 101 Excel 2013 Tips, Tricks and Timesavers written by John Walkenbach and published by John Wiley & Sons. This book was released on 2013-06-10 with total page 327 pages. Available in PDF, EPUB and Kindle. Book excerpt: Get the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more, 101 Excel 2013 Tips, Tricks, & Timesavers will save you time and help you avoid common spreadsheet stumbling blocks. Reveals ways to maximize the power of Excel to create robust applications Draws on John Walkenbach's years of experience using Excel and writing more than 50 books Shares tips and tricks for dealing with function arguments, creating add-ins, using UserForms, working with dynamic chart data, and changing data entry orientation Provides shortcuts and helpful techniques for sorting more than three columns, entering fake data for testing purposes, and setting up powerful pivot tables 101 Excel 2013 Tips, Tricks, & Timesavers is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel!

Excel 2013: Pivot Tables

Author :
Publisher :
ISBN 13 :
Total Pages : pages
Book Rating : 4.:/5 (113 download)

DOWNLOAD NOW!

Book Synopsis Excel 2013: Pivot Tables by :

Download or read book Excel 2013: Pivot Tables written by and published by . This book was released on 2013 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt: Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.

Excel 2002 For Dummies

Author : Greg Harvey
Publisher : For Dummies
ISBN 13 : 9780764508226
Total Pages : 0 pages
Book Rating : 4.5/5 (82 download)

DOWNLOAD NOW!

Book Synopsis Excel 2002 For Dummies by : Greg Harvey

Download or read book Excel 2002 For Dummies written by Greg Harvey and published by For Dummies. This book was released on 2001-06-15 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: Just because electronic spreadsheets like Excel 2002 have become almost as commonplace on today's personal computers as word processors and games doesn't mean that they're either well understood or well used. If you're one of the many folks who has Office XP on your computer but doesn't know a spreadsheet from a bedsheet, this means that Excel 2002 is just sitting there taking up a lot of space. Well, it's high time to change all that. One look at the Excel 2002 screen (with all its boxes, buttons, and tabs), and you realize how much stuff is going on there. Excel 2002 For Dummies will help you make some sense out of the rash of icons, buttons, and boxes that you're going to be facing day after day. And when you ready to go beyond spreadsheet basics, this guide will also introduce you to Conjuring up charts Inserting graphics Designing a database Converting spreadsheets into Web pages Most of all, Excel 2002 For Dummies covers the fundamental techniques that you need to know in order to create, edit, format, and print your own worksheets. In this book, you'll find all the information that you need to keep your head above water as you accomplish the everyday tasks that people do with Excel. This down-to-earth guide covers all these topics and more: Creating a spreadsheet from scratch Document recovery Formatting fundamentals Making corrections (and how to undo them) Retrieving data from your spreadsheets Protecting your documents Demystifying formulas Now, even if your job doesn't involve creating worksheets with a lot of fancy financial calculations or lah-dee-dah charts, you probably have plenty of things for which you could and should be using Excel. For instance, you may have to keep lists of information or maybe even put together tables of information for your job. Excel is a great list keeper and one heck of a table maker. You can use Excel anytime you need to keep track of products that you sell, clients who you service, employees who you oversee, or you name it.

Microsoft Excel 2010

Author : Philip Wiest
Publisher :
ISBN 13 : 9781608113767
Total Pages : pages
Book Rating : 4.1/5 (137 download)

DOWNLOAD NOW!

Book Synopsis Microsoft Excel 2010 by : Philip Wiest

Download or read book Microsoft Excel 2010 written by Philip Wiest and published by . This book was released on 2011 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt: "Have you discovered the power of PivotTables? The 'too complicated' excuse is gone - Excel 2010 makes creating and using PivotTables easier and faster than before. In this comprehensive 10-part program, master trainer Philip Wiest shows you what's new - and what tools can help you the most. From layout and organization to analyzing data and creating reports, this tutorial breaks down this amazing Excel feature and teaches you all you need to know. With the help of this video DVD, Microsoft Excel PivotTables will soon become your most valuable tool for sorting through and summarizing data."--Container.

Microsoft Office Excel 2013 PivotTables

Author : I.F.S. Harrison
Publisher : I.F.S. Harrison
ISBN 13 : 1301434302
Total Pages : 71 pages
Book Rating : 4.3/5 (14 download)

DOWNLOAD NOW!

Book Synopsis Microsoft Office Excel 2013 PivotTables by : I.F.S. Harrison

Download or read book Microsoft Office Excel 2013 PivotTables written by I.F.S. Harrison and published by I.F.S. Harrison. This book was released on 2013-01-03 with total page 71 pages. Available in PDF, EPUB and Kindle. Book excerpt: PivotTables will help you analyze, summarize and pick apart your large spreadsheets fast. Microsoft Office Excel 2013 has many new features to take advantage of like Recommended PivotTables and Timelines. Are you new to PivotTables? This eBook will walk you through the ins and outs. Have you been using PivotTables for a while? Learn tips, tricks and the latest features. Purchase your copy today! Don’t have Microsoft Office Excel 2013? No Problem. Many exercises are applicable to PivotTables in Excel 2010 as well.

Statistical Analysis

Author : Conrad Carlberg
Publisher : Que Publishing
ISBN 13 : 0133823997
Total Pages : 714 pages
Book Rating : 4.1/5 (338 download)

DOWNLOAD NOW!

Book Synopsis Statistical Analysis by : Conrad Carlberg

Download or read book Statistical Analysis written by Conrad Carlberg and published by Que Publishing. This book was released on 2014-04-04 with total page 714 pages. Available in PDF, EPUB and Kindle. Book excerpt: Use Excel 2013’s statistical tools to transform your data into knowledge Conrad Carlberg shows how to use Excel 2013 to perform core statistical tasks every business professional, student, and researcher should master. Using real-world examples, Carlberg helps you choose the right technique for each problem and get the most out of Excel’s statistical features, including recently introduced consistency functions. Along the way, he clarifies confusing statistical terminology and helps you avoid common mistakes. You’ll learn how to use correlation and regression, analyze variance and covariance, and test statistical hypotheses using the normal, binomial, t, and F distributions. To help you make accurate inferences based on samples from a population, this edition adds two more chapters on inferential statistics, covering crucial topics ranging from experimental design to the statistical power of F tests. Becoming an expert with Excel statistics has never been easier! You’ll find crystal-clear instructions, insider insights, and complete step-by-step projects—all complemented by extensive web-based resources. Master Excel’s most useful descriptive and inferential statistical tools Tell the truth with statistics—and recognize when others don’t Accurately summarize sets of values Infer a population’s characteristics from a sample’s frequency distribution Explore correlation and regression to learn how variables move in tandem Use Excel consistency functions such as STDEV.S() and STDEV.P() Test differences between two means using z tests, t tests, and Excel’s Data Analysis Add-in Use ANOVA to test differences between more than two means Explore statistical power by manipulating mean differences, standard errors, directionality, and alpha Take advantage of Recommended PivotTables, Quick Analysis, and other Excel 2013 shortcuts

Excel 2013: Pivot Tables

Author :
Publisher :
ISBN 13 :
Total Pages : pages
Book Rating : 4.:/5 (111 download)

DOWNLOAD NOW!

Book Synopsis Excel 2013: Pivot Tables by :

Download or read book Excel 2013: Pivot Tables written by and published by . This book was released on 2013 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt: Learn to summarize, sort, count, and chart your data with PivotTables in these Excel tutorials.