PowerQuery M Code Programming - Part 1 (7 hours)

PowerQuery M Code Programming - Part 1   (7 hours)

Description:

  • 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.

Course Fee

$64.99

Discounted Fee

$13.00

Hours

7

Views

231