Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
edupls_header
certification
Filter by Categories
Start DateEnd DateClass Times (EST)Delivery/Location ?StatusPriceEnroll Now
6/2/20256/2/20251:30 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$133.00
6/17/20256/17/20259:00 AM - 12:30 PM35 Guaranteed-to-Run (GTR)$133.00
6/30/20256/30/20251:30 AM - 5:00 PM35 Guaranteed-to-Run (GTR)$133.00
7/22/20257/22/20259:00 AM - 12:30 PM35 Guaranteed-to-Run (GTR)$133.00
8/8/20258/8/20259:00 AM - 12:30 PM35 Guaranteed-to-Run (GTR)$133.00
8/27/20258/27/20259:00 AM - 12:30 PM35 Guaranteed-to-Run (GTR)$133.00
9/18/20259/18/20259:00 AM - 12:30 PM35 Guaranteed-to-Run (GTR)$133.00
10/9/202510/9/20259:00 AM - 12:30 PM35 Guaranteed-to-Run (GTR)$133.00
10/31/202510/31/20259:00 AM - 12:30 PM35 Guaranteed-to-Run (GTR)$133.00
11/24/202511/24/20259:00 AM - 12:30 PM35 Guaranteed-to-Run (GTR)$133.00
12/16/202512/16/20259:00 AM - 12:30 PM35 Guaranteed-to-Run (GTR)$133.00
6/2/2025 - 6/2/2025
1:30 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$133.00
6/17/2025 - 6/17/2025
9:00 AM - 12:30 PM
35
Guaranteed-to-Run (GTR)
$133.00
6/30/2025 - 6/30/2025
1:30 AM - 5:00 PM
35
Guaranteed-to-Run (GTR)
$133.00
7/22/2025 - 7/22/2025
9:00 AM - 12:30 PM
35
Guaranteed-to-Run (GTR)
$133.00
8/8/2025 - 8/8/2025
9:00 AM - 12:30 PM
35
Guaranteed-to-Run (GTR)
$133.00
8/27/2025 - 8/27/2025
9:00 AM - 12:30 PM
35
Guaranteed-to-Run (GTR)
$133.00
9/18/2025 - 9/18/2025
9:00 AM - 12:30 PM
35
Guaranteed-to-Run (GTR)
$133.00
10/9/2025 - 10/9/2025
9:00 AM - 12:30 PM
35
Guaranteed-to-Run (GTR)
$133.00
10/31/2025 - 10/31/2025
9:00 AM - 12:30 PM
35
Guaranteed-to-Run (GTR)
$133.00
11/24/2025 - 11/24/2025
9:00 AM - 12:30 PM
35
Guaranteed-to-Run (GTR)
$133.00
12/16/2025 - 12/16/2025
9:00 AM - 12:30 PM
35
Guaranteed-to-Run (GTR)
$133.00

Train your entire team with our Private Group Training solutions. AstraTech 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 Private Group Training from AstraTech!

    On-Demand Learning (ODL) is a self-paced training solution designed to work around your individual schedule, budget, and learning needs. Our ODL courses provide you with exclusive access to interactive platforms combining high-quality instructor videos from subject matter experts, official courseware and study materials, hands-on labs, practice exercises, skill assessments and knowledge checks. The modular, self-paced ODL course structure adapts to your unique learning needs and style, providing an optimal training experience.

    Train your entire team with our Private Group Training solutions. AstraTech 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 Private Group Training from AstraTech!

    Excel – Data Analysis with PivotTables

    $148 | 0.5

    Upgrade your tech skills with this , training course. Launch your career to the stars with AstraTech IT Certification Training!

    Please select a Learning Method below to get started:

    • Microsoft Apps
    • Microsoft Excel

    About this Course

    SKILL LEVEL: 
    • Intermediate

    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.

    0

    Excel – Part 1 & Part 2 or equivalent experience.

    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.

    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