Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel Power Query (10 hours +)
Rating: 4.5 out of 5(212 ratings)
1,011 students

Excel Power Query (10 hours +)

Complete Tutorial -PowerQuery Basic to Advance
Created byajay parmar
Last updated 2/2025
English

What you'll learn

  • How to use PowerQuery in Cleaning and Transforming the complex , unstructured and tidy data mess.
  • PowerQuery Ribbon features - Each and Every feature is discussed with examples.
  • How to work with millions of rows coming from external sources or within excel sheets
  • You will see several complex projects and quizzes with solution to see the real use of powerquery in your office.
  • Amazing Data cleaning techniques, data mining, making it fit for reports - You shall learn in this.
  • How to work with websites to get their information

Course content

1 section • 29 lectures • 10h 47m total length

  • Overview and Installation38:27

    We are trying to understand with example here that why in today's time every excel user must know this ETL tool called PowerQuery. A free tool given to us by Microsoft to clean the structure the data in minutes.

  • Import Excel Tables within the workbook28:06

    How to take excel sheet table data in PQ window and then work on it. Simple and fist step towards our learning

  • Import Text files or CSV from a Folder28:53

    What if we need to use txt files data in PQ. So. let us see that.

  • Import Txt files from Folder with FileName23:56

    Now. importing data with its file name is no more a complex thing. Its simple ,flawlessly smooth and can be done in seconds.

  • Import Excel files with sheet name12:02
  • Import All Excel Tables in one go33:05

    How and when to use CurrentWorkbook function in Powerquery. This is very awesome

  • PowerFul Joins - Vlookup replacement and much more - Part120:04
  • PowerFul Joins - Part219:56
  • PowerFul Joins - Part336:13
  • PowerFul Joins - Part415:09
  • Group By feature - Amazing and Easy to use41:48
  • Group By feature - Part222:42

    Group by option is used in databases to see cumulative sums of numbers but now it is available in PQ as well.

    This will take your excel work to a new height without using any excel formula's.

  • UnPivot Feature - Tough days are gone now35:24

    Simple awesome feature in PQ. See the use of unpivot fundamentally and practically.

  • 11 Amazing Powerquery ribbon features47:27

    Almost every important and interesting feature is discussed in this Lecture.

    From mathematical calculation to Join the columns

    How to use columns as example.

    Working on top rows or headers - everything is discussed and much more.

  • Date Functions - Classic invention by Microsoft PQ32:07

    Simple unbelievable work done on Date functions when it comes to PQ .

    Know each and every date function working with full explanation in PQ ribbon.

  • Text Functions - Full Coverage with amazing examples12:00

    All text features available in PQ ribbon are discussed in this lecture with great examples.

  • Text Functions - Part217:19

    Know your split feature from basic to advance. You will avoid putting time on excel text functions after learning this in PQ.

  • Complex Project discussion 1 - Surprise Test for you with solution24:16

    Classic example of transpose and unpivot feature in PQ . This project will give you great confidence and visibility to handle complex data structures.

  • Another Awesome Project for you with solution26:14

    In this project we are using group by and Joins to get the desired output.

  • A quiz with solution7:29

    • How to keep duplicate rows in data and remove all unique rows.

    • How to keep unique list of Names in asc or dsc order

  • One more Project - Advance Level Remove Dummy rows22:40

    This is one of the best touch project we are discussing where we need to remove some rows basis some conditons and make a good analytical performance report out of it.

  • Your Questions My solutions- What if folder data source changed11:27

    How to change source in PQ editor if your data path is renamed or changed - External folder path

  • Your Questions My solution- Trick to re-order too many table headers4:28

    How to re arrange columns in editor by not dragging it individually and dropping over. A Cool tip to do that in less time.

  • Your Project is solved here - Check out because its awesome14:28

    A recent data challenge i came across. Thanks to one of you. Pls check this data challenge and how we sorted it out.

  • One amazing project for you - Split the items24:44
  • Import Website Tables13:56

    This lecture is very very easy so there is no file attached here. It is simply educating us how we can connect any website using PowerQuery and get the table data.

  • My Courses with links and Coupon Codes2:00
  • Combine Multiple Excel sheets data in one table25:30

    Apart from PQ solution, I have tried to give you M code knowledge  as well but  as you know it is not a part of this course. My aim is to show you the strength of Mcode so that you can make your decision as to why we need to learn Mcode . After PQ, you must learn it.

  • Import Data from SQL Sever5:44

Requirements

  • You should have atleast excel 2010 installed and basic knowledge of Excel is must. No vba is needed.

Description

  • This course covers the Basic and Advance PowerQuery

  • From installing the PQ to checking the system requirements and Its definition.

  • Covering the PQ ribbon - all features with examples in full detail

  • Why it is called ETL Tool - Extract Transform Load

  • Benefits of Powerquery over normal Excel spread sheets

  • Handling millions and billions rows efficiently

  • How to import data from different sources like txt , csv,folders, databases, excel sheets

  • Every minute detail about PQ ribbon features with the help of examples

  • Know your magnificent Group by feature - Complete tutorial including projects

  • Date functions - Very easy and powerful

  • Text Functions in extracting the values is discussed, no need to build now excel formulas or VBA

  • PQ functions - CSV.Document , Excel.Currentworkbook, excel.workbook are discussed with practical examples

  • Transpose feature, UnPivot Feature - where and how they can be used.

  • How to use first row as header, how to change data type and why you should know this.

  • How to reverse the rows of your table.

  • How to use replace value feature and how to use Fill values button in Powerquery under Transform tab

  • How to use split, columns from example, edit custom columns.

  • How to extract the numbers, texts or num to digit and vice versa

  • Several practical projects for you with solutions - Amazing result driven projects for you

  • What are the different types of JOINS - Left Join, Right, Full, left anti, Right Anti - All are covered

  • How to use IF statements in PQ and how they are beneficial in real time projects

  • How to change the source or location of data, What is refresh and refresh all ,Connection only ,close and close and load to options

  • How to use website tables data in excel using powerquery- Its called webscraping

  • Several advance level projects with quizzes (solution given in lectures)

  • Online support 24*7 given by me to address your issues

Who this course is for:

  • All the students or professionals who do or want to be a data Analyst and shine in this industry should go for this.
  • If you work with millions of data or a data which is not properly structured and you do lot of steps to clean it first , before making reports on it.
  • if you want to make reports from tidy and unbelievable unstructured data stored in excel spreadsheets you can do it now without VBA.

Report abuse