How to use Microsoft Power Query

Подписаться 3 млн

Просмотров 1,8 млн

50% 1

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
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:
- Sample files: 1drv.ms/u/s!AmxrofZZlZ-whKZQT...
- Download Power Query for Excel 2010 or 2013: www.microsoft.com/en-au/downl...
⌚ 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
- Pivot Table tutorial: • Pivot Table Excel Tuto...
- Excel: • ❎ How to use Excel
- Power BI: • Power BI
🚩 Connect with me on social:
- LinkedIn: / kevinstratvert
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
🔔 Subscribe to my RU-vid channel
ru-vid.com?...
🎬 Want to watch again? Navigate back to my RU-vid channel quickly
www.kevinstratvert.com
🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz
⚖ 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.

Наука

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 1 тыс.

@KevinStratvert 3 года назад

⏭️ Watch next - playlist with all my free tutorial videos on how to use Excel: ru-vid.com/group/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 📩 Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/ 🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com

@alfiyamn4119 2 года назад

There is no close and load option 13.00

@reybode8452 2 года назад

instablaster...

@psamkelv 2 года назад

Hello Kevin, Does the excel format type have any effect on this? The files I receive are coming in csv format.

@psamkelv 2 года назад

Again, does power query work with files containing formulae (Vlookup, Xlookup etc)?

@Blacklistedddd 2 года назад

@@psamkelv yes it works.Power query will only record your steps and final output will be on the new excel sheet

@boomwilson351 2 года назад

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

@RenierWessels 2 года назад

I'm curious. When you have a eureka moment, do you go "BOOM"?

@squattingbull10 Год назад

Referring to oneself as an exec invokes the curious golden retriever head tilt… add to it the notion that power query would transform my day to day activity gets the full on head twist plus bs bark.

@will201084 Год назад

@@squattingbull10 you would be surprised how many executives don't know as many tools as some of their juniors. All about how you network to get to executive level.

@savann.sun1980 Год назад

I think there is some lies in your comment. I do not believe someone mentioning that his dealing with large data while working in accounting job and somehow from a vdo from youtube it makes your life easier. I would believe if it’s from someone is learning power query and still in learning process.

@simitmishra4981 Год назад

you can go for videos of Laila Gharani

@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.

@smccabe 9 месяцев назад

Agreed...and a nice pace to the explanations too. Not too quick or slow.

@Divadosaurus 2 года назад

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.

@EdsonNascimentoEN 3 года назад

Kevin, in my new role I am using your amazing videos as a reference. Thanks for making things simple and straight to the point.

@timolapinen494 3 года назад

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!

@dinaaslan8506 Год назад

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!

@dinaaslan8506 Год назад

I don't see the same screens when I follow the video because I'm a MAC user! Do you have a Mac version you can share?

@dianemaeperez7273 Год назад

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.

@ianl1052 10 месяцев назад

Just followed this along on my freshly downloaded 365. Delighted to say it worked flawlessly. A few years ago, I done levels 1 to 3 training courses in Excel (and others). We didn't even touch Pivot Tables. This is like level 5 or beyond.Subscribed and liked. I'll go through your other videos and save the ones that interest me the most in my favourites folder.👍

@jesseyang6886 2 года назад

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!

@zainabebrahim8392 2 года назад

I totally agree with you. I even started to love excel because of Kevin's videos.

@rainoppus2521 10 месяцев назад

agree!!!

@saulger6409 2 года назад

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

@mz.qleanne1132 8 месяцев назад

Thank you for simplifying this Kevin! In just a few moments, you provided an answer to the questions that I have been asking myself all year. I now know how to combine my monthly reports (which contain about 300 items or more) into one report in an efficient way.

@ryanserrato4689 Год назад

I'm legal dept, so not very tech savvy. Your videos are by far the best and easiest to understand/follow. Sincerely, thank you!

@garylillich 2 года назад

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

@andrewbegin5281 2 года назад

This is so awesome! What a great intro explanation! I look back at all of the time I spent pulling data to create something useful, and now I wish I would have known about power query! Thanks Kevin!

@anthonyaroni5530 3 года назад

Power Query is a game changer. I've used it for a few years and it's now a must have. It can do most if not all things that other 3rd party apps can do and it's doesn't have an additional cost. Thanks for promoting it.

@bnwguitarist Год назад

Amazing. I worked in a company cleaning endless data and repeatedly. This changes everything. Thank you for your video Kevin!

@DGuyette 3 года назад

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

