How to use Microsoft Power Query

In this step-by-step tutorial, learn how you can use Microsoft Power Query to get and clean up data in both Microsoft Excel and Microsoft Power BI. Power Query is the easiest way to connect, extract, transform and load data from a wide range of sources.

👋 Additional resources:

⌚ Timestamps
00:00 Introduction
00:59 Sample data
2:14 How to get Power Query
2:31 Get data
3:35 Combine data
5:26 Main Power Query interface
7:00 Transform data
11:21 Applied steps
12:06 Close & Load
12:33 Data imported into Excel
13:34 Insert pivot table & chart
14:46 Importing additional data
16:00 Wrap up

📃 Watch related playlists and videos

🚩 Connect with me on social:

🔔 Subscribe to my YouTube channel

🎬 Want to watch again? Navigate back to my YouTube channel quickly

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

[boomwilson]

Kevin. I'm an Accounting and Finance Exec who manages very large data quantities. You just transformed my life. I'm a fan!!

[InSimonated]

Dude... you are REALLY good at producing beautifully simple, easy to follow tutorials. You make everything so clear and relatable. Never assuming the viewer's knowledge level, nor speaking down to more advanced users. That in itself is really impressive. Thanks! I find these so useful.

[Divadosaurus]

Wow - as someone who has seen various people at work rocking power queries, I thought it was a step I didn't have the energy for after getting to grips with everything from pivot tables through to writing decently long VBA code. Little did I know how "easy" and powerful this is. My company has finally settled on some standards across the organisation and is moving to Power BI and SQL, so I needed to find a good resource to get started and this is it (I came here from your Power BI intro video). Thanks, you're a good teacher and hopefully my comment helps the algorithm.

[jesseyang]

Starting to advance my excel skills from simple formulas and heard about this power query. It looks very useful and will definitely try. Most of all, your instructions are by far better than any other instructions I’ve watched on any web sources. Very detailed, soft spoken, very good pace and visual. It is very good for the beginners like me to learn from. Subscribed and liked!

[DGuyette]

Kevin, you just saved me hours of work. thank you

[dianemaeperez]

I'm a freelancer Amazon PPC Specialist and this will help me save time and focus on analysis. You're now my new favorite Excel guru.

[Anonymous-homt]

Not too slow, not too fast... Just perfect pace... Best on YouTube

[saulger]

How good is that !!!
Kevin's tutorial is clearer than a course costing hundreds of dollars. Simply terrific.

[GeedorahGaming]

Ive been using Query in Power BI this whole time with my datasets and had no idea it was a separate product! I’m usually a “hands on and fumble through it” type of learner, but I’ve recently been put in a place to teach everything I’ve been putting into practice. This video is going to help tremendously, thanks for your time and help!

[dinaaslan]

Thank you Kevin for such BRILLIANT work! The fact that you also provide sample files that one can train on while following your videos and that the video is divided in chapters sets you above most tutors!

[stylus]

Where has Power Query been all my life?? Thanks Kevin!

[fireman]

Wow! That was the best explanation of Power Query I’ve ever seen. I feel like I can do this now

[PeddyNguyenishere]

Omg that delimiter is the I inserted data manually and it took hour, wish I saw this video sooner!!! Thank you Kev!!!

[timolapinen]

I was about to study this subject and then I had my flow telling me you have published this video... Quite challenging feature well explained. Thanks Kevin!

[curiosityintrigue]

I made a long complicated series of steps macro years ago in Excel. This would have been so much better. I’m glad I know about it now.

[shandrewsampson]

omfg i dont know why i was afraid of excel for so long. have been watching your videos and you have been getting me some SERIOUS brownie points at work. thank you!

[garylillich]

Thank you for including the actual files you worked with. That makes learning so much more effective.

[jonasrigodon]

This man should definitely get an Award for his tutorials. Kevin, your teaching style is incredible !

[robertwhite]

Great coverage of a rather complex feature. Well done!

[Otterpawp]

Way to make a great primer in less than 20 minutes. Was perfect to help me bust the rust, but I can see this as being a great primer for new people to jump right into it.