PowerQuery M Code Programming - Part 1 (7 hours)

Powerquery M code, Powerquery M functions, How to use M code

• This course PART1 is an attempt to make you awesome in using M code in PowerQuery

• Course is built on a slow pace so newbies can understand the fundamentals on which M code is built.

• I am giving you my live online classes recordings so you will get the real feel of a class. Serious learning with focusing on every part of a mcode.

• It is for those students who are familiar with PowerQuery front part .

• What is M code in  PowerQuery and how do write our own codes plus how do we edit the pq built codes.

• How to use Table, List functions in Mcode

• How to change or modify M code in PowerQuery by first recording the steps for fast results

• What are Table functions and their basics plus real use in life. Table sort, table transpose, table to list, table select columns are the functions discussed

• What are the list objects - from basic to advance use

• What the records - From basics to advance

• How to link values in a powerquery like in excel we do. Clear explanation on how things work in Powerquery.

• Several mixed projects for your revision at the end plus more knowledge on M functions

• This course will make you fundamentally awesome in PowerQuery M code and you can go beyond normal user capabilities to change and modify the data. the way you want.

• Files are downloadable and Online help is available from me, in case you have doubts.