Excel 365 – Using data in PivotTables reports

Overview

Explore ways to analyze trend data using a pivot table in Excel for Office 365 in this 8-clip course that demonstrates how to organize fields, add additional levels of detail to data, and insert multiple fields value in a single table. You will learn how to use a data model to extract data from multiple tables and how to create a relational data source in a workbook. This course demonstrates how to extract data from external sources, such as an Access database, and how to analyze it in a pivot table. You’ll learn how to insert calculated fields that use data already inserted into a pivot table. You will also learn how to change a calculation summary or how to apply a comparison in a pivot table and how to view data as a percentage or as a difference. You’ll learn how to create a new pivot chart or how to convert already inserted data into a pivot table. Finally, you will use the PivotTable options to change how null data values and errors are displayed.

Objectives

• use a pivot table to find trends and analyze data
• use the data model to work with data from multiple tables
• import tables with existing databases into the data model and use them in a pivot table
• add of items and fields calculated in a pivot table
• using Value tools to add a summary and make comparison calculations
• viewing data in a pivot table in a pivot chart
• customizing and formatting a pivot chart
• configuring and customizing display and control settings for a pivot table