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

25. Creating Pivot Tables and Slicers

In This Chapter

• Creating a Pivot Table

• Modifying a Pivot Table

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