Excel Power Query Training - Beginners to Advanced level

person icon Abhay Gadiya

Excel Power Query Training - Beginners to Advanced level

Data modelling using get & transform for business intelligence and data analytics in Excel 2010 -2016 using Power Query

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Abhay Gadiya

architecture icon Office Productivity,Microsoft Excel,Power Query


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description


It's a FREE  tool provided by Microsoft for Excel users. 

Yes you read it correctly. This tool is FREE !!!

And Power Query can make novice Excel user to PRO-Excel user very quickly & this training will make your journey easy and memorable.

Power Query is available for ALL users of Excel 2010 / 2013 / 2016 and PowerBI. In Excel 2016 it has been renamed as "Get & Transform".

This course topics can be applied for all versions of Power Query - Excel 2010 / 2013 / 2016 & Power BI.

Power Query is a tool that can be used for data discovery, reshaping the data and combining data ( Merge / Blend / Consolidate, etc.) coming from different sources. Power Query can connect directly to Excel, Access, Text, CSV, Hadoop, Sales Force, Azure and many other different sources of data.

You can perform and automate all the Extract > Transform > Load (ETL) tasks required to clean the data and make it usable for further analysis in Tableau, Power BI, Excel, Access, etc.

Who this course is for:

  • 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


What will you learn in this course:

  • At the end of this Power Query Training you would understand 80% of features available in Power Query
  • 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.


What are the prerequisites for this course?

  • 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)
Excel Power Query Training - Beginners to Advanced level


Check out the detailed breakdown of what’s inside the course

Instructor Introduction
3 Lectures
  • play icon Instructor Introduction 02:23 02:23
  • play icon Introduction to Power Query 14:28 14:28
  • play icon Supporting Excel Files
Getting Started with Power Query
3 Lectures
Data transformation without any formulas inside Power Query
6 Lectures
Working on data from multiple sources
6 Lectures
I have stopped using VLOOKUP function - want to know why?
3 Lectures
On the way to become superstar in Power Query - Learn basics of M Language
6 Lectures
Apply the knowledge gained to real world datasets - see the immediate difference
8 Lectures
Increase your level with regards to M Language
4 Lectures
Apply your M Language knowledge to complex data from real world
4 Lectures

Instructor Details

Abhay Gadiya

Abhay Gadiya

Best seller instructor for Power BI and Power Excel

I am Chartered Accountant, Certified Fraud Examiner and have completed Diploma in Information System Audit (Indian equivalent exam for CISA).

I have circa 16+ years of experience into Data Analytics, Internal Audits, External (Statutory) Audits, SOX Compliance, Risk Assessment and Regulatory Compliance.  I have audited various entities under BFSI, Automotive Manufacturing, ITES, Infrastructure and Pharmaceuticals sectors. I have worked circa 9 years with Big4 consultancy firms – Deloitte, Price Waterhouse and other with Bank of New York Mellon.

I have conducted various workshops at Institute of Chartered Accountants of India. Approximately 600+ people have attended these workshops and have given extremely positive feedback.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us