@charliebamford2807 3 года назад

Very good presentation. The pace of your delivery is quite fast which keeps me engaged. I'm a big fan of Power Query but use it with Excel linked to SQL views that I've created. I do most of the basic design in SQL but still find PQ useful for tidying up. My SQL views often have few filters in them because I use the filter tools in PQ. Good for 'Advanced' users but not suitable for 'Normal' people. I need to learn more!

@darianascoli1277 2 года назад

Thanks for the video! Just transitioned accounting software. Old software we used ODBC to pull data into Excel. New software won't let us use ODBC, so this has been immensely helpful to rebuild the tools we already had in place.

@soothingrelaxation.sleepan3224 3 года назад

This video is very informative. Its really improving my Data Analysis skills. Thanks, Kevin.

@adityabhat3108 3 года назад

Hey Kevin, I must say great content and amazingly explained as always. I have subscribed to your channel and look forward to every video that you release. Great going!!

@LorenzoAnderson-ih5ke Год назад

Thank you for being so discriptive and explaining what's going on and not just showing and moving on. Fabulous teaching thanks man!

@jonasrigodon3026 2 месяца назад

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

@maryonalaja5591 Год назад

Just the perfect example, i had been looking for...Thanks Kevin!

@nczioox1116 3 года назад

Thanks for keeping it concise yet informative

@lairdbishop1837 Год назад

Instant subscribe. Thank you for delivering what I needed to know in a matter of minutes. This was more than enough to familiarize me. Lack of a Power Query skill set has presented a roadblock in a project I am doing in Power Platform. I expected to devote several hours to taking a LinkedIn course or something. You got me back in production quickly and that was invaluable to me.

@ernestosabatercalvet 3 года назад

Thank you Kevin for such a great content you always publish, it just took me 16 mints to review what I learned in 2 hours in another video.

@Anonymous-ho1mt Год назад

Not too slow, not too fast... Just perfect pace... Best on RU-vid

@scottng8171 3 года назад

THIS SO DAMN POWERFUL!

@StephanAshkenazy 3 года назад

Dear Kevin, huge thanks for this video, for the clearly provided explanations. It opened my eyes widely. Keep doing it and one more time - thank you very much!!! Very very helpful!

@thomaskoch3884 10 месяцев назад

Kevin, thank you very much for the really great video. Even for me as a non-native speaker from Germany everything was very clear and 100% understandable. I would be very happy to see more videos on Power Query, Power Pivot, DAX and M formulas.

@robertwhite2837 3 года назад

Great coverage of a rather complex feature. Well done!

@veronicaescallon5855 3 года назад

Excellent thank you!!!

@maureencoulliette5639 3 года назад

It's been 3 years since I used Power Query, so much easier now. Thank you!

@alfiyamn4119 2 года назад

cant select the profit column and cost column together...How it is to be done?

@joshlord6873 2 месяца назад

@@alfiyamn4119hold Ctrl while selecting

@littlebird_travels5133 3 года назад

This is so useful! and Kevin you've made broken down into such simple and easy bits that I didn't have any trouble following along! Thank you!

@themortal1 3 года назад

Every single video is adding or improving my toolbox! Thank you very much!!!

@fireman194 Год назад

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

@bharathiraja2958 Год назад

Excellent feature and very well explained!

@KayJohnsonArt Год назад

Thank you so much Kevin. Your videos are so helpful. Clear, concise and straight to the point. You are a star!

@picksmile5010 11 месяцев назад

Thanks, Kevin, after watching your DAX with Power BI I glued to your channel. Here again, power query you did a good job. You are a great teacher. You make it all simple and the steps are well followed. 🎉

@muhamadfirdauscherahim1778 Год назад

Hi Kevin..thanks for the interactive video. I do notice the profit column is copying the data from the revenue column even after you applied the substraction function formula..

@shandrewsampson6539 20 дней назад

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!

@kevindaniel7333 Год назад

Thanks!

@jacksonli4705 Год назад

excellently paced, explaining and demonstrating all the most important stuff in minimal time with no fluff

@Sam-oc7nu 2 года назад

Thanks a lot. I like how you get straight to the point and don't leave any time for useless information.

@ayushkumargupta2893 3 года назад

So damn useful

@XcelGuruSayantan 3 года назад

Power Query simplified. Fantastic. Just one question. What is the difference between Power Query and Macros?

@garylhaas2005 3 года назад

Both are programming languages."Programming" in Power Query is structured - you choose steps & can see the results at each step. Macros are a blank sheet of paper.

