Skip to Main Content

Microsoft Excel Dashboard and PivotTable Workshop  (MO16EX901)

Before attending this course, the participant must have a basic introduction to Pivot Tables or a mandatory intermediate working knowledge of Microsoft Excel.

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

Compatible with 2013

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:

MO16EX301—Microsoft Excel 2016 - Part Three or equivalent knowledge or experience is mandatory.

Public Class Schedule

Location Language Date Price Register
Ottawa English November 20 $ 225.00 (15% OFF)
$ 265.00
Web-based(Opens in new window) English November 20 $ 225.00 (15% OFF)
$ 265.00
Ottawa English January 13 $ 225.00 (15% OFF)
$ 265.00
Web-based(Opens in new window) English January 13 $ 225.00 (15% OFF)
$ 265.00
Ottawa English February 18 $ 225.00 (15% OFF)
$ 265.00
Web-based(Opens in new window) English February 18 $ 225.00 (15% OFF)
$ 265.00
Ottawa English March 16 $ 225.00 (15% OFF)
$ 265.00
Web-based(Opens in new window) English March 16 $ 225.00 (15% OFF)
$ 265.00
Ottawa English April 15 $ 225.00 (15% OFF)
$ 265.00
Web-based(Opens in new window) English April 15 $ 225.00 (15% OFF)
$ 265.00
Ottawa English May 11 $ 225.00 (15% OFF)
$ 265.00
Web-based(Opens in new window) English May 11 $ 225.00 (15% OFF)
$ 265.00
Ottawa English June 8 $ 225.00 (15% OFF)
$ 265.00
Web-based(Opens in new window) English June 8 $ 225.00 (15% OFF)
$ 265.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.

© 2019 Eliquo, Inc. All rights reserved.

Back to Top