Learn Excel Power Query to Automate Boring Tasks
ฝัง
- เผยแพร่เมื่อ 30 ก.ค. 2024
- Learn Power Query in just 10 minutes to merge multiples Excel files, clean up data, and analyse it.
🔥Take our Power BI for Business Analytics course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: view.flodesk.com/pages/643016...
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
PowerQuery is one of the most powerful tools that you can use for Excel and Power BI. In this tutorial, we teach you how to use it from scratch. First, we learn how to import multiple excel files into one for further analysis. Then, we learn how to clean up data in Power Query which is much faster than Excel. Finally, once the data is clean up, we upload it onto excel for further analysis using Pivot Tables. We also see how adding new data affects the analysis.
SOCIALS:
🎬 My Company TH-cam Channel: / @careerprinciples
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Intro
0:22 - Combining Multiple Excel Files
2:08 - Cleaning up the Data
6:28 - Analysing the Data with Pivot Tables
7:25 - Adding more Data
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.
🔥Take our Power BI for Business Analytics course: www.careerprinciples.com/courses/power-bi-for-business-analytics
Do you know sql?
Mate , yes this is a game changer for financial analyst. You are doing great work for the community , sharing knowledge. Well done. God bless.
Thank you for your message I appreciate you!
The quick file add and data refresh is a game changer!
Yes sir!
What’s the different between power query and power BI?
@@sallyho146power query is a data cleaning tool. It’s available in both Excel and Power BI
I can't thank you enough for how useful your quick videos are and the practice files that are included. So helpful to get the hands on example to follow along. Plan to take the Power BI course from you too. Thanks again!
Kenji , So good explanation -Comprehensive, quick and clear . Thanks a lot !
Thank you so much for making great contents. I have always enjoyed watching your videos and they are very helpful especially when it's comes to my job as an accountant. 90% of my job that involves Excel i can find on your channel and I am super grateful to you. Keep up the good work !
Awesome! I'll try to implement this for our monthly reports! Currently all the data pasting is done manually, so power query could be a game changer! Thanks alot😊
I enjoyed this video. Perfect clarity and happy you snuck PowerBI in there as I learned the same steps in PowerBI too.
aight I needed to learn power query for the first time today bcs I gotta teach my students tomorrow about it, and this video helps a lot in giving the overview and the how-to's in the topic. thanks a lot Kenji!
Hii, Kenji I have been watching your financial modelling videos lately and loveing your videos, but please make a detailed video on how to take accurate assumptions in modelling, like which source etc
Thumbs up for the immediate, clear, concise use case description and getting down to it. Alignment is sexy.
Hahaha I appreciate your comment! Thanks for watching :)
Really wish I would of seen this earlier. Would have saved me from merging 27 excel files. This is awesome. Thank you so much. Subscribed.
Best powerquery tutorial so far!
Excellent tips, thank you very much! Congratulations!
Thank you very much Kenji for this amazing tutorial.
your videos are amazing, and very helpful. keep doing what you do
always waiting for your videos....you make everything so simple
Kenji, great explanation. Thanks! 👍👍👍
Thank you for another excellent tutorial.
It was very informative. I learnt from it. Thank you
Amazing sir! You have been helping me a lot. God Bless You
Great explanation cheers!
Thanks man! I needed a refresher on this :)
Thank you this is great. Do we need to convert the data into the table first? Thanks
Thank you, great tutorial.
Will removing the table columns like you did in the beginning would transform the original file? Or is that exporting the file (almost like making a copy) of the original data?
Oh man, i was adding excel file 1 by 1 from the same folder. Thanks this saves a lot
KENJI IS AMAZING, Thanks a lot.
Helpful, thanks!
Thank you so much for making great contents.
Respect brother, the way you teach is a next level brother, Keep rising.
Kenji you are great
Hi Sir, Could you please provide the retailer's data sets to practice what you've taught?
do you have a vod of customizing excel from start (how it comes) to finish (all addons/hidden)?
Thanks a lot for your fantasic video.
Useful. Thank you.
Such a Pure Class Explanation you deliver ...whenever I get stuck in any tool I jzt google your channel ...Hoping SQL Videos
Love From India❤❤
This sets me apart from the "breed" as a financial management specialist, as well as other individuals working in the finance field (but not only). Great presentation and fantastic work, keep it up!
Thank you very much
GREAT WORK TO EASE OUT
Thanks man the lesson was amazing
Interestingly enough, my version of Excel doesn't have the "Extract" feature shown at that location! I am on the latest version from Office 365, has the feature moved? What version of Excel are you running and how can I find the new location? (Thanks in advance for your help, and for this awesome video.
Best teacher ever
Thanks man!
thank you so much
My Gosh dude! Thanks for simplifying such a horrendous topic. Kudos for all your hard work!
Glad you liked it!
Thank you sir...
Thanks
You are genius 👏
Mind blowing video from Kenji. I still wonder while practising. In excel data provided by my friend I can see only few tabs ( no hidden tabs) but when I try loading to power query there are many sheets available in front of me. What is that!
Very clear ❤
nice & Thank you
Hello kenji... whats the point to put currency on power query when close and load currency doesn't appear, so i need to put the currency again. Why? see you also have the same result. So what's the point putting the currency on power query if you need to put it again.
Very nice video mem. Little little🤏 things are covered😊
Thanks for this. ❤️😇😊
You're welcome 😊
Is there a way to link power bi data report to exceel?
So It can be flexible to add and change with live data.
thanks for this don't know power query existed
Yeah it's great!
It is incredible that an almost 14 years old feature surprises the people
SIUUU at 2:04 already made my day and it's not even 10am!
😂😂😂 glad you noticed 😂
Hello Kenji, I like your Excel tutorials.
I'm wondering if you also use and/or teach SQL?
Would be absolutely wonderful. He makes it all look so easy
Thank you! I'll keep it in mind for future videos!
You're the besttt
Does this only work if the excel files have the exact same table structures
My data has same some number of data rows in both files...how to remove these duplicates. I actually did this in macro code but is there a way in power query
Hi, i like the way of your teaching, its amazing, i like to know do you also offer more advance course, where we receive/ or retrieve automatically data on daily basis and automate it in dashboard without human interaction including auto refresh. please guide or make any video on this. thanks
i forget to mention, means in Power BI
It's possible pas from data Excel to a web automatic? Eny program can do it?, I need for many data in excel.
Sir is that possible to combine multiple worksheets from multiple workbooks into one sheet..for example i have 10 workbooks in these 10 workbook have 5 worksheet, i want to combine all to 1 worksheet only..they all have same header..
What are tools using to create your videos ??
Hi Kenji, can I know how to sum up the row?
Hi @KenjiExplains , Would you be kind to quickly guide me with this simple query: I have a Monthly report master sheet where the data is combined from multiple data report sheets in use of PQuery. The Master sheet columns started with Name of Staff, Prepared Dates, Number of prepared Documents, and location source of document. I want to extract specific columns and data from the master sheet and create a separate sheet table. I only want column of Prepared Dates, and Number of of Documents The number of Document column must be the total value or sum of figures for the same prepared date. The date sum value will auto update (no need to refresh) once the master sheet is updated with additional figures of prepared dates. Thanks for the help. - Jay
super
Please help! My get and transform online only allows to get data from pictures. How can I fix it?
Does power query have size limitation?
This is great, but next cycle comes around and you'll need to compile and clean the data again. Is there a way to simply load the data (from same format) and apply the transformation steps previously used to automatically to streamline the output?
Look up how to copy the query from one excel file to another
Hi I tried to use power query but my data base has more than 256 columns and power query doesnt' bring the rest columns. what should I do?
i have a problem in PQ in Excel (2019 v)...
data preview tab in power query at excel shows only two options ( whitespace - monospacced )
how i show column quality option ?
all the best...
hey, Kenji This is one of your big fans. I have some problem after the multiply it shows the minus sign before the number how can I remove the minus sign. Thank you in Advance
The header should be the same in all the files in the source file prior to the append or merge process in the power query
Refresh all is my favourite button in Excel 😄
I like the video and it is useful the emotes are just annoying though tbh.
Are your trainings available on Udemy?
How do you make an enter as the deliminator?
Why doesn’t currency format carry over into loaded spreadsheet?
Please can you also do this tutorial with Google sheets 🙏
how will i create a template to power query
I didn't see add column, How can i add Date in Excel Sheet? Thanks.
how to combine multiple workbooks in mac?
I have a question: if all three files from one folder have different number of columns with different order, can we merge the files side by side? One under another doesn't work for us.
Nope. Unless you have order of columns, structure of columns same in all, it won't work
my data headers did not load into excel after transform and load
Great video! But can you please remove the noise (not sure if it's some kind of music?) from the background? Can we just concentrate on listening your explanation without distraction? Thank you!
the popups and sounds are a bit overused and weird, and definitely not necessary. otherwise 10/10 tutorial
thanks for the feedback :)
I love the Suuuuiiiii 🐐 ❤😂😂
Hahaha glad you noticed!
Excellent information. Please get rid of the pop-up graphic "SIUUU!" -- so distracting that I was jarred out of my concentration.
CANT =='T FIND COMBINED AND TRANFORM
May I ask any queries relate to our topics ? On dm
Hey I don't check DMs often sorry. Best way to reach me is here!
Thank you
Its really worth to see your all videos and easy to learn from you.
But As a fresher, how should one start any course, and from where?
Will you able to give guides in brief?
like for that SIUUUUU
Siuuuuu....😂😅
😂😂😂 appreciate you noticing haha
@@KenjiExplains 🙏😁
Don't do the "Siuuuu" thing... seriously.
Why not lol
Please do that
I am a Messi fan tho
Hahah I am too! (I'm born in Barcelona)
Now you're a messi fan, a culer also I guess, ill watch all your videos 👍😄
the guys too chill - creeps me out!!!!!!!!!!!!!!!
Stop the siuuuu it’s irritating
Nothing special