Search Training
X

Excel 2016 - Data Analysis with Pivot Tables

Course Overview

Being able to harness the power of PivotTable features & create PivotCharts will help students gain an edge. Not only will students be able to summarize data to analyze, but they can organize the data in a way that can be meaningfully presented to others.

Who Should Attend

Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables.

Course Objectives

Upon successful completion of this course, you will be able to use Excel 2016 advanced PivotTable functionality to analyze your raw data. You will: Prepare data for PivotTable reporting and create PivotTables from various data sources. Analyze Data Using PivotTables. Work with PivotCharts.

Course Outline

1 - Preparing Data & 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

2 - Analyzing Data Using PivotTables

  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data

3 - Working with PivotCharts

  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart

Enroll Today

This is a 1-day class

Price: $295.00
Payment Options

ILT Instructor‑Led Training

OLL Online LIVE

GTR  Guaranteed to Run

Class times are listed Eastern time. This class is available for Private Group Training

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Cart When Time   Where How
06/27/2019 9:00AM - 5:00PM GTR Online LIVE OLL
07/10/2019 11:00AM - 7:00PM GTR Online LIVE OLL
07/23/2019 9:00AM - 5:00PM GTR Online LIVE OLL
07/29/2019 9:00AM - 5:00PM GTR Online LIVE OLL
07/30/2019 9:00AM - 5:00PM GTR Online LIVE OLL
08/02/2019 9:00AM - 5:00PM GTR Online LIVE OLL
08/16/2019 9:00AM - 5:00PM GTR Online LIVE OLL
08/29/2019 11:00AM - 7:00PM GTR Online LIVE OLL
09/12/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/24/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/01/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/04/2019 11:00AM - 7:00PM GTR Online LIVE OLL
10/14/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/15/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/24/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/05/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/15/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/26/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/27/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/09/2019 11:00AM - 7:00PM GTR Online LIVE OLL
12/19/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/23/2019 9:00AM - 5:00PM GTR Online LIVE OLL

Class times are listed Eastern time
This class is available for Private Group Training