Excel Power Query - Crash Course for Beginners

Power Query Course for Excel Beginners - Automate your task using Power Query and Power BI.

We covered the following topics:
00:00 Introduction to Power Query
00:30 Automate a Data Transform in Power Query
02:02 Transform Data Function in Power BI
03:16 Power Query editor
05:33 What is Query in Power Query
06:12 Activate the Formula Bar in Power Query
06:20 Activate the Query Settings in Power Query
06:30 Restore Data in Power Query
07:40 Remove Null Column in Power Query
08:39 Remove Row in Power Query
09:33 How to position Headings in Power Query
11:43 How to Check the Data type in Power Query
11:59 How to Remove Duplicates in Power Query
13:01 How to use Unpivot Columns in Power Query
14:12 How to Rename Column Headers Name in Power Query
15:13 How to Merge Columns in Power Query
16:43 How to use Column from Example in Power Query
19:48 How to use Custom Column in Power Query
23:27 How to use Conditional Column in Power Query
25:55 How to Duplicate the Query in Power Query
26:25 How to use Reference Function in Power Query
27:01 How to use Group By Function in Power Query
29:22 How to Get Data in Excel From Power Query
30:03 How to use Queries and Connection in Power Query
32:25 How to use Advance Editor in Power Query
32:55 How to use Transform Data Button in Power BI

Excel Power Query - Crash Course for Beginners
#Powerquery #powerquerycourse #automation

Let's Connect:

[OlawaleMichael-qmkf]

You are indeed a good teacher. I watch it this video again and again for 3hrs! Now I have got insights to Excel power Query. Thank you sir

[katiearkie]

I've looked high and low for power query lessons on YT and this by far is the best lesson. Thank you for putting this on YT. Hitting that subscribe button.

[h.ragavendranhariharan]

Hi This is Ragavendran from chennai. A big hi to you. I have literally subscribed to all the excel channels and found this tutorial on power query to be extremely comprehensive and easy to follow. Don't know how I missed your channel all these days. Couldn't give More than One like unfortunately.

[canirmalchoudhary]

I learnt how to avoid wrongly applying Remove duplicates. Thank you 😊

[h.ragavendranhariharan]

Best part which I liked reminded me of my close friend who taught me excel way back in 2015. That willingness to let others know where and how to look out for a question based on new column in Google. Hats off bro. You reminded my best friend by doing that!!

[troylindemann]

Great introduction to the power of power query. Great place to start.

[fortuneessien]

I absolutely love this! Great lesson. Thank you.

[hemantjoshi]

Thanks for explaining in such simple way !

[valerylorou]

You are truly brilliant! Incredible teaching skills! Even my 6 years old will know how to use Power Query listening to you. Great job!

[fix-r]

Most powerful video's on YouTube 🔥

[pjdebutler]

Thank you so much for this. I've been struggling to get a grip with power query and have watched numerous videos and used linkedin learning as well. Your video did the best job explaining how it all works and how to implement it. Your recommendations as the best action to take when there are multiple options is particularly helpful. Finally, your recap/agenda is great!

[gaborsaniti]

Thanks it really helped me giving a great idea of what power query can do, best crash course yet I've partecipated!

[amolthapa]

Very well explained. Please keep them coming.

[DataExcellency]

Please assist us with the Practice Files. Thank you for being so helpful. Grateful to have found you.

[KikiKay]

This was an amazing video! You are truly a skilled instructor. Everything was explained so clearly and you made it easy to follow by having an agenda at the beginning.

[Tara-Wind]

You have amazing teaching skills ! Thank you so much for this great video.

[moshemo]

Really helpful and really well done -- and in a relatively short amount of time (when compared to the 2 or 3 hour Power Query tutorials that are out there).

Thanks.

[hemantjoshi]

Hi Tutor, Just wanted to check do you have another tutorial in sequence to this. If yes, where I can get it. Thanks a ton !!

[pluto_dp]

How could I ignore this for so long...

[goldenguras]

i cant see anything. Its very blurry. Hence, I can't follow.