0
Item added to cart

Search For Courses

Shopping Cart

Your cart is empty.

Your Account

Login

Contact By Phone

877-442-3915



Contact By Email

Your Account

Login

Contact By Phone

877-442-3915



Contact By Email

Excel PowerPivot and Interactive Visualizations

$1495 | 3-Day Course

Take your Excel skills to the next level with interactive dashboards, KPIs, and map visualizations.

Course Overview

The Excel PowerPivot and Interactive Visualizations course introduces students to advanced analytics tools built into modern versions of Excel, enabling powerful data modeling, transformation, and visualization.

The class will cover the following topics:
  • Understanding and comparing PowerPivot, Power Query, Power View, and Power Map
  • Importing and shaping data from multiple sources using Power Query
  • Building relationships and hierarchies within a data model
  • Creating calculations and KPIs with DAX formulas
  • Visualizing data with Pivot Tables, Pivot Charts, and Power View
  • Developing interactive dashboards and map-based reports
  • Exploring time intelligence and multi-function DAX techniques

This class is ideal for Excel users working with complex reports or seeking to enhance their data analytics skills with integrated business intelligence tools.

Excel Training

TARGETED FOR: Financial Analyst | Data Analyst | Business Analyst

Learn from Professional Instructors and move forward in your field with industry-aligned Excel training.

+ Full Course Details

The new analytics tools in Excel make it easy to conduct, manipulate, and gain insights from big data. PowerPivot extends the use of PivotTables with a data model and offers improved data summarization and cross‑tabulation and advanced calculations. Power Query retrieves data from a variety of sources and can be cleaned up before being added to the data model. Power View creates interactive dashboards. Power Map is a 3D visualization tool to create map charts and interactive tours. These tools bring the power of advanced analytics to the average Excel user.

Target Student:
  • Individuals whose job responsibilities include complex Excel reports and advanced analytics
+ Course Delivery Format
Virtual Instructor-Led

All of our Public Classes are taught by a virtual live instructor. How it works is a live instructor conducts the class from a remote location regardless if you attend at one of the local training centers or if you attend remotely.

For of Private Group Training classes we can arrange to have the instructor conduct the class live at your location. Need Group Training?

+ What's Included

  • Professional Instructor Delivery - You will learn with our expert trainers with over 15 years of experience.
  • Free Course Materials - You will receive free reference materials for your class.
  • Small Class Sizes - Our classes are limited to 12 students, so you have plently of opportunity to ask questions and get feedback from the instructor.
  • Free Repeat - If you need a refresher your are able to retake the class free of charge within one year of your original class date.
  • Hands-On Training - Our classes are designed for you work hands on during the session so can stay engaged and really learn the material.
  • Certificate of Completion - Each student will receive a certificate of completion after completing the course.

+ Course Outline
Lesson 1 – Understanding Power Pivot and the Power BI Tools
  • What is Power Pivot, Power Query, Power View, and Power Map
  • Why use the Power BI Tools
  • Excel versus Power Pivot
  • Pivot Table Examples with Excel Data
  • Power Pivot Examples with a Data Model
  • Power View and Power Map Examples
Lesson 2 – Working with Data
  • Working with an Excel List
  • Using VLOOKUP to add Helper Columns
  • Working with an Excel Table
  • Cleaning up Tables
  • Working with Normalized Tables
Lesson 3 – Importing Data into Power Pivot
  • Understanding Acceptable Data Types
  • Adding Excel Tables to Power Pivot
  • Importing Access Tables
  • Saving the File
  • Adding and Maintaining Data in Power Pivot
Lesson 4 – Creating the Data Model
  • What is a Data Model
  • Understanding Key Fields
  • Creating Relationships between Tables in the Model
  • Managing Relationships
  • Create and Use Linked Tables
  • Create and Use Hierarchies
Lesson 5 – Using Calculations in Power Pivot
  • Types of Calculations in Power Pivot
  • Creating a Calculated Column
  • Creating a Calculated Field (Measures)
  • Implicit Calculated Field
  • Explicit Calculated Field
  • Understanding DAX Measure Rules and Best Practices
  • Choosing Between Calculated Columns and Measures
  • Creating a Key Performance Indicator (KPI)
Lesson 6 – Using Data Analysis Expressions
  • Understanding Data Analysis Expressions (DAX) Formulas
  • Where to use DAX formulas
  • Understanding the DAX syntax
  • How to create DAX formulas
  • Types of operations you can perform with DAX
Lesson 7 – Working with DAX Formulas
  • Working with Filter Function
  • Working with Time Intelligence Functions
  • Using Multiple Functions in a Formula
  • Using Multiple Data Tables
Lesson 8 – Data Analysis with Pivot Tables and Pivot Charts
  • Creating Pivot Tables
  • Filtering Data using Slicers
  • Add Visualizations to a Pivot Table
  • Creating Pivot Charts
  • Formatting Pivot Charts
  • Using Multiple Charts and Tables
Lesson 9 – Working with Power View
  • Visualizing Data with Power View
  • Creating a Basic Report
  • Making Improvements with Power View
  • Creating Tables and Matrices
  • Building Bar, Column, and Pie Charts
  • Constructing Line and Scatter Charts
  • Producing Map-Based Visualizations
