Course details

Excel 2019 for Windows: Inserting PivotTables

Excel 2019 for Windows: 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. In this 11-video course, you will learn how to create, edit, and format pivot tables, sort, filter, and group data, and work with slicers and timelines. Key concepts covered in this course include how to create and insert a PivotTable; how to edit the source data and field setup in a PivotTable; how to use predefined styles and formatting tools to change the appearance of a PivotTable; and how to copy and move a PivotTable within a workbook. Next, learn how to use sort tools to change the display of data; how to use filter tools to show and hide data; and how to use label and value filters to analyze data. Finally, learn how to use group tools to sort and analyze related data and use a slicer to filter data; examine how to customize the behavior and appearance of a slicer; and observe how to customize the behavior and appearance of a slicer.



Expected Duration (hours)
0.5

Lesson Objectives

Excel 2019 for Windows: 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