Microsoft Excel: Master M Language - Power Query in 60 Minutes!

Everything you need to master the M Language in Power Query!

What's Inside

Last time you opened a Power Query file with M Code and are overwhelmed by the number of things to do. You don't know how to make the best use of your time.

But it doesn't have to be this way!

You Will Walk Away With...

  • MORE TIME!
  • Create your own M Formulas to perform data transformations from scratch in just 60 minutes!
  • Understand the structure of the M code, and see them in action!
  • See how M in Power Query is used with real examples!

After this class you will be able to:

  • Actually SMILE when you open the Power Query Editor :-)
  • Brag to your friends about how you can use Microsoft Power Query confidently!

If you're like me, you use Microsoft Power Query on a daily basis for important tasks, text processing, or reports. Whether it's for business or personal related projects, everyone wants to be able to use Power Query freely and easily.

We take it up a notch to clean your dirty data and showcase the things you can do in Excel Power Query!

Here is what will we cover:

  • M Introduction
  • Enabling M in Power Query
  • Finding the complete list of M functions
  • Using M Functions with Real Examples
  • Simple Expressions
  • Nested Expressions
  • Variables
  • Functions
  • Reusable Functions
  • Invoking Functions
  • Passing Functions
  • Your Project

Course Curriculum

Get started now!



Certificate Available
1409+ Students
14 Lectures
0+ Hours of Video
Lifetime Access
24/7 Support
Instructor Rating
Bash (BizTech Matters)

Hi! I'm a book author of the 101 Excel Series paperback books and as you can see I love everything about Excel.

I'm also an IT Software Developer for more than 10 years and have the following certifications:

Microsoft Certified Professional Developer (MCPD): Web Developer

Microsoft Certified Technology Specialist (MCTS): Windows Applications

Microsoft Certified Systems Engineer (MCSE)

Microsoft Certified Systems Administrator (MCSA)

I focus on teaching in online courses and becoming a book author as I found my passion to reach out to students just like you. I have been teaching online courses for at least 5 years and counting.

Courses I'm focused on range from SQL, Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. My passion lies in helping my students in whatever means possible, whether it be reaching them via courses or by books.

Popular Bundles