Course details

Excel 2019: Inserting PivotTables

Excel 2019: Inserting PivotTables


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Excel includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables, sort, filter, and group data, and work with slicers and timelines.



Expected Duration (hours)
0.5

Lesson Objectives

Excel 2019: Inserting PivotTables

  • insert a PivotTable
  • edit the source data and field setup in a PivotTable
  • use predefined styles and formatting tools to change the appearance of a PivotTable
  • copy and move a PivotTable within a workbook
  • use sort tools to change the display of data in a PivotTable
  • use filter tools to show and hide data in a PivotTable
  • use label and value filters to analyze data in a PivotTable
  • use group tools to sort and analyze related data in a PivotTable
  • use a Slicer to filter data in a PivotTable
  • customize the behavior and appearance of a Slicer
  • customize the behavior and appearance of a Slicer
  • Course Number:
    ds_msex2019_16_enus

    Expertise Level
    Intermediate