Skip to main content
HomeBusiness Intelligence

Course

Intermediate Power Query in Excel

IntermediateSkill Level
4.7+
980 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 Preparation4 hr7 videos21 Exercises1,700 XP11,749Statement of Accomplishment

Create Your Free Account

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 2 or more people?

Try DataCamp 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 980 reviews
80%
17%
2%
0%
0%
  • Maryel
    11 hours ago

  • Mahaliah Keziah
    14 hours ago

  • Nattapat
    21 hours ago

  • Isna
    21 hours ago

  • Nicolas
    yesterday

  • Maciej
    yesterday

    Could do more with walking you step by step through the code

Maryel

Mahaliah Keziah

Nattapat

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

    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.