Excel – Data Analysis with PivotTables

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.

Course Details

Price:

$148.00

Days:

0.5

Location:

Virtual

Course Overview

Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will: Prepare data for PivotTable reporting and create PivotTables from various data sources. Analyze Data Using PivotTables. Work with PivotCharts.

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

Class Dates & Times


06/17/2025 Virtual 09:00:00 to 12:30:00 EST Enroll Now $148.00
06/30/2025 Virtual 13:30:00 to 17:00:00 EST Enroll Now $148.00
07/22/2025 Virtual 09:00:00 to 12:30:00 EST Enroll Now $148.00
08/08/2025 Virtual 09:00:00 to 12:30:00 EST Enroll Now $148.00
08/27/2025 Virtual 09:00:00 to 12:30:00 EST Enroll Now $148.00
09/18/2025 Virtual 09:00:00 to 12:30:00 EST Enroll Now $148.00
10/09/2025 Virtual 09:00:00 to 12:30:00 EST Enroll Now $148.00
10/31/2025 Virtual 09:00:00 to 12:30:00 EST Enroll Now $148.00
11/24/2025 Virtual 09:00:00 to 12:30:00 EST Enroll Now $148.00
12/16/2025 Virtual 09:00:00 to 12:30:00 EST Enroll Now $148.00

— Questions?

Information Request

— Empower Change

Invest in Skills & Equality

Support Diversity, Equity, and Inclusion with Every Purchase.

Great Horizons is a North Carolina Certified HUB Vendor and WOSB. By becoming a patron of our organization, you are not only supporting a historically underutilized business, but a woman-owned small business as well.

Student? Switch to our Career Center Site →