Microsoft Excel: Data Analysis with PivotTables

May 1, 2026 @ 1:00pm to 4:30pm
man looking at Excel spreadsheet dashboard on a laptop
Instructor: Brandon Mack
Delivery: On-site @ Client Facility
Length: 0.5 Day
Difficulty: Advanced

This is a private booking

Registration Closed

Course Overview

Advances in technology have made it possible to store ever-increasing amounts of data. Along with this, the need to analyze data and gain actionable insight is greater than ever. You already have experience working with Microsoft® Excel® and creating basic PivotTables to summarize data. But Excel is capable of doing 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.

Prerequisites

You should have basic knowledge of Windows including opening applications and opening files from File Explorer. You should have a working knowledge of all topics covered in Excel Novice and Excel Intermediate.

What You Will Learn

  • 01
    Preparing Data and 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
  • 02
    Analyzing Data by Using PivotTables
  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change PivotTable Data
  • 03
    Working with PivotCharts
  • Create a PivotChart
  • Manipulate PivotChart Data
  • Format a PivotChart

Included With The Course

  • Professional textbook (physical and digital)
  • Unused copy of any files referenced throughout the textbook.
  • Certificate of completion signed by the instructor.

Associated Certifications

Not applicable.

Frequently Asked Questions

We understand that you may have questions, and we’re here to help! Some of the most commonly asked questions about this course are covered below but if they don’t cover what you are looking for feel free to reach out to us through our contact page, and we’ll respond promptly to ensure you get the assistance you require. Your satisfaction is our priority, and we’re committed to making sure you have all the information necessary for a seamless experience.

This course assumes that you have a Microsoft 365 Business subscription. If you are using a home version, please be aware that there may be discrepancies between the features demonstrated in the course and those available in your version.

You can review the different subscription plans by clicking here.