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

Bryan Hong, Online Teaching Excel Expert

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
15 Lessons (58m)
    • 1. Welcome to the M Language Course!

      0:31
    • 2. Excel M Language - Introduction

      2:41
    • 3. Enabling M in Excel Power Query

      2:18
    • 4. Finding the list of M functions

      2:28
    • 5. Using M Functions

      9:58
    • 6. Simple Expressions

      7:35
    • 7. Simple Expressions - Nested Expressions

      2:54
    • 8. Variables

      7:59
    • 9. Functions

      6:05
    • 10. Functions - Reusable Functions

      2:12
    • 11. Functions - Invoking

      0:35
    • 12. Functions - Passing Functions

      8:11
    • 13. Functions - The Keyword Each

      2:40
    • 14. Your Project

      1:07
    • 15. Thank You!

      1:07

About This Class

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!

66f08c79

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