Excel 2016: Data Analysis with Pivot Tables

Skills covered:
Displaying courses for United States [Change]

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.

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.

Audience

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

Syllabus

Preparing Data & Creating PivotTables

  • Topic A: Prepare Data
  • Topic B: Create a PivotTable from a Local Data Source
  • Topic C: Create a PivotTable from Multiple Local Data Sources
  • Topic D: Create a PivotTable from an External Data Source

Analyzing Data Using PivotTables

  • Topic A: Summarize PivotTable Data
  • Topic B: Organize PivotTable Data
  • Topic C: Filter PivotTable Data
  • Topic D: Format a PivotTable
  • Topic E: Refresh and Change PivotTable Data

Working with PivotCharts

  • Topic A: Create a PivotChart
  • Topic B: Manipulate PivotChart Data
  • Topic C: Format a PivotChart

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 0.5 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

C
United States
This skill has an average salary of
US$82,050
and is mentioned in
6.25%
of job ads in this area.