Excel Power Tools: Power Query and Power Pivot

Training overview
Professional Course
3 hours

Course description

Excel Power Tools: Power Query and Power Pivot

Accelerate your spreadsheet data analysisproficiency. 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, youll 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, we recommend Excel 2016 and later. Windows platform preferred.

Want to find out more?

Training content

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

Certification / Credits

  • Build advanced PivotTables with calculated items and fields
  • Combine separate sheets into one report with the PivotTable PivotChart Wizard
  • Automate repetitive importing and data cleansing tasks instead of writing complicated VBA macros
  • Merge multiple data sets into a single report using Power Query
  • Import data into a Power Pivot data model
  • Create and edit relationships between two data tables in Power Pivot

About SkillPath


SkillPath is a leader in business training with more than 30 years of experience. Our professional training programs prioritize learner engagement — helping theory take root with learners, so it transforms their thinking and becomes day-to-day practice. SkillPath’s courses are...

Read more and show all training delivered by this supplier

Contact this provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.

Country *

Contact info


6900 Squibb Road
66202 Mission Kansas

Learn more!

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.

View again
Supplier Directory
Join our Supplier Directory to:
- Gain Traffic
- Get Noticed
- Showcase Your Services
- Free Listing Available