Excel 2019: Working with Data in PivotTables


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Once your Excel PivotTables have been created, you will need to know how to manage and work with the data contained within. In this 8-video course, learners will learn how to analyze, calculate, collaborate, and more with Excel PivotTables. Key concepts covered in this course include how to use a PivotTable to find trends and drill into data, adding extra levels of detail and multiple value fields in a single table; how to use the Data Model to work with data from multiple tables; and how to import existing database tables into the Data Model and use them in a PivotTable. Next, learners will examine how to add Calculated fields that use already inserted data; how to use the Value field settings to work with values for comparison calculations; and how to see data from a PivotTable in a PivotChart then customize and format the PivotChart. Finally, because a PivotTable is highly customizable, you will observe how to configure and customize a PivotTable's display and control settings.



Expected Duration (hours)
0.5

Lesson Objectives

Excel 2019: Working with Data in PivotTables

  • use a PivotTable to find trends and drill into data
  • use the Data Model to work with data from multiple tables
  • import existing database tables into the Data Model and use them in a PivotTable
  • add Calculated Items and Calculated Fields to a PivotTable
  • use the Value tools to and summary and comparison calculations
  • visualize data from a PivotTable in a PivotChart
  • customize and format a PivotChart
  • configure and customize a PivotTable's display and control settings
  • Course Number:
    ds_msex2019_17_enus

    Expertise Level
    Intermediate