Productivity & Collaboration Tools     Microsoft Office for Mac 2016     Microsoft Office for Mac 2016: Excel (No Assessments)

---

A PivotTable is one of the most powerful and intimidating features in Excel. Learn how to get the most out of a PivotTable to help you summarize and extract information from your data.

---

---

Objectives

Microsoft Excel 2016 for Mac: PivotTables create PivotTables in Excel 2016 for Mac edit PivotTables in Excel 2016 for Mac insert calculations in PivotTables in Excel 2016 for Mac sort data in PivotTables in Excel 2016 for Mac filter your table data in Excel 2016 for Mac create data groups in your PivotTables insert a slicer into your PivotTable compare values in your PivotTables format your PivotTables copy and reuse your PivotTable