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 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!
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
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😊
THankyou Kenji for such a wornderful video about power Query. This is my first time getting familier with power query, I was very afraid before this. Thanks for explaining. If you are on linkedin I would like to follow you there as well.
Great course. The excercise folder came with all 4 retailers, I pulled the walmart out, got the results in the video then added the walmart in the folder. However i was not able to refresh the data the way you did in the video
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 !
Hi Kenji, Thank you for this awesome video. Would this work if the excel books have data that have different column names? For example, student test results where the class names have changed over years. Cheers!!!
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!
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!
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
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.
Please Kenji, which version of office did you use for this video? The option of 'subtract days' at 3:36 is not available on Excel Power Query 2019. How do I use that function in Excel 2019?
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
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?
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, 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
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.
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..
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 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...
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
Yeah they're driving me crazy too. So distracting I stopped watching the video to make a comment. It might not be so bad if it wasn't so loud it covers up your voice explaining things.
🔥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
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!
Best powerquery tutorial so far!
It is incredible that an almost 14 years old feature surprises the people
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!
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 :)
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❤❤
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.
Respect brother, the way you teach is a next level brother, Keep rising.
Good video, thank you. IMO the random "siuuu!"'s are abit weird and unnecessary
I enjoyed this video. Perfect clarity and happy you snuck PowerBI in there as I learned the same steps in PowerBI too.
Kenji , So good explanation -Comprehensive, quick and clear . Thanks a lot !
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😊
THankyou Kenji for such a wornderful video about power Query. This is my first time getting familier with power query, I was very afraid before this. Thanks for explaining.
If you are on linkedin I would like to follow you there as well.
Great course. The excercise folder came with all 4 retailers, I pulled the walmart out, got the results in the video then added the walmart in the folder. However i was not able to refresh the data the way you did in the video
Amazing sir! You have been helping me a lot. God Bless You
Wooow...am sold out. Love you and the contents😅
Oh man, i was adding excel file 1 by 1 from the same folder. Thanks this saves 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 !
SIUUU at 2:04 already made my day and it's not even 10am!
😂😂😂 glad you noticed 😂
Kenji, great explanation. Thanks! 👍👍👍
It was very informative. I learnt from it. Thank you
Help a lot. Could you please do another one which is for multiple tabs within one worksheet. Thanks.
Thank you this is great. Do we need to convert the data into the table first? Thanks
Best teacher ever
My Gosh dude! Thanks for simplifying such a horrendous topic. Kudos for all your hard work!
Glad you liked it!
always waiting for your videos....you make everything so simple
KENJI IS AMAZING, Thanks a lot.
Kenji you are great
Thank you very much Kenji for this amazing tutorial.
Hi Kenji, Thank you for this awesome video. Would this work if the excel books have data that have different column names? For example, student test results where the class names have changed over years. Cheers!!!
Thanks man! I needed a refresher on this :)
Very nice video mem. Little little🤏 things are covered😊
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!
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 man the lesson was amazing
Refresh all is my favourite button in Excel 😄
Excellent tips, thank you very much! Congratulations!
Thank you so much for making great contents.
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
Hi Sir, Could you please provide the retailer's data sets to practice what you've taught?
thanks for this don't know power query existed
Yeah it's great!
I like the video and it is useful the emotes are just annoying though tbh.
Thank you for another excellent tutorial.
your videos are amazing, and very helpful. keep doing what you do
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!
Thank you, great tutorial.
GREAT WORK TO EASE OUT
Hi Kenji, can I know how to sum up the row?
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
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.
@kenji mate, before merging the file you want to check the columns are same as the other files because those never are 😅
Great video but I didn't get the "from folder' option in excel in my Mac
Thanks a lot for your fantasic video.
What are tools using to create your videos ??
Please Kenji, which version of office did you use for this video? The option of 'subtract days' at 3:36 is not available on Excel Power Query 2019. How do I use that function in Excel 2019?
do you have a vod of customizing excel from start (how it comes) to finish (all addons/hidden)?
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
Great explanation cheers!
You are genius 👏
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
Please can you also do this tutorial with Google sheets 🙏
What about non linear line data , like a form,
Thanks for this. ❤️😇😊
You're welcome 😊
How do you make an enter as the deliminator?
Is there a way to link power bi data report to exceel?
So It can be flexible to add and change with live data.
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, 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
Very clear ❤
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.
It's possible pas from data Excel to a web automatic? Eny program can do it?, I need for many data in excel.
Helpful, thanks!
where you will save the new file? is it in the same folder where the 3 folder saved?
Are your trainings available on Udemy?
From the days to payment, how to remove weekends?
Thanks man!
I didn't see add column, How can i add Date in Excel Sheet? Thanks.
Does power query have size limitation?
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..
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!
thank you so much
Please help! My get and transform online only allows to get data from pictures. How can I fix it?
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...
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
nice & Thank you
how to combine multiple workbooks in mac?
Why doesn’t currency format carry over into loaded spreadsheet?
Thank you sir...
Thanks
in my MacBook "combine" option is not showing
You're the besttt
my data headers did not load into excel after transform and load
the popups and sounds are a bit overused and weird, and definitely not necessary. otherwise 10/10 tutorial
thanks for the feedback :)
I loved the pop ups 😂 Kept me awake 🤣
@@KenjiExplainsdon’t change the pop ups, whenever I would stop paying attention I would just hear “Siuuuu” and I’d lock back in. Also they’re funny
Yeah they're driving me crazy too. So distracting I stopped watching the video to make a comment. It might not be so bad if it wasn't so loud it covers up your voice explaining things.
how will i create a template to power query
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?