Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Excel 2013 - Data Analysis with Pivot Tables

New – Summarize and analyze large amounts of data using Pivot Tables.

GK# 6746

Course Overview

TOP

Students will learn how to use Pivot Tables to summarize and analyze large amounts of data. They will learn about the available tools that are available to assist with this task.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP

Upon successful completion of this course, students will be able to understand, create, and format Pivot Tables.

Outline

TOP
Viewing outline for:

Classroom Live Outline

Understanding Pivot Tables

  • Types of Pivot Table reports
  • Source data for Pivot Table reports
  • Creating Worksheet Lists

Using Names

  • Create a Name
  • Using a Name in a Formula
  • Creating Names for a Multiple Rows or Columns
  • Creating Names for a Value or Formula

Creating a Pivot Table

  • Pivot Table Field List
  • Completing the Report
  • Pivot Table Tools
  • Rearranging the Pivot Table
  • Changing the Report Field Titles
  • Formatting Data Fields

Using the Report Filter

  • Displaying Filtered Fields on Separate Worksheets

Formatting the Pivot Table

  • Sorting Data
  • Removing Data
  • Refreshing Data

Using Formulas Functions

  • Create a Calculated Field
  • Create Implicit Calculated Fields (Previously Called “Measures”)
  • Add or Remove Subtotals in a Pivot Table Report
  • Display or Hide Details

Working with Multiple Data Ranges

  • Setting Up the Source Data
  • Using Named Ranges When Source Data is Likely to Expand

Creating Pivot Charts

  • Creating the Chart
  • Moving the Chart to a New Worksheet
  • Chart Tools
  • Using Pivot Table Data Outside the Pivot Table Report
  • Create Relationships Between Data from Different Sources and Multiple Tables in a Pivot Table

Creating a Pivot Table from a Database

  • Databases You Can Access
  • Refreshing the Data

Publishing an Excel Workbook

  • When to Use Excel Services

Who Should Attend

TOP

This course is intended for students who have experience working with Excel and would like to learn more about Pivot Tables.

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Request this course in a different delivery format.
Enroll