Microsoft Excel 2016 - Data Analysis with PivotTables

Learn how to use Excel 2016 advanced PivotTable and PivotChart functionality to summarize, analyze and present large amounts of raw data.


In this course, you will learn advanced PivotTable features and how to create PivotCharts. PivotTables and PivotCharts are tools you can use to analyze and summarize your raw data. You will learn how to organize the data in a way that can be meaningfully presented to others.


Upon successful completion of this course, you will be able to use Excel 2016 advanced PivotTable functionality to analyze your raw data.


Delegates will


·       Prepare data for PivotTable reporting and create PivotTables from various data sources.

·       Analyze Data Using PivotTables.

·       Work with PivotCharts.

Preparing Data and Creating PivotTables

Prepare Data

Create a PivotTable from a Local Data Source

Create a PivotTable from Multiple Local Data Sources

Create a PivotTable from an External Data Source


Analyzing Data Using PivotTables

Summarize PivotTable Data

Organize PivotTable Data

Filter PivotTable Data

Format a PivotTable

Refresh and Change PivotTable Data


Working with PivotCharts

Create a PivotChart

Manipulate PivotChart Data

Format a PivotChart

Program Details
Duration 1 Day
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom


Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.

Contact