1
00:00:00,000 --> 00:00:00,133


2
00:00:00,133 --> 00:00:06,233
If you rely on Power Query to clean, shape, and automate your data, then you already know the user

3
00:00:06,233 --> 00:00:12,333
interface can only take you so far. Because the moment you need something beyond clicking buttons, you're stuck.

4
00:00:12,333 --> 00:00:12,366


5
00:00:12,366 --> 00:00:18,532
Staring at code that looks like random symbols, with strange words like let, each, type

6
00:00:18,533 --> 00:00:23,999
and null, and with cryptic error messages that you have no idea how to fix.

7
00:00:24,000 --> 00:00:24,600


8
00:00:24,600 --> 00:00:30,700
The problem is that the Power Query interface shows you tables first, but the code behind

9
00:00:30,700 --> 00:00:30,733


10
00:00:30,733 --> 00:00:36,966
those tables actually relies on Lists, Records, Types, and Functions.

11
00:00:36,966 --> 00:00:37,099


12
00:00:37,100 --> 00:00:43,266
Basically, M code concepts that you've never been shown. It's like starting in the middle of a book, so it's

13
00:00:43,266 --> 00:00:49,332
no wonder that you find m so confusing, but here's the good news. M isn't difficult,

14
00:00:49,333 --> 00:00:49,499


15
00:00:49,500 --> 00:00:55,533
you just didn't start at the beginning, and that is exactly why we created Demystifying M in

16
00:00:55,533 --> 00:00:55,566


17
00:00:55,566 --> 00:01:01,466
Power Query. This step by step course takes you from what even is M to confidently

18
00:01:01,466 --> 00:01:01,632


19
00:01:01,633 --> 00:01:08,166
understanding, editing and writing your own code. Over more than 120 lessons,

20
00:01:08,166 --> 00:01:14,366
you'll build strong foundations, you'll learn by doing and you'll master the language behind

21
00:01:14,366 --> 00:01:14,399


22
00:01:14,400 --> 00:01:21,333
Power Query. Once you understand M, Power !uery changes for a black box to a controllable

23
00:01:21,333 --> 00:01:27,599
super power. Just join the Excel Academy to get access to the Demystifying M in Power Query

24
00:01:27,600 --> 00:01:27,633


25
00:01:27,633 --> 00:01:32,299
course, and you can finally unlock the full power of Power Query.