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
11/26/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/27/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/04/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/05/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/09/2019 11:00AM - 7:00PM GTR Online LIVE OLL
12/13/2019 9:00AM - 5: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
01/03/2020 9:00AM - 5:00PM GTR Online LIVE OLL
01/16/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/24/2020 9:00AM - 5:00PM GTR Online LIVE OLL
01/24/2020 9:00AM - 5:00PM GTR Online LIVE OLL
01/31/2020 9:00AM - 5:00PM GTR Online LIVE OLL
02/10/2020 9:00AM - 5:00PM GTR Online LIVE OLL
02/18/2020 9:00AM - 5:00PM GTR Online LIVE OLL
02/21/2020 9:00AM - 5:00PM GTR Online LIVE OLL
02/26/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/05/2020 9:00AM - 5:00PM GTR Online LIVE OLL
03/13/2020 9:00AM - 5:00PM GTR Online LIVE OLL
03/19/2020 9:00AM - 5:00PM GTR Online LIVE OLL
03/24/2020 9:00AM - 5:00PM GTR Online LIVE OLL
04/01/2020 9:00AM - 5:00PM GTR Online LIVE OLL
04/09/2020 9:00AM - 5:00PM GTR Online LIVE OLL
04/17/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/24/2020 9:00AM - 5:00PM GTR Online LIVE OLL
05/05/2020 9:00AM - 5:00PM GTR Online LIVE OLL
05/13/2020 9:00AM - 5:00PM GTR Online LIVE OLL
05/15/2020 9:00AM - 5:00PM GTR Online LIVE OLL
05/22/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/29/2020 9:00AM - 5:00PM GTR Online LIVE OLL
06/02/2020 9:00AM - 5:00PM GTR Online LIVE OLL
06/09/2020 9:00AM - 5:00PM GTR Online LIVE OLL
06/17/2020 9:00AM - 5:00PM GTR Online LIVE OLL
06/23/2020 11:00AM - 7:00PM GTR Online LIVE OLL
07/02/2020 9:00AM - 5:00PM GTR Online LIVE OLL

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