O'Reilly logo

Office 2013 All-In-One Absolute Beginner’s Guide by Patrice-Anne Rutledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required