Maintenance Alert: Saturday, December 9th, 7:00am-5:00pm CT. During this time, the shopping cart and information requests will be unavailable.

Microsoft® Excel® Power Tools

Understanding and Using Excel Power Query and Power Pivot

Continuing Education Credits: CEU: 0.3 

Download Brochure

Half-Day Seminar

$149/Person

$139 for groups of 5 or more

Choose an Event

PRIVATE TEAM TRAINING

Bring this topic or 200+ other training opportunities to your location in-person or online.

Request Onsite Training

Already attended this seminar?

Rate and Get Certificates

View additional Computer Software training

"I have been a member of Fred Pryor for almost three years now and I have yet to attend a class that didn't have valuable information that would benefit my company and/or our employees."

— Teri M.

"Excellent!! As always, Fred Pryor's courses are easy to follow, very informative and presented in a format that keeps your attention!!"

— Cynthia S.

"I enjoy all of the seminars that I attend through the Fred Pryor Training Rewards program. They are very informative and the instructors are very knowledgeable and helpful."

— Tasha M.

"Excellent info for all levels of users. There are always things to add to your "bag of tricks"."

— Wendy S.

"Wow! I have taken many wonderful courses through Fred Pryor; this one takes the cake!!"

— Dana N.

"Top notch! Thank you Fred Pryor, this is the best investment my boss could have made."

— Lewis C.

"I received a lot of great information in this training. Several co-workers went with me which was a great help for me to start implementing some of the changes we need to do at the office. It was very eye opening for them to realize the things that we need to do at the office. It was very eye opening for them to realize the things that need to get to me. It was like Fred Pryor and the trainer had my back!"

— Tasha C.

Overview

For data crunchers using Microsoft Excel and Power BI, Excel Power Tools such as Power Query and Power Pivot are invaluable. Frequent users of VLOOKUP and PivotTables, won’t want to miss this 3.5-hour interactive learning session. Saving hours of work each week, Power Query connects data technologies allowing users to discover, combine and refine multiple data sources to meet analysis needs. Power Pivot uses its own language know as Data Analysis Expressions (DAX) to create sophisticated data models allowing complex calculations to be carried out across different tables of data with ease.

With Excel Power Query, data from different sources is cleaned, split and merged to new tables in Excel. Excel Power Pivot comes into play when the capabilities of regular Pivot tables in Excel are exhausted. With Power Pivot, users define how data in each table is related. Learn how Power Query and Power Pivot mastery can take the grunt work out of the daily grind and restore hours previously lost to rigorous data labor and analysis.

What You'll Learn

  • Understand the building blocks of a data model.
  • Determine the best practices for building a data model.
  • Gain insight on how to import data into the data model.
  • Review and understand complex relationships, hierarchies, aggregations and connections.
  • Master the four essential steps in building a Power Query.
  • Glean the knowledge to reshape your data to answer almost any question with Power Query.
  • Use the basics of Data Analysis Expressions (DAX) language for more complex calculations.
  • How calculations work in a Power Pivot and ways to adjust Power Pivots on the fly.
  • Methods for automating built-in Excel data cleanup tools.

Who Will Benefit

This course is for all Excel users, regardless of iOS or PC platform. A basic to intermediate knowledge of formulas and functions, charts, dashboards, PivotTables, Pivot Charts, Relational databases, sparklines and conditional formatting is recommended.