Microsoft Excel 2016 for Mac: PivotTables


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
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.

Expected Duration (hours)
0.7

Lesson 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

    • Course Number:
    ds_msex16mc_12_enus

    Expertise Level
    Intermediate