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

Get Office 2013 All-In-One Absolute Beginner’s Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.