A laptop screen with Microsoft Excel tables and graphs being manipulated by a business person.

Instructor-Led Training

Excel Power Tools: Power Query and Power Pivot

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.

Course Outcomes

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

Course Agenda

Instructor-Led Training

Print Agenda

Session 1: Building Advanced PivotTables With Calculated Items and Fields

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

Request group training

Complete the form below to request tailored, private training for your team. We’ll be in touch to discuss your group’s specific goals.

More Courses in

Instructor-Led Training Business & Technology

Related Courses