Microsoft

Microsoft Excel PivotTables EXL-P

Not sure this is the right class? Read What Microsoft Excel Class Should I Take?

  • 1 day
  • 5 upcoming dates 5 open for booking
  • $185 per seat

Upcoming dates

Dates Where Status Seat Book
Nov 9 2026 Live Online 9:00 AM to 12:00 PM PT Confirmed to run $185
Nov 23 2026 Live Online 6:00 AM to 9:30 AM PT Confirmed to run Partner led $185
Dec 7 2026 Live Online 9:00 AM to 12:00 PM PT Confirmed to run $185
Dec 16 2026 Live Online 6:00 AM to 9:30 AM PT Confirmed to run Partner led $185
Dec 28 2026 Live Online 6:00 AM to 9:30 AM PT Confirmed to run Partner led $185

See every class on the schedule

About this class

Upon successful completion of this 3 hour instructor-led course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data.

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But, Excel is capable of doing so much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.

Features and functions in Office 365 and Office 2019 / 2016 are nearly identical. For this reason, users for all versions (365, 2019, 2016 and 2013) attend the same class. The instructor will explain the few visual differences in the versions to you; just let the instructor know what version you are using.

What you'll be able to do

  • Prepare data for PivotTable reporting
  • Create PivotTables from various data sources
  • Analyze data using PivotTables
  • Build PivotTable charts

Before you attend

To ensure your success, we recommend you first take the following courses or have equivalent knowledge:

  • Microsoft Excel Level 1
  • Microsoft Excel Level 2

Course outline

  1. Module 1Building a PivotTable

    • Inserting a PivotTable
    • Categorizing PivotTable data
    • Filtering PivotTable data
    • Using slicers

  2. Module 2Analyzing Data Using PivotTables

    • Create custom calculations in PivotTable
    • Restructuring and formatting a PivotTable
    • Updating PivotTable information
    • Viewing PivotTable summary details

  3. Module 3Presenting PivotTable Data Visually

    • Present a PivotTable in a PivotChart
    • Printing PivotTables and PivotCharts

  4. Module 4Creating PivotTables from Other Sources

    • Creating a PivotTable based on external data
    • Building a PivotTable from multiple data sources

Download the full outline (PDF)

Run this for a team

Private cohorts run on your dates, at your site or online, with the labs pointed at your environment. Above about four people it usually costs less than buying seats.

Or call 916-920-1700, weekdays 8 to 5 Pacific.

More desktop applications classes

See all