Requirements

• You should be knowing Powerquery basics . You should know how to work with powerquery features available in its Ribbon.

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.

Who this course is for:

• Students who want to go in data analytics or professionals who want to make career in Excel based applications or who are already working in MIS reporting or business analyst and work day and night in excel.