X

Excel 2013 - Data Analysis with Pivot Tables

Course Overview

Analyzing data and gaining insight is important. You have experience creating PivotTables but Excel is capable of doing more. In this course, students will learn how to organize data in a way that can be meaningfully presented to others using PivotTables.

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 2013 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 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

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
12/11/2019 9:00AM - 5:00PM GTR Online LIVE OLL
01/15/2020 9:00AM - 5:00PM GTR Online LIVE OLL
02/24/2020 9:00AM - 5:00PM GTR Online LIVE OLL
04/07/2020 9:00AM - 5:00PM GTR Online LIVE OLL
05/15/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/10/2020 9:00AM - 5:00PM GTR Online LIVE OLL

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