Lesson 10 – Building Interactive Reports with Power View
  • Linking Visualizations in Power View
  • Using Tiles to Organize the Data
  • Filtering Groups and Views
  • Exposing the Dashboard
Lesson 11 – Loading and Transforming Data with Power Query
  • Importing Data
  • Transforming, Cleansing, and Filtering Data
  • Merging and Shaping Data
  • Grouping and Aggregating Data
  • Inserting Calculated Columns
Lesson 12 – Visualizing Data with Power Map
  • Preparing the Data for Mapping
  • Creating a Map-Based Graph
  • Creating Heat and Region Maps
  • Adding Multiple Layers to a Map
  • Analyzing Changes Over Time
  • Creating a Tour
+ Prerequisites
  • Excel Introduction or equivalent skills
  • Previous experience with PivotTables is helpful, but not required
+ Related Courses

Related Excel Instructor-Led Courses

Click Class Title for Dates and Details Days Course Fee
Excel Introduction1$299
Excel Charts, Formatting and Reporting1$299
Excel Workbooks, Formulas and Functions 1$299
Excel Database Features and PivotTables1$299
Excel Tips, Tricks and Timesavers1$299
Excel Power User2$795
Excel Macros1$395
Excel Programming with VBA3$1195
Excel Forecasting and What-If Analysis1$395

As part of our commitment to supporting learners at every stage, we’re working to develop a library of free Excel tutorials designed to help you tackle common tasks and workflows. We understand that not every situation calls for a full course, so these resources offer quick, practical guidance to help you get the job done efficiently.

Available Excel On-Demand Courses

Course Title (Click For Details) Course Fee
Excel for Mac$99
Microsoft Excel (365/2021)$99
Microsoft Excel (365/2019)$99
Microsoft Excel 2016$99

We have earned the trust of 15,481 customers, including these fine organizations:

United States Army Cisco United States Marine Corp HBO United States Air Force New York United States Navy Michigan Department of Homeland Security

Course Benefits

Certified Instructor Delivery

Learn with experienced professionally certified trainers that are subject matter experts.

Free Repeat

You have the option to retake this class one time within a year of your original class date.

Hands-On Training

Our courses are all designed for the students to have hands-on interaction throughout the course.

Local and Remote Options

Learn a local training center, or as a Remote Attendee from your home or office.

Offical Training Materials/Labs

We use Official Training Materials and Labs when available to ensure you have the most up to date training.

Convenient Scheduling

You are busy, we get it. Our classes are regularly scheduled to give you a number of convenience training options.

Financing Available

We offer affordable financing options for all of our courses to make sure cost is not a barrier to your progress.

Group Training Options

Have a team to train? We offer On-Site, Blended and Online Private Group Training services.

Boost Your Career

Getting professional training is one of the fastest ways to improve your skills and marketability.

Get Started Today!

Course Registration

Benefits of Virtual Live-Instructor Training Include:

  • Learn from Experts in Real Time
  • Hands-On Skill Development
  • Train Anywhere, Anytime
  • Boost Your Career Prospects
  • Conveniently Scheduled Sessions

Excel PowerPivot and Interactive Visualizations

SAVE 10% FOR A LIMITED TIME

$1495 / 3 Day Course



  • Professional Instructors
  • Official Course Materials
  • Small Class Sizes
  • Financing Available

Course Schedule

Course Title Dates Times Location Fee
Excel PowerPivot and Interactive Visualizations 1/12/2026 – 1/14/2026 10:00AM-4:45PM EST Local/Remote $1,495.00
Excel PowerPivot and Interactive Visualizations 2/2/2026 – 2/4/2026 10:00AM-4:45PM EST Local/Remote $1,495.00
Excel PowerPivot and Interactive Visualizations 3/9/2026 – 3/11/2026 10:00AM-4:45PM EST Local/Remote $1,495.00
Excel PowerPivot and Interactive Visualizations 3/30/2026 – 4/1/2026 10:00AM-4:45PM EST Local/Remote $1,495.00

Related Excel Instructor-Led Courses

Click Class Title for Dates and Details Days Course Fee
Excel Introduction1$299
Excel Charts, Formatting and Reporting1$299
Excel Workbooks, Formulas and Functions 1$299
Excel Database Features and PivotTables1$299
Excel Tips, Tricks and Timesavers1$299
Excel Power User2$795
Excel Macros1$395
Excel Programming with VBA3$1195
Excel Forecasting and What-If Analysis1$395

As part of our commitment to supporting learners at every stage, we’re working to develop a library of free Excel tutorials designed to help you tackle common tasks and workflows. We understand that not every situation calls for a full course, so these resources offer quick, practical guidance to help you get the job done efficiently.

Available Excel On-Demand Courses

Course Title (Click For Details) Course Fee
Excel for Mac$99
Microsoft Excel (365/2021)$99
Microsoft Excel (365/2019)$99
Microsoft Excel 2016$99
NEED GROUP TRAINING?

We Offer Live-Instructor Private Group Training

