Learn Excel Power Query to Automate Boring Tasks
HTML-код
- Опубликовано: 24 июл 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 RUclips 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?
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!
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😊
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 !
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!
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!
I enjoyed this video. Perfect clarity and happy you snuck PowerBI in there as I learned the same steps in PowerBI too.
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.
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 :)
Excellent tips, thank you very much! Congratulations!
Thank you very much Kenji for this amazing tutorial.
always waiting for your videos....you make everything so simple
Best powerquery tutorial so far!
your videos are amazing, and very helpful. keep doing what you do
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
Kenji, great explanation. Thanks! 👍👍👍
Amazing sir! You have been helping me a lot. God Bless You
It was very informative. I learnt from it. Thank you
Thank you for another excellent tutorial.
Thank you this is great. Do we need to convert the data into the table first? Thanks
Thanks man the lesson was amazing
Oh man, i was adding excel file 1 by 1 from the same folder. Thanks this saves a lot
Great explanation cheers!
Thank you, great tutorial.
Respect brother, the way you teach is a next level brother, Keep rising.
Thank you so much for making great contents.
Helpful, thanks!
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❤❤
KENJI IS AMAZING, Thanks a lot.
Thanks man!
Kenji you are great
do you have a vod of customizing excel from start (how it comes) to finish (all addons/hidden)?
Very clear ❤
My Gosh dude! Thanks for simplifying such a horrendous topic. Kudos for all your hard work!
Glad you liked it!
Useful. Thank you.
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?
Hi Sir, Could you please provide the retailer's data sets to practice what you've taught?
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!
GREAT WORK TO EASE OUT
Best teacher ever
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!
Thanks a lot for your fantasic video.
Thank you very much
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.
Very nice video mem. Little little🤏 things are covered😊
thank you so much
You are genius 👏
nice & Thank you
Thank you sir...
You're the besttt
SIUUU at 2:04 already made my day and it's not even 10am!
😂😂😂 glad you noticed 😂
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. ❤️😇😊
You're welcome 😊
Hi Kenji, can I know how to sum up the row?
Thanks
thanks for this don't know power query existed
Yeah it's great!
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.
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!
What are tools using to create your videos ??
Does this only work if the excel files have the exact same table structures
It is incredible that an almost 14 years old feature surprises the people
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..
How do you make an enter as the deliminator?
Does power query have size limitation?
Refresh all is my favourite button in Excel 😄
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
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
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
I like the video and it is useful the emotes are just annoying though tbh.
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
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
super
Please help! My get and transform online only allows to get data from pictures. How can I fix it?
how to combine multiple workbooks in mac?
how will i create a template to power query
Please can you also do this tutorial with Google sheets 🙏
Why doesn’t currency format carry over into loaded spreadsheet?
Are your trainings available on Udemy?
I didn't see add column, How can i add Date in Excel Sheet? Thanks.
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...
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?
my data headers did not load into excel after transform and load
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
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!
I love the Suuuuiiiii 🐐 ❤😂😂
Hahaha glad you noticed!
CANT =='T FIND COMBINED AND TRANFORM
Excellent information. Please get rid of the pop-up graphic "SIUUU!" -- so distracting that I was jarred out of my concentration.
the popups and sounds are a bit overused and weird, and definitely not necessary. otherwise 10/10 tutorial
thanks for the feedback :)
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 🙏😁
the guys too chill - creeps me out!!!!!!!!!!!!!!!
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 👍😄
Nothing special
Stop the siuuuu it’s irritating
Silly sound fx are so annoying and distracting, had to turn it off. Grow up