My Excel 2016

15. Summarizing Data with PivotTables

In this chapter, you’ll learn how to use a PivotTable to quickly summarize data. This chapter covers the following topics:

→ Creating a PivotTable

→ Sorting and filtering a PivotTable

→ Grouping dates in a PivotTable

→ Inserting slicers to help users filter a PivotTable

You can use a PivotTable to summarize a 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, you can reverse the report and summarize by product, then company. Suppose you’re in charge of all ...