How to use Power Query - Microsoft Excel Tutorial

This intermediate Microsoft Excel tutorial focuses on learning Power Query. In this step-by-step Excel Power Query tutorial, we'll show you how to use Microsoft Excel's powerful data transformation tool. Power Query can help you quickly clean, consolidate, and analyze data from multiple sources.

If you're new to Power Query, this tutorial is perfect for you. We'll start with an introduction to the Power Query interface and walk you through connecting to various data sources such as Excel files, text files, and databases. We'll then demonstrate how to use Power Query's features, such as merging, filtering, and pivoting, to transform and refine your data.

This tutorial provides easy-to-follow instructions, so you can practice using Power Query along with us. By the end of this video, you'll have a solid understanding of Power Query and how to use it to streamline your data analysis.

Watch this Excel Power Query tutorial for beginners and start taking your data analysis to the next level. Don't forget to hit the like button and subscribe to our channel for more Excel tutorials!

0:00 Introduction to Power Query in Excel
0:45 What is Power Query?
2:34 Where do you find Power Query?
3:05 How to import data from the web with Power Query
8:40 How to import data from a range or table in Power Query
9:50 Power Query Editor layout
14:25 Make changes to your headers
16:42 Examining the applied steps
17:06 How to convert data types in the Power Query Editor
18:36 Remove unwanted rows (filtering)
20:39 How to split columns in Power Query
22:45 Create a new column
24:33 Create a new column to find a value
28:33 Rounding and moving column
29:39 How to merge queries and join tables in Power Query
34:21 Add new data, then refresh your query

[rasalih]

Thank you so much for sharing your knowledge and expertise on Microsoft Excel through your YouTube channel, Teachers Tech. Your lessons are clear and easy to follow, and have helped me to become more proficient in using this powerful tool. Keep up the great work and I look forward to learning more from you in the future!

[babar]

recently i happened to take this free course, IT IS MARVELOUS, teaching cant be better than this ❤❤❤

[twhite]

This tutorial was awesome! I was able to follow along easily! Thank you so much!!!

[papasmurfington]

I can see how this would have amazing application value to reports, SQL and more. Amazing video! I subscribed.

[ghadamansour]

So simple for starters! Thank you I enjoyed it!

[Heathensauce]

Yay, keep making these tutorials, I use them actively. More Excel tutorials too please, thank you!! You are amazing.

[tmeqrzs]

Very well organized and presented! Thank you,

[ykzzjyc]

Thank you for the video, well detailed and easily understandable for a beginner.

[RightWingScribe]

Thank you so much for taking the time to do this. This has provided me with a starting point to build upon. You have made it so easy to understand. Thank you, Jamie.

[nhinvalerabayugao]

thank you for sharing your knowledge! More power to you Sir!

[myportal]

I am mind-blown right now. I agree with Cheer about doing a video on the pros and cons. Thank you for your guidance.

[thecajunqueen]

Amazing! one of the most satisfying things I love doing is learning new functionality in Excel. I dunno why my brain works that way!

[sammymu]

your presentation is inspiring. thank you.

[bigwind]

Great well presented tutorials. Learned so much. Thank you.

[YetundeTaiwo-juzb]

yipeee. Thanks so much. I am intoxicated by this knowledge. On to the next video

[nazmeeraosman]

Excellent video, your video really helped me understand power query and apply it to my data. Thank you so much

[melanieespino]

Excellent video that built in complexity and answered my questions about the basics. Thank you.

[jvclfsm]

I have watched so many damn videos on power query, and pivot charts, and I've come a long way but your calm, "we'll take all day if we have to" approach helps it all sink in. I subscribed I'm so impressed! Can you or anyone in the comments please tell me or direct me on something? I'm a hotel bartender and since 2018 I've been tracking my credit card, room charge and cash tips, a sheet for each month and totals, etc. I've made a table for my input and and a table next to it for a number of calculations. My 2 days off each week are Zeros all across the sheets. Because of 52 weeks having all those Zeros, Excel can't recommend pivot charts or data analysis. How can I remove the days off for analytics purposes without removing the days off rows permanently? 2023s workbook my 2 days off will not be same as 2022, and plus it's November now, so I only have 1 month of Zeros left to deal with. In January I'll have a full year of Zeros. I'm sure there's content on YT but I don't know where. Meanwhile, I'm going to continue watching your videos. CHEERS!

[RiverAllie]

Super great tutorial for beginners. Thank you!

[kamrenroelike]

Excellent video, explained it nice and calmly and could understand everything you were saying. Great Job!