Skip to Main Content
Office 2013 All-In-One Absolute Beginner’s Guide
book

Office 2013 All-In-One Absolute Beginner’s Guide

by Patrice-Anne Rutledge
August 2013
Beginner content levelBeginner
704 pages
18h 22m
English
Que
Content preview from Office 2013 All-In-One Absolute Beginner’s Guide

25. Creating Pivot Tables and Slicers

Pivot tables can summarize one million rows with five clicks of the mouse button. For example, if you have sales data broken up by company and product then you can quickly summarize the sales by company then product or, with a few clicks, reverse the report and summarize by product then company. Or if you’re in charge of all the local kids’ soccer leagues then you can create a report showing the number of boys versus girls, grouped by age. A pivot table can do all this and more. Another option is a slicer, which allows you to filter a pivot table, but in a much more user-friendly way.

Note

Pivot tables are so powerful ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office 2013 QuickSteps, 3rd Edition

Microsoft® Office 2013 QuickSteps, 3rd Edition

Carole Matthews, Marty Matthews, Bobbi Sandberg
Office 2013: The Missing Manual

Office 2013: The Missing Manual

Nancy Conner, Matthew MacDonald

Publisher Resources

ISBN: 9780133391541Purchase book