12. PivotTables and Slicers

In This Chapter

• Create a PivotTable.

• Sort and filter a PivotTable.

• Group dates in a PivotTable.

• Insert slicers to help users filter a PivotTable.

PivotTables 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, 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, you’re in charge of all the local kids soccer leagues and you want to create a report showing the number of boys versus girls, grouped by age. A PivotTable can do all this and more.

They’re so powerful with so many options that this chapter cannot cover it all. This chapter ...

Get Excel® 2013 Absolute Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.