Skip to main content
HomeBusiness Intelligence

Course

Intermediate Power Query in Excel

IntermediateSkill Level
4.7+
1,057 reviews
Updated 05/2026
Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery
Start Course for Free
ExcelData Preparation
4 hr
7 videos
21 Exercises
1,700 XP
12,422
Statement of Accomplishment

Create Your Free Account

Continue with GoogleShow more options

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Group

Training a Team?

Try for Business

Course Description

Building on your foundational Power Query in Excel knowledge, this intermediate course takes you to the next level of data transformation mastery. Discover advanced data integration techniques, including appending and merging datasets with various join types. Delve into M language syntax for creating custom conditional columns and harness advanced table transformations. Unlock the Power Query Advanced Editor, exploring M's built-in functions, mastering best practices like query grouping, and dynamically adjusting filter criteria with parameters. Elevate your skills by crafting custom M formula language functions, unleashing advanced query design capabilities that will empower you to extract deeper insights from your data.

Prerequisites

Introduction to Power Query in ExcelData Preparation in ExcelData Analysis in Excel
1

Combining Queries in Power Query

In this chapter, you’ll delve into Power Query's data integration capabilities. You’ll master the art of appending queries to combine datasets seamlessly. You’ll also learn to merge datasets together, harnessing various join types to render datasets in multiple ways.
Start Chapter
2

Custom columns

It’s all about customization in this chapter. You’ll learn the fundamentals of M language syntax, and how it underpins every transformation step in query development. You’ll leverage M to create custom conditional columns using logical operators to suit numerous scenarios. You’ll also delve into M table transformation expressions to create custom grouped index columns, enhancing your proficiency in advanced query design.
Start Chapter
3

M Formula Language

In this final chapter, you’ll delve into the Power Query Advanced Editor, unraveling M-Language syntax for code modification and debugging. You’ll explore M's built-in functions, and master best practices such as query grouping and dynamic filtering with parameters. Lastly, you’ll elevate your skills by crafting custom M formula language functions, unlocking advanced query design capabilities
Start Chapter
Intermediate Power Query in Excel
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.7
from 1,057 reviews
80%
17%
3%
0%
0%
  • Juan
    4 hours ago

  • Steve
    yesterday

    I found this section quite challenging, especially as I completed it over several days and often had to remind myself how to navigate Power Query and work with M code. The concepts were enjoyable but required careful attention, particularly when creating custom functions, parameters, and grouped transformations. I would recommend that learners make sure they are confident with the core Power Query skills and comfortable with the basic techniques before moving on to more advanced steps like custom columns and function editing. Overall challenging but satisfying.

  • omar
    yesterday

  • Mariyana
    yesterday

  • Nicholas
    4 days ago

  • Karl
    5 days ago

Juan

omar

Mariyana

FAQs

What prior Power Query experience do I need?

You should complete Introduction to Power Query in Excel and foundational Excel courses first. This course builds on basic query editing and transformation skills.

What is the M language and how is it used in this course?

M is Power Query's formula language. You will write M syntax for custom conditional columns, explore built-in functions, and create custom M functions.

What data integration techniques does this course cover?

You will learn to append queries to combine datasets, merge datasets using various join types, and use parameters to dynamically adjust filter criteria.

Will I use the Power Query Advanced Editor?

Yes. You will unlock the Advanced Editor to write and edit M code directly, master best practices like query grouping, and build advanced query designs.

How long does this course take?

The course has 3 chapters and 22 exercises. Most learners complete it in about 2.5 to 3 hours.

    Join over 19 million learners and start Intermediate Power Query in Excel today!

    Create Your Free Account

    Continue with GoogleShow more options

    or

    By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

    Grow your data skills with DataCamp for Mobile

    Make progress on the go with our mobile courses and daily 5-minute coding challenges.

    Download on the App StoreGet it on Google Play