Excel – Data Analysis With PivotTables training course
Instructor‑Led:$140 | Duration: 0.5
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.
Reserve your seat in an upcoming class date or select a Learning Method below:
Start Date
End Date
CLASS TIMES (EST)
DELIVERY/LOCATION
Status
Price
Enroll Now
5/28/2026
5/28/2026
9:00AM - 12:30PM
GTR
Guaranteed-to-Run
$140.00
6/29/2026
6/29/2026
9:00AM - 12:30PM
GTR
Guaranteed-to-Run
$140.00
7/17/2026
7/17/2026
9:00AM - 12:30PM
GTR
Guaranteed-to-Run
$140.00
8/20/2026
8/20/2026
9:00AM - 12:30PM
GTR
Guaranteed-to-Run
$140.00
9/4/2026
9/4/2026
9:00AM - 12:30PM
GTR
Guaranteed-to-Run
$140.00
9/18/2026
9/18/2026
9:00AM - 12:30PM
GTR
Guaranteed-to-Run
$140.00
START DATE : 5/28/2026
END DATE : 5/28/2026
CLASS TIMES (EST) : 9:00AM - 12:30PM
DELIVERY/LOCATION :
STATUS :
GTR
Guaranteed-to-Run
PRICE : $140.00
START DATE : 6/29/2026
END DATE : 6/29/2026
CLASS TIMES (EST) : 9:00AM - 12:30PM
DELIVERY/LOCATION :
STATUS :
GTR
Guaranteed-to-Run
PRICE : $140.00
START DATE : 7/17/2026
END DATE : 7/17/2026
CLASS TIMES (EST) : 9:00AM - 12:30PM
DELIVERY/LOCATION :
STATUS :
GTR
Guaranteed-to-Run
PRICE : $140.00
START DATE : 8/20/2026
END DATE : 8/20/2026
CLASS TIMES (EST) : 9:00AM - 12:30PM
DELIVERY/LOCATION :
STATUS :
GTR
Guaranteed-to-Run
PRICE : $140.00
START DATE : 9/4/2026
END DATE : 9/4/2026
CLASS TIMES (EST) : 9:00AM - 12:30PM
DELIVERY/LOCATION :
STATUS :
GTR
Guaranteed-to-Run
PRICE : $140.00
START DATE : 9/18/2026
END DATE : 9/18/2026
CLASS TIMES (EST) : 9:00AM - 12:30PM
DELIVERY/LOCATION :
STATUS :
GTR
Guaranteed-to-Run
PRICE : $140.00
Train your entire team with our Private Group Training solutions. TechSherpas 365 specializes in creating customized training programs to fit your organization’s unique learning needs and business objectives. Take advantage of multiple student discounts, customized curriculum and flexible scheduling with TechSherpas 365's Private Group Training solutions!
Complete the form below to request more info and/or a Private Group Training quote:
Excel – Data Analysis With PivotTables Course Outline
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.
PREREQUISITES
Excel — Part 1 & Part 2 or equivalent experience.
1 — Preparing Data & Creating PivotTables
Prepare Data
Create a PivotTable from a Local Data Source
Create a PivotTable from Multiple Local Data Sources
Create a PivotTable from an External Data Source
2 — Analyzing Data Using PivotTables
Summarize PivotTable Data
Organize PivotTable Data
Filter PivotTable Data
Format a PivotTable
Refresh and Change PivotTable Data
3 — Working with PivotCharts
Create a PivotChart
Manipulate PivotChart Data
Format a PivotChart
Related Job Roles
This course builds skills and demonstrates qualifications for the job roles and average base salaries below.Â
Excel provides Power Pivot to help students organize, manipulate, and report on their data in the best way possible. In this course, students gain a solid understanding of Power Pivot…Read more.
Dive deep into the world of Microsoft Copilot and how it can maximize your efficiency when using Microsoft Excel. Participants will delve into the advanced features of Microsoft Copilot, learning…Read more.
VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft Office application suite. You can use VBA to…Read more.
VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft Excel and other applications in the Microsoft 365 application suite. You can use VBA to…Read more.
GTR 
