microsoft partner logo color
8379  Reviews star_rate star_rate star_rate star_rate star_half

Advanced Excel Power Query

This Advanced Excel Power Query training course takes your team's data-wrangling skills to the next level. Participants learn powerful techniques for cleaning, shaping, and analyzing data from...

Read More
By Request
Contact Us For Pricing
Duration 1 day
Course Code OFC-107
Available Formats Classroom

Overview

This Advanced Excel Power Query training course takes your team's data-wrangling skills to the next level. Participants learn powerful techniques for cleaning, shaping, and analyzing data from diverse sources. In addition, students learn how to refine their workflows with advanced querying, custom functions, and M code mastery.

Skills Gained

  • Master complex data transformations and manipulations
  • Craft advanced formulas to unlock deeper insights
  • Leverage powerful functions and custom parameters
  • Extract and transform data from any source, including PDFs
  • Use M code for data control
  • Optimize workflows for efficiency and accuracy

Prerequisites

It is recommended that all participants take Ascendient Learning's Introductory Excel Power Query course.  This course is intended for advanced Excel users.

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

  • Review of Power Query Concepts
    • Using the QAT in Power Query
    • Extracting and Transforming Data
    • Using Split, Merge Columns, Extract and Columns from Example
    • Using Append, Merge, and Import from Folder
    • Using Grouping Options
    • Organizing and Managing Steps
  • Power Query Options
    • Setting Query Options
    • Data Source Settings
    • Using View Options
  • Using Power Query Advanced Features
    • Creating and Using Parameters
    • Using Convert to List
    • Using Enter Data
  • Extracting & Transforming More Complex Data
    • Extracting and Transforming PDF Files
    • Extracting from Online Sources
    • Transforming Complex Data
  • Creating Advanced Formulas in Power Query
    • Creating IF statements
    • Using Date Functions
    • Using Other Functions
  • Understanding M Code
    • Viewing M Code
    • Editing M Code
    • Writing M Code
    • Common M Code Functions
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

Instructor, Training material & span of the training is neatly planned.

The class and material is good. I think some of the software needs to be updated.

Although there seemed to be too many links for the course, everything worked smoothly.

The instructor was thorough and they also provided hands-on demonstrations with labs.

Easy to use and exactly what I was looking for. Value for money was exceptional.