Course details

Excel Office 365 (Windows): Working with Data in PivotTables

Excel Office 365 (Windows): Working with Data in PivotTables


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Explore ways to analyze data for trends by using a PivotTable in Excel for Office 365, in this 8-video course, which demonstrates how to organize fields, add extra levels of detail to data, and to insert multiple value fields in a single table. You will observe how to use a data model to pull data from multiple tables and build a relational data source inside a workbook. This course demonstrates how to pull data from external sources, for example, an Access database, and analyze it in a PivotTable. You will learn to insert calculated fields that use already inserted data in the PivotTable. You will also learn how to change a summary calculation or apply a comparison in a PivotTable, and how to visualize data rank as a percentage or as a difference. You will learn how to create a new PivotChart or convert already inserted data in a PivotTable. Finally, you to use PivotTable options to change how null data values and errors are displayed.



Expected Duration (hours)
0.5

Lesson Objectives

Excel Office 365 (Windows): 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