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

  • Creating a PivotTable
  • Editing your PivotTable
  • Inserting a calculation in your PivotTable
  • Sorting data in your PivotTable
  • Filtering your table data
  • Grouping data in your PivotTable
  • Inserting a slicer in your PivotTable
  • Comparing values in a PivotTable
  • Formatting your PivotTable
  • Copying & reusing your PivotTable
  • Course Number:
    ds_msex16mc_12_enus

    Expertise Level
    Intermediate