π₯ Learn Excel in just 2 hours: https://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: https://1drv.ms/u/s!AmxrofZZlZ-whKZQTEiA4iLu-WPiaQ?e=AkAtOi
– Download Power Query for Excel 2010 or 2013: https://www.microsoft.com/en-au/download/details.aspx?id=39379
β 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: https://youtu.be/m0wI61ahfLc
– Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
– Power BI: https://www.youtube.com/playlist?list=PLlKpQrBME6xIAUqcPjFRPsMQJhgXdJVxe
π© Connect with me on social:
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
π Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
π¬ Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
π Support me with your Amazon purchases: https://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.
source
Comments
βοΈ Watch next – playlist with all my free tutorial videos on how to use Excel: https://youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
π© Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
π« Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
what a great video to boos my productivity, Thanks Sr. Kevin for sharing with us your advice
Hi Kevin i have fews question to ask. I hope you reading my comment.
q1. example column name station but got some information is empty. should i name empty as "null"?
q2. or I should remove "NA"? i usually easy to done this in r programming but not sure about excel.
q3. how to remove duplicate?
Hey thank you for wonderful yt channel. I've learn so many tips from you!!
hello, just bumped into this and man you saved me big time, can i get the work resources, kindly.
This is FIREE!!!!πβ€
great β€. Such a handy video
I would love to see a demo on actual PowerBI in the same tone as this amazing vid. Thank you so much! Would you be able to answer a question?? thanks!
You are the best in this game
When I press Close and Load,
It is taking me to excel, BUT, I am getting the following error – βExternalData_1β
does anyone have an idea as to how to deal with this ?
Thank you for this simple, yet comprehensive tutorial for power query. Much easier to understand than the other guides I have tried.
That power query folder auto update is a bomb !!
Sir do you have a full playlist of sql or power bi or python where you teach all the topics from them? I really like your way of teaching
Simple, Clear, Straight to the Point & Awesome.
thanks prof
Great Videos.π
Very nice tutorial. My question is: When you added the 2020 sheet, all transformations you made on 2017, 2018, 2019 data was automatically applied. How would this happen if I am using Power BI??
Very well explained
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!
This content is really useful. I would use this channel more if Kevin stopped employing the 'standard youtuber narrative inflection'.
Awesome video. Thanks so much!
This is amazing….. & you are a legend for all beginers like me. Thank you.
Great and awsome
Fantastic video. Thank you
Video is very interested and easy to absorb Thanks a lot
Do you have any tutorials on writing M Code in Power Query?
I love this Alot Thank you so much.
Great and straight to the point tutorial!
My only question is, how the new data (year in this case) loads in our Power Query? is it all automatically and we just refresh it? or do we have to do something extra to load it along with our previous data?
Thanks and Kudos!!
love it!! game change!! many thanks Kevin!
You should do your next example on selling pants instead of cookies. I'd like to know how many days it takes to ship my pants.
Thank you
Thanks, friend.
Hi Kevin, how to get rid of scientific format when transforming data. I am importing data from CSV file
Kevin you are a legend
No notes, I love you Kevin
Thank you so much for tutorials.
Thanks.
wow nice explanation, basic intro for power query. for me, power query main function is maked data clean.
Hi Kevin! Is it possible to have the edits made to different workbooks without combining them? I get data that updates weekly and they need to stay as separate files.
Just Amazing teacher ..
Hi Kevin, a sincere thank you to you!
Really love this video but can't see the file you work with
Awesome explanation π
Can this work if you don't have multiple files? I run daily reports that get added to the yearly file. But the daily file's name is the same, and I just replace the previous days data with the updated. Also I merge say file A and file B information together some using Vlookups and this creates my final file C.
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!