Loading...
Skip to Main Content

Course Details

Time: 9AM - 4PM Eastern Time (ET)
Duration: 1 Day

Description:

A pivot table doesn’t actually change the spreadsheet or database table itself, but instead allows the user to quickly reorganize and manipulate the data, and create a summary to accomplish analysis tasks.

Prerequisites:

None

Microsoft Excel

Public Class Schedule

Location Language Date Price Register
Web-based(Opens in new window) English April 13 $495.00
Web-based(Opens in new window) English May 10 $495.00
Web-based(Opens in new window) English June 7 $495.00
Web-based(Opens in new window) English July 8 $495.00
Web-based(Opens in new window) English August 16 $495.00
Web-based(Opens in new window) English September 20 $495.00
Web-based(Opens in new window) English October 13 $495.00
Web-based(Opens in new window) English November 8 $495.00
Web-based(Opens in new window) English December 6 $495.00

We're Here to Help

Don't see the dates you need? Call us at 888.484.2933 or Tell Us What You Need.

Course Outline

  • Pivot Table Fundamentals
    • Create a pivot table
    • Add/Remove pivot table Fields
    • Rearrange the layout of pivot table
    • Rename a field
    • Add a new field
    • Work with value areas
    • Reveal the source data
  • Summarize Data
    • Use functions to summarize values
    • Display values as percentages
    • Compare totals and base value
    • Show running totals
    • Change the sort order
    • Show the ranking values
    • Changing the analysis function
  • Filters and Slicers
    • Filter data using the report filter
    • Filter data using the pivot table filters
    • Organize the pivot table through the use of slicers
  • Design the Pivot Table
    • Styling the pivot table
    • Display sub-totals in different positions
    • Remove Grand Totals 
    • Tabular view
    • Outline view
    • Formatting numbers in the data area
  • Group Data
    • Creating custom groups
    • Group data by date
    • Group data by range
  • Work with Multiple Tables
    • Create and manage table relationships
  • Consolidation Ranges
    • Consolidate data using a pivot table
    • Work with consolidated data
  • Pivot Table Calculations
    • Create calculated items and fields
    • Work the calculated Items and fields
    • Understanding the GetPivotData Function
  • Pivot Charts
    • Create and format a pivot chart report
    • Work with pivot chart report  data
  • Dashboard
    • Understanding Dashboard
    • Create a dashboard

Private training is available for this course.

Call us at 1-888-484-2933 to learn more about our flexible scheduling options or complete our Information Request Form.

Web-based training is super easy to set up and doesn’t require fancy software.

Find a Course