Excel Power Query Combo – Beginners + Advanced M language

Learn in built transformation to M Language, Power Query patterns, Custom M Functions, Parameters

Created by: Abhay Gadiya
Best seller instructor for Power BI and Power Excel

What Will I Learn?

• At the end of this Power Query Training you would understand basic to advanced level of M Language
• Custom M Function, Parameters, Readymade Power Query Patterns
• You would be able to perform various complex data cleansing activities using Power Query
• You would be able to automate various task which would have taken long hours of work.

Requirements

• You should have basic knowledge of using Excel.
• You should be aware about Table feature in Excel.
• You should have Excel 2010 / 2013 / 2016 version installed in your PC.
• You would need to install Power Query if you are using Excel 2010 or 2013. (will be shown during the course intro)

Target audience

• Novice Excel user to Advanced Excel users
• People performing Data Analytics in Excel, Power Pivot, Power BI, Tableau, Python, R
• Business Intelligence Specialists using Excel, Tableau, Power Pivot, Power BI, Python, R
• Data Analysts / Financial Analysts using Excel, Tableau, Power Pivot, Power BI, Python, R
• If you or your team needs to fetch data from different sources and transform it so that it can be used in Excel for further analysis, then this course will help you master Power Query features from scratch
• IT specialists who performs Extract Transform & Load (ETL) activities for business