@geralynteow567 2 года назад

@@garylhaas2005 op,Zapzz28az do

@davidganesh8153 Год назад

Superb, great job Kevin. You really make things easier to understand, crystal clear with demos and explanations regardless of anyone's knowledge. Amazing!!!

@chrisberardi2304 Год назад

Hi Kevin - I just wanted to let you know how valuable I am finding your videos. Actually, much more than videos - lots of valuable information that gets to the heart of things in a concise manner. Thank you.

@user-ul2lv7qs7r 10 месяцев назад

Great video! You really has a knack of explaining things in a simple yet comprehensive way. Thank you very much, Kevin!

@bigd8185 Месяц назад

Ty for this. I'll be using Power Query to automate most of my data entry for my forex trading now, instead of having to manually type each trade in. This will allow me to spend more time focusing on the trade, instead of the data entry. Thank you very much!

@karthikeyanmasilamani7812 8 дней назад

Simple, Clear, Straight to the Point & Awesome.

@robuhrig4575 Год назад

Very informative and easy to follow along. Thanks for shedding light on how to simplify an otherwise nightmarish process.

@VP-yp8ip 10 месяцев назад

This made my job easier when validating rebate transactions in my department. Thank you so much for teaching me a more practical and enjoyable way to analyze data.

@Pikruga27 3 года назад

You saved me hours of work! I've been using Power Query the wrong way the whole time. Thank you!!

@marymurathi164 3 года назад

Thank you so much Kevin for this video . You are so clear and explaining every detail . You are amazing .

@alexa.pacaldo8731 Год назад

Wow!!! I got to see the real essence of using power query in which I hadn't used it when I consolidate the data. I had a lot of pains doing the report and it took me the whole working hours to finish cleaning it. Why the earth has made my days so bloody when there is such a video teaching this technique. And why I didn't find this before? I would like to say thank you to this handsome guy for giving us a such an excellent presentation. You made my day!!! Bravo. Hope you will make more interesting video presentation.

@olufunkeadegoroye4191 2 месяца назад

Thank you Kevin for this simple and straight forward video

@PeddyNguyenishere 3 года назад

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

@susansmith6645 2 года назад

Great intro explanation! The SME in my area directed to go watch some RU-vid videos first. This one was perfect. Then we talked and I picked up tips specific to how I was getting my data. I am now tasked with training my colleagues. I'm sending them this link as a pre-requisite to my demonstration. Thank you, and I will seek you out when it is time to learn another Microsoft/Excel feature.

@mirali5217 2 месяца назад

Extremely useful very transformational learning for dramatic productivity - Thanks Keven!

@vladimirkievsky2939 2 года назад

This is great presentation, clear, full of knowledge, and easy to understand every said point . As usual - thumb up Kevin.

@garylillich 2 года назад

Great Video, Love your style. Amazing that my task at hand is SO close to what you did here. Earlier, I watched other videos, and the procedure there seemed so complicated to do what I call a simple task.

@dawies 3 года назад

Thank you for such amazing videos Kevin!!! Over the last year I really started to use and utilize all of the "free" tools that comes with Microsoft 365 Enterprise such as Forms, Automative, Flows etc. I just started looking into learning and understanding PowerBI and Power Query and those two videos really inspired me to work on my skills to work smarter and faster! I'm gonna try to help my company use desktop Automative a lot more to remove as many manual process as possible in the near future! So thank you for sharing and please keep updating and slowly digging deep into the endless opportunities between PowerBI and Power Query. I really want to learn to build powerful and easy understandable Dashboards.

@alfiyamn4119 2 года назад

cant select the profit column and cost column together...How it is to be done?

@davidadams421 3 года назад

You can use the same feature to directly interrogate online databases too. I have a WordPress-based membership website and use power query to extract out all my membership data, where I then visualise trends, identify new/expired members etc. Every time I open the workbook, it updates itself with up-to-the-second data. Very useful. Btw, not 100% on the new format, but I would at least recommend changing your lighting setup - you have a rather unsettling green tinge around you! The Incredible Kevin! ;-)

@pushpendrachandra8868 2 года назад

At first I was just clueless about power queries and how it works. But this video Kevin!! Oh gosh this is amazing. Now I can't wait to use power query🔥

@MarkBradley 3 года назад

Thank's Kevin -- I appreciate your approach to training! Keep up the good work!

@fers9918 3 месяца назад

