Excel Power Tools: Power Query and Power Pivot

Course Description

Overview

Accelerate your spreadsheet data analysis proficiency. This LIVE, virtual, hands-on data management course provides the essential 21st century Microsoft Excel training you need to get ahead. It goes beyond the fundamentals of PivotTables to explore more advanced topics, such as calculated fields, calculated items and conditional formatting. Then it brings you up-to-date and up-to-speed with Excel for Office 365 Power Tools, including Power Query and Power Pivot.

With Excel Power Tools, you’ll be equipped to analyze an unlimited amount of data, combine multiple data sources into a single report, analyze data across multiple tables and create more sophisticated calculations.

For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred.

WORKSHOP AGENDA

Program time: 3 hours

Session 1: Building Advanced PivotTables With Calculated Items and Fields

Look at PivotTable fundamentals, then push the limits of built-in pivots by customizing them with calculated items, calculated fields and conditional formatting.

Review Excel® building blocks

Know how to create calculated items and calculated fields

Understand how to conditionally format PivotTable fields

Describe how to consolidate multiple ranges into a single report (without Power Query)

Session 2: Power Query Including the M language

Learn how Power Query helps you automate the process of importing, transforming and cleansing your data. Building an effective Power Query that can be used over and over on new datasets will save hours of effort and make you a more effective analyst.

Discuss the fundamentals of Power Query (Get & Transform)

Explain how to use Power Query to clean up data before you load it

Extract and organize data from many sources

Understand how to merge queries

Session 3: Introduction to Power Pivot — Gathering Data

Business analysts use Power Query to prepare data, then they use Power Pivot to build reports. Power Pivot is an Excel Add-in used to analyze huge amount of data from multiple sources. Power Pivot has a different calculation engine from Excel which makes data analysis faster.

Discuss the basics of Power Pivot

Import data into your model

Link dimension tables and fact tables

Build reports

Course: Excel Power Tools: Power Query and Power Pivot

$199.00

View All Dates

Looking for Group eLearning Options?

Get your team access to 4,000+ top courses anytime, anywhere.

Request On-Site Training

Upcoming Dates

Location: , Virtual Live
Date & Time: Apr 10, 2025 01:00 PM CST

$199.00

Location: , Virtual Live
Date & Time: Apr 10, 2025 09:00 AM CST

$199.00

Location: , Virtual Live
Date & Time: Apr 24, 2025 09:00 AM CST

$199.00

View All (4)

Location	Date & Time	Duration	Course Type CL Classroom Live - Traditional live classroom with in-person instructor. CV Classroom Virtual - Attend this live instructor-led event remotely from the indicated tech facility. VL Virtual Live - Attend this live instructor-led event remotely from anywhere.	Price

Show Events

Cancelation Policy

If you cannot attend an event, you may send someone else in your place. If that isn’t an option for you, cancellations received up to five working days before the event are refundable, minus a registration service charge ($10 for one-day events; $25 for multiple-day events). After that, cancellations are subject to the entire seminar fee, which you may apply toward a future seminar. Please note that if you don’t cancel and don’t attend, you are still responsible for payment.