PowerQuery M Code Programming – Part 1 (7 hours)

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

Created by: ajay parmar
Instructor -Excel,Vba ,Access, Access Vba,BI,PQ,G SHEETS

What Will I Learn?

• We will learn the use of M functions in PowerQuery . M stands for Mash-up language.
• You will go beyond front interface and see how we can change powerquery codes the way we want and control the data and shape it up in much better way.
• Front End is powerful but it cannot match with the Back end abilities when it comes to data cleaning and structuring .
• Practical use of M functions - Table functions, List functions, use of records . Many amazing projects as well.
• You will learn the basics of Mcode. How to write your own syntax.
• Rules to follow while writing syntax. How to customize it, How to take inbuilt syntax and change it .
• What are lists , records and Table . Also, use of Table functions, List functions etc
• M langue or M code will make you awesome from every angle in controlling and cleaning the data and then finally helps in analysis.
• Its a course for those professionals who want to begin with M code and they are aware of Powerquery

Requirements

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

Target audience

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