Course details

Excel Office 365: Working with Data in PivotTables

Excel Office 365: 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'll need to know how to manage and work with the data contained within. See how to analyze, calculate, collaborate and more with Excel PivotTables.



Expected Duration (hours)
0.5

Lesson Objectives

Excel Office 365: 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_msex365_17_enus

    Expertise Level
    Intermediate