Power Query's Advanced Editor isn't just for Pros. In this video we demystify the advanced editor so anyone can feel comfortable modifying and writing Power Query M code. Includes creating variables, custom functions and commenting code.
0:00 Introduction
1:22 M Code Structure & Editing
4:07 Creating Variables
5:33 Using Variables in Custom Columns
10:26 Commenting Code
11:54 Writing Functions
Learn Power Query here: https://www.myonlinetraininghub.com/excel-power-query-course
View our comprehensive courses: https://www.myonlinetraininghub.com/
Connect with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/