Benefits of Group Training Include:

  • Experienced Professional Instructor Trains Your Team
  • Content Focused On Your Team’s Needs
  • Convenient Scheduling and Class Setup
  • Significant Per/Student Cost Savings
  • Online, On-Site and Blended Options Available

Learn How Group Training Can Benefit Your Team

Request A Free Quote

Excel Certifications Available

Excel certifications are a powerful way to validate your Excel skills, and gain recognition as a trusted expert in the field. Whether you're an individual looking to boost your career or an organization investing in team development, our courses are designed to help you earn these industry-recognized credentials.

» View All Excel Certifications

Let us help you or your team get certified and stay competitive.

CompTIA A+ (Core 1 &amp; Core 2) &ndash; V15 – <strong>Exam Version</strong> <ul> <li>V15 (new series)</li> </ul>

Certification Overview CompTIA A+ (Core 1 &amp; Core 2) &ndash; V15 equips students with the practical skills required to install, configure, secure, and troubleshoot today&rsquo;s devices and operating systems in business environments.

Topics Include:

  • Exam Objectives &ndash
  • Detailed Breakdown
  • Core 1 (220&ndash
  • 1201) &ndash
  • Domain coverage and key skills:
  • 1.0 Mobile Devices (13%)
  • Monitor/replace mobile hardware components (battery, keyboard/keys, RAM, HDD/SSD, wireless cards, camera/webcam, microphone, Wi&ndash
  • Fi antenna)

Target Audience Aspiring IT Support Specialists &amp; Help Desk Technicians Field/Service Desk Technicians &amp; Desktop Support Staff Junior Systems/Network Support roles and Career Changers entering IT

learn more →
CompTIA A+ (Core 1 &amp; Core 2) &ndash; V15 – <strong>Exam Version</strong> <ul> <li>V15 (new series)</li> </ul>

Certification Overview CompTIA A+ (Core 1 &amp; Core 2) &ndash; V15 equips students with the practical skills required to install, configure, secure, and troubleshoot today&rsquo;s devices and operating systems in business environments.

Topics Include:

  • Exam Objectives &ndash
  • Detailed Breakdown
  • Core 1 (220&ndash
  • 1201) &ndash
  • Domain coverage and key skills:
  • 1.0 Mobile Devices (13%)
  • Monitor/replace mobile hardware components (battery, keyboard/keys, RAM, HDD/SSD, wireless cards, camera/webcam, microphone, Wi&ndash
  • Fi antenna)

Target Audience Aspiring IT Support Specialists &amp; Help Desk Technicians Field/Service Desk Technicians &amp; Desktop Support Staff Junior Systems/Network Support roles and Career Changers entering IT

learn more →
Autodesk Certified Professional (ACP) – AutoCAD

This certification is aimed at professionals who have advanced skills in AutoCAD and have experience working on more complex projects. It is typically recommended for those with around 400 hours of real-world experience.

Key areas covered:

  • Drawing objects, editing, and organizing objects
  • Advanced annotation techniques (hatch patterns, annotations)
  • Creating and managing reusable content (blocks, symbols)
  • Managing layouts and viewports
  • Output formats and publishing files
  • Working with external references (Xrefs) and data linking
  • Using AutoCAD’s productivity tools (parametric constraints, sheet sets)
learn more →
Autodesk Certified Expert (ACE) – AutoCAD (New)

Autodesk introduced an expert-level certification to cater to professionals who are highly skilled in AutoCAD and involved in more specialized, complex tasks like 3D modeling, parametric design, and custom workflows.

Key areas covered:

  • 3D modeling and design
  • Collaboration workflows with external data sets
  • Customizing AutoCAD using scripts and macros
  • Advanced rendering techniques
  • Interoperability with other Autodesk products

These certifications help individuals and professionals stand out in the job market by proving their expertise in AutoCAD to employers. Autodesk often updates its certification paths, so it’s always a good idea to check their official site or authorized training centers for the most current information.

learn more →

Flexible Excel Training Formats

Choose the training experience that fits your schedule, learning style, and professional goals. We offer flexible options for individuals and teams—whether you prefer virtual live instruction, on-demand access, or private group training.

Virtual Instructor-Led

Attend scheduled classes taught by expert instructors in real time. You can join remotely or from one of 250+ training center locations—for engaging, skill-based instruction with real-time support.

Learn More →

On Demand Training

Access pre-recorded Excel courses 24/7. Learn at your own pace with flexible, self-guided modules—ideal for busy professionals or those who prefer to study independently.

Learn More →

Private Group Training

Tailored Excel training for your organization—delivered either online or onsite. Designed to meet your team’s specific needs and schedule. Perfect for teams needing consistent, tailored instruction.

>Learn More →

Over 250 Locations Nationwide

Alabama
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
Tennessee
Texas
Utah
Virginia
Washington
Washington DC
Wisconsin

Client Reviews

Here’s what professionals and teams across the country are saying about their experience with Business Computer Skills

★★★★★
Rating 5.0 / 5.0

This was the class I needed. The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don’t know about the rest of the students, but was very pleased with this experience.

Amanda T.,
Yale New Haven Hospital

★★★★★
5 / 5