Search 888-330-6890 Login/Create Account
888-330-6890

Registration - Microsoft Power BI Desktop and Microsoft Power Query
This event is now closed. - Certstaffix Training


Event Date: 12/16/2022
10:00 AM - 5:00 PM Daily (Eastern Time)

Held Live Online via Zoom

Registration Deadline - 11/30/2022

No fees available

Event Overview

This course familiarizes the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel. The course uses Excel 2016, however Power Query works with Excel 2010 and above.

After completing this course, students will be able to:

  • Understand the revolutionary changes in Power Query and the ease it provides for Excel pros.
  • Successfully navigate the Power Query interface.
  • Understand and properly configure data types.
  • Understand and perform importing data.
  • Understand and perform transforming data.
  • Understand and perform loading data.
  • Understand and utilize ranges in Excel.
  • Understand and handle special situations.
  • Understand and perform appending operations.
  • Understand and utilize working with folders and files.
  • Understand and perform combining worksheets.
  • Understand and utilize PivotTables.
  • Understand working with relational data.
  • Understand and perform importing from SQL Server Analysis Services Multidimensional.
  • Understand and perform importing from SQL Server Analysis Services Tabular.
  • Understand the issues encountered when performing merges.
  • Understand and utilize merges.
  • Understand and utilize loading into Excel.
  • Understand and utilize loading into Power Pivot.
  • Understand and utilize loading to Power BI Desktop.
  • Understand and utilize the data sources available.
  • Understand and utilize grouping.
  • Understand and utilize summarizing.
  • Understand the M interface.
  • Understand Power Query formulas.

Course Features:

Live Instructor Teaching

Certificate of Completion

Courseware: Print

Free 6 Month Online Retake

Hands-On Learning?: Yes

Software Lab Included?: Yes


Learn From an Instructor Live Online

Certstaffix Training public classes are taught by live instructors to you in the comfort of your home or work. Attend our live online, instructor-led classes from the convenience of your location and avoid travel.

How It Works

When you attend our public live online classes, Certstaffix Training provides any required software in a web browser (during class) and ships any courseware (if applicable) directly to you prior to class start.


  • A live instructor teaching you online via Zoom
  • Hands-on learning with the software or skill you are being taught
  • Interaction with all students in the class
  • Any needed software for class provided in online lab
    (if applicable; may require creation of a free trial account)
  • Easy Q&A. Classes are kept small to have time for student questions

Have more than 10 students needing this course? Contact Us for bulk pricing.


Start your training today!

Search Courses