microsoft partner logo color
8340  Reviews star_rate star_rate star_rate star_rate star_half

Excel Power Query

This Excel Power Query training course teaches attendees how to set up Excel for automation and use Power Query and Power Pivot to create pivot tables, reports, and other visualizations. Participants...

Read More
By Request
$875 USD
Duration 2 days
Course Code OFC-106
Available Formats Classroom

Overview

This Excel Power Query training course teaches attendees how to set up Excel for automation and use Power Query and Power Pivot to create pivot tables, reports, and other visualizations. Participants learn how to use the new advanced features of Excel and extract different types of data, clean up the data, and load the clean data into Excel. This class is appropriate for Excel 2016, 2019, Online, and later.

Skills Gained

  • Extract and transform data from a variety of sources using Power Query
  • Clean and shape Power Query data
  • Merge and append Power Query data from multiple sources
  • Create formulas in Power Query to calculate new values or transform existing data
  • Use Power Query data to create pivot tables, reports, and other visualizations

Prerequisites

This course is best suited for intermediate to advanced Excel users who regularly receive data sets that they must clean up and create reports in Excel.

Course Details

Training Materials

  • All Excel Power Query training attendees receive a course workbook.

Software Requirements

  • Excel installed from Microsoft Office Professional Plus or Microsoft 365
  • Related lab files that Ascendient Learning will provide

Outline

Introduction

Advanced Excel

  • Set up Excel for Automation
  • Excel Tips and Tricks
  • New Advanced Excel Features

Power Query

  • Extracting and Transforming Data
  • Working with Power Query Data

Editing & Refreshing Queries

  • Editing Queries
  • Refreshing the Data

Appending & Merging Data

  • Appending Files
  • Hiding Queries
  • Combining Data from Folder
  • Merging Files

Creating Formulas in Power Query

  • Using Custom Column Button
  • Using Standard Functions
  • Renaming Steps
  • Editing Formulas

Using Power Query Data

  • Creating Pivot Tables
  • Sharing Files with Queries

Using Power Pivot

  • Introduction to Power Pivot
  • Loading Data into the Data Model
  • Creating Relationships
  • Using Related Data in Pivot Tables

Conclusion

Read Less

Schedule

Upcoming Course Dates

There are currently no scheduled dates for this course. If you are interested in this course, contact us with the form below.

Contact Information

FAQ

How do I get a Microsoft exam voucher?

Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.

  • Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
  • Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.

Do Microsoft courses come with post lab access?

Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour-long after 3-3.5 hours of the class day.

What languages are used to deliver training?

Microsoft courses are conducted in English unless otherwise specified.

Reviews

Brandon was a great instructor. The virtual course materials and labs provided were very informative.

Course was great and the instructor had an answer for anything that was asked during the course.

ExitCertified was a great. They gave me all the materials and information I needed ahead of time to prepare for the course.

Quick to sign-up to course, and was able to garner some information from the course.

Good Course. We covered a lot of material in a short amount of time. This course had useful labs that built upon each other.