thank you! 👏 i had no idea about power queries until I saw another one of your tutorials. This is extremely helpful! Your tutorials are exceptional - everything is clearly explained and easy to follow.

@kevinhenry1681 3 года назад

This is great...thanks Kev!! How you explained and show how to use Power Query REALLY help me out!

@themetalrock 2 года назад

Thank you for this tutorial. Repeated everything after the video and it worked like a charm. Now I need to find out how to combine data from one file with multiple sheets.

@walkstreets 2 года назад

I really loved the way it was been explained. I tried few other videos. However, I understood the concept only from this video. Thanks to Kevin

@curiosityintrigue 2 года назад

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.

@2Tulipa 3 года назад

I really enjoyed your webiner on Pivot & power query, this gets right to the point and is very simple and informative .thanks a lot!

@socorrotirado1068 Год назад

Kevin, you have been an amazing teacher. I've increase my knowledge by following your tutorials more than attending courses. You rock 🤟 thanks!

@nspengineering Год назад

Can cells in a row be merged in power query?

@vklempa1 Месяц назад

love it!! game change!! many thanks Kevin!

@yannaingwin123 3 года назад

Thank you so much!! Would like to see more like these kinda tools and useful tips for business analysts.

@jspeed04 3 года назад

This is amazing and simple, thank you very much, Kevin!

@walternyc 3 года назад

Some of the best ratio of favs in RU-vid. Well deserved. Excellent as always.

@adelaramirez970 Год назад

This was STELLAR. Will be taking a stab at my first power query and feel at ease after watching your video. THANK YOU!

@utubeAgape 3 года назад

Great business use cases in this video - which is very helpful - thank you Kevin for another great tutorial!

@qasimjadoon870 3 года назад

Fantastic Kevin, your videos on microsoft products are much helpful and supportive.

@santafilipina9020 2 месяца назад

Thank you very much. I followed along and it worked beautifully for me.

@Otterpawp 2 года назад

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.

@ShahrukhKhan-vk8yu 3 года назад

Thank you Kevin for another lesson ❤️

@afmarahman Год назад

Hi Kevin, I am kind of love at first watch to all of your excel videos. You are exceptional in chopping complex things into simple and synthesizing them back to the presenter for grasping the easiest way possible. You have a lot of videos on how to analyse data. However, do you have any plans to show how and what to consider before making a dataset in excel? Like, if I receive a lot of similar information from different organisations and plan to record them in excel sheets to run some queries, do you have any suggestions? What is the best way to set them up to run power query or power pivot? Hope these questions make sense to you. :)

@rehababdelwahab3987 Месяц назад

Thank you so much for tutorials.

@BettyFL 2 года назад

Outstanding. Replicated these steps and wow, what a time saver. Huge thank you!!

@cihanguler6568 6 месяцев назад

Couldn't be more clear and efficient. Thank a lot!

@charlesnazare7358 3 года назад

Awesome Kevin! I will plan to use power query more often using this as a reference.

@drdheerajtumu7419 3 года назад

U made Power query look so simple and easy. Thumbs up Kevin.

@genxiao8737 2 года назад

You explanation is simple and easy to understand! Thank you!

@katrina8817 Год назад

Thanks Kevin. Im looking for a job as Excel analyst and I Iearnt a lot from your videos, you make Excel very easy

@Ahmed-fq6si 2 года назад

A quick look at power query you said? For me it was more than that. Highly appreciated, thank you Kevin.

@prettykaypee 3 года назад

Another great video! Thank you for showing this functionality in Excel. Now I don't have to shiver whenever I need to analyse data!

@alfiyamn4119 2 года назад

cant select the profit column and cost column together...How it is to be done?

@jeffmoden4332 Год назад

I'm not easy to impress but you never fail to impress me. Very, very, well done, Kevin.

@martinschlenker6145 3 года назад

Excellent ! I've never used this function in that way. Thanks !

@nataliameyer4947 7 месяцев назад

Hi Kevin !!! Just wanted to thank you for another great tutorial and for making available sheets for me to follow the it. I am currently looking for a better job and your videos helped me to get more confident and encouraged to learn further . THANK YOU 💝

@HarshColby 3 года назад

Thanks! I do this all the time ... manually ... arg! Next month, I'll set up a power query.

@mujeebullah5441 9 месяцев назад

Big thanks, KevinStratvert 🙌 Your tutorial was super clear and made [How to use Microsoft Power Query] a breeze to understand. Keep up the awesome work! 👍💯