I have never looked at power queries. I will definitely now have to check out more on this topic. I checked out this video because of your other one "Create Excel Pivot Table from Multiple Sheets: The Fastest Way". Thank you for sharing these.
Thank you so much for taking the time to do this. This has provided me with a starting point to build upon. You have made it so easy to understand. Thank you, Jamie.
Thank you so much for sharing your knowledge and expertise on Microsoft Excel through your UA-cam channel, Teachers Tech. Your lessons are clear and easy to follow, and have helped me to become more proficient in using this powerful tool. Keep up the great work and I look forward to learning more from you in the future!
Thank you so much. This video was so clear and beautifully simple in the explanation. I've really struggled with this and in such a short time you've made me understand so much. Thank you too for providing the data so that I could work along with you. That was super helpful. Great job you're doing. Thanks again.
This was a little slow in spots (truly beginner video), had super clear instructions, and I was able to pause to follow the instructions as it went along.
I have watched so many damn videos on power query, and pivot charts, and I've come a long way but your calm, "we'll take all day if we have to" approach helps it all sink in. I subscribed I'm so impressed! Can you or anyone in the comments please tell me or direct me on something? I'm a hotel bartender and since 2018 I've been tracking my credit card, room charge and cash tips, a sheet for each month and totals, etc. I've made a table for my input and and a table next to it for a number of calculations. My 2 days off each week are Zeros all across the sheets. Because of 52 weeks having all those Zeros, Excel can't recommend pivot charts or data analysis. How can I remove the days off for analytics purposes without removing the days off rows permanently? 2023s workbook my 2 days off will not be same as 2022, and plus it's November now, so I only have 1 month of Zeros left to deal with. In January I'll have a full year of Zeros. I'm sure there's content on YT but I don't know where. Meanwhile, I'm going to continue watching your videos. CHEERS!
Nice now I understand what’s the case for power query, or rather the benefit of doing so intended by Microsoft, compared to doing filtering and adding formulas DIRECTLY to the original data sheet, which is my preference till now. First it helps people who can’t use if else statements, or other excel formulas to ‘massage’ the data. Second, it help to split it into 3 layers, original data - transform - presentation, and I think this is the real case even if I know excel formulas, as it retain the original data structure to interface with other places when needed, eg inputs. That’s also mean if my original data structure changes, I need to update my transform layer too. It will be great if you could do a session on the real practical pros and cons of this power query compared to direct edit the data set 😅
thanks for this. One question, which I'm struggling to find the answer to in these videos, is how do i actually edit my power query? I know how to get to the power query editor, but it doesn't then seem to let me actually make edits?
I appreciate your work man, but to be honest I expected a good demonstration about power query importance and exclusive features, yet all there was (i think) is mostly functions you can apply in any table or no table.
Automatization and large database managing. For automatization; With Power Query once you have the M language written, which are the steps you do manually being written just like recording a macro, there's no need to do all of it over and over again, you just update the source file and refresh the query and the data will be arranged as you need it based on the steps that were written. For the large database portion; excel has a limit of rows a little over 1 million rows, so any database over that is not going to be loaded properly in the spreadsheet. With power query you can load that database into a pivot table cache and then just manipulate the data to see specific reports without having the 1M+ rows in your table.
I need to compare tables or workbooks for invoices from the tables and compare to a website portal for the companies that have a list/history if invoices to see which ones are missing, if any. More so to reconcile the invoices they have with the invoices recorded in company spreadsheets. What video can I look at to learn this? I would greatly appreciate it. Hopefully this is clear.
Powerquery seems really helpful in transforming data but I'm confused because can't all of this be done within Excel itself. For example, I can add columns, split things up by delimiter, and remove the time within just the Excel ribbon.
Hi Kevin I'm trying to combine 2 columns in the query to make a new column with year & numerical month. The formula is erroring out of course. I did the insert or year & insert of period but trying to put a dash separator.. thanks
hi mike . the date column when i take it to pq it shows as text where as in ur video it is showing as date type. when i convert to date type it shows errors why plz?😢
This tutorial is great, except it introduces too many transformations in a row one after another one, to the point that the viewer loses track of them and does not have any time to digest them. Introduce one transformation at a time and emphasize what you are going to to. This way you get the attention of the viewer. This tutorial is just a little bit too long.
Thanks!
Thank you so much 😊
recently i happened to take this free course, IT IS MARVELOUS, teaching cant be better than this ❤❤❤
I have never looked at power queries. I will definitely now have to check out more on this topic. I checked out this video because of your other one "Create Excel Pivot Table from Multiple Sheets: The Fastest Way". Thank you for sharing these.
Excellent video, explained it nice and calmly and could understand everything you were saying. Great Job!
Glad you enjoyed it!
Thank you so much for taking the time to do this. This has provided me with a starting point to build upon. You have made it so easy to understand. Thank you, Jamie.
You are very welcome!
@@TeachersTech Thank you. Just completed the Power Pivot one. Fantastic.
Yay, keep making these tutorials, I use them actively. More Excel tutorials too please, thank you!! You are amazing.
Thank you 🙏
I am mind-blown right now. I agree with Cheer about doing a video on the pros and cons. Thank you for your guidance.
You're so welcome!
This tutorial was awesome! I was able to follow along easily! Thank you so much!!!
Excellent video very informative yet very simplistic in delivery!
Thank you!
Excellent video that built in complexity and answered my questions about the basics. Thank you.
Glad it was helpful!
Thank you so much for sharing your knowledge and expertise on Microsoft Excel through your UA-cam channel, Teachers Tech. Your lessons are clear and easy to follow, and have helped me to become more proficient in using this powerful tool. Keep up the great work and I look forward to learning more from you in the future!
Thank you so much. This video was so clear and beautifully simple in the explanation. I've really struggled with this and in such a short time you've made me understand so much. Thank you too for providing the data so that I could work along with you. That was super helpful. Great job you're doing. Thanks again.
thank you , the tutorial is really clear and easy to understand and implement for the beginners!
You're very welcome!
Great crash course, thank you.
Great well presented tutorials. Learned so much. Thank you.
This is an Excellent video. Thank you so much.. appreciate your efforts..
You are most welcome
Nicely Done. very clear and articulate
yipeee. Thanks so much. I am intoxicated by this knowledge. On to the next video
Well done. Thank you for the instruction.
You’re welcome!
Super great tutorial for beginners. Thank you!
Excellent video, your video really helped me understand power query and apply it to my data. Thank you so much
Thank you. Great tutorial!
Amazing! one of the most satisfying things I love doing is learning new functionality in Excel. I dunno why my brain works that way!
So simple for starters! Thank you I enjoyed it!
Thank You so much, It is super useful for beginners
Thank you for the video, well detailed and easily understandable for a beginner.
This was a little slow in spots (truly beginner video), had super clear instructions, and I was able to pause to follow the instructions as it went along.
Very easy to keep up, my mind did not wander hardly at all
your presentation is inspiring. thank you.
I can see how this would have amazing application value to reports, SQL and more. Amazing video! I subscribed.
I have watched so many damn videos on power query, and pivot charts, and I've come a long way but your calm, "we'll take all day if we have to" approach helps it all sink in. I subscribed I'm so impressed! Can you or anyone in the comments please tell me or direct me on something? I'm a hotel bartender and since 2018 I've been tracking my credit card, room charge and cash tips, a sheet for each month and totals, etc. I've made a table for my input and and a table next to it for a number of calculations. My 2 days off each week are Zeros all across the sheets. Because of 52 weeks having all those Zeros, Excel can't recommend pivot charts or data analysis. How can I remove the days off for analytics purposes without removing the days off rows permanently? 2023s workbook my 2 days off will not be same as 2022, and plus it's November now, so I only have 1 month of Zeros left to deal with. In January I'll have a full year of Zeros. I'm sure there's content on YT but I don't know where. Meanwhile, I'm going to continue watching your videos. CHEERS!
Very well organized and presented! Thank you,
thank you for sharing your knowledge! More power to you Sir!
Nice now I understand what’s the case for power query, or rather the benefit of doing so intended by Microsoft, compared to doing filtering and adding formulas DIRECTLY to the original data sheet, which is my preference till now.
First it helps people who can’t use if else statements, or other excel formulas to ‘massage’ the data.
Second, it help to split it into 3 layers, original data - transform - presentation, and I think this is the real case even if I know excel formulas, as it retain the original data structure to interface with other places when needed, eg inputs. That’s also mean if my original data structure changes, I need to update my transform layer too.
It will be great if you could do a session on the real practical pros and cons of this power query compared to direct edit the data set 😅
That’s a great idea for a video! Thanks for the feedback.
That's a great tutorial. Thanks.
Glad you like it!
Thank you for showing this.
Wonderful tutorial! keep it up!
Very good! Ty. My organizations is too small for tableau and PowerBI. Hopefully, I can bring people into the PowerQuery methods.
Thank you, really well explained
Thanks for tutorial🎉
I learned a lot ❤
Excellent video
Nicely presented. Thanks❤
Hi you explain well I subscribe now
My God u r brilliant 😇genius
thank you very much sir
Nice job
thanks for this. One question, which I'm struggling to find the answer to in these videos, is how do i actually edit my power query?
I know how to get to the power query editor, but it doesn't then seem to let me actually make edits?
thank you so much
Hello!! Thank you so much for the tutorial :) The only thing is that I cannot access the practice file
I appreciate your work man, but to be honest I expected a good demonstration about power query importance and exclusive features, yet all there was (i think) is mostly functions you can apply in any table or no table.
Thanks for sharing this. Most of these functions seem native to excel; is there a reason to use power query instead of excel?
Automatization and large database managing.
For automatization; With Power Query once you have the M language written, which are the steps you do manually being written just like recording a macro, there's no need to do all of it over and over again, you just update the source file and refresh the query and the data will be arranged as you need it based on the steps that were written.
For the large database portion; excel has a limit of rows a little over 1 million rows, so any database over that is not going to be loaded properly in the spreadsheet. With power query you can load that database into a pivot table cache and then just manipulate the data to see specific reports without having the 1M+ rows in your table.
Do you have any resources on how to take a JSON file and transform it into table format?
I need to compare tables or workbooks for invoices from the tables and compare to a website portal for the companies that have a list/history if invoices to see which ones are missing, if any. More so to reconcile the invoices they have with the invoices recorded in company spreadsheets. What video can I look at to learn this? I would greatly appreciate it. Hopefully this is clear.
Powerquery seems really helpful in transforming data but I'm confused because can't all of this be done within Excel itself. For example, I can add columns, split things up by delimiter, and remove the time within just the Excel ribbon.
so, how can i follow along with your excel spreadsheet while watching your video?
thanks sir could u make video about power bi please
Would power query allow for using this data to create a single row for each salesperson name, with the rest of the data organized into columns?
Hi Kevin I'm trying to combine 2 columns in the query to make a new column with year & numerical month. The formula is erroring out of course. I did the insert or year & insert of period but trying to put a dash separator.. thanks
hi mike . the date column when i take it to pq it shows as text where as in ur video it is showing as date type. when i convert to date type it shows errors why plz?😢
all great but first I need to know how to install and use it, my 0365 does not have it ?
Is there a way to use Power query on Excel web version?
you can basically do everything that is shown just using excel... why is power query better?
Time saving
Ustaad power query hadhay
I can't download your file
There is no link to Sandy's Shoes data. There are only links to Super Bowl data.
There should be different tabs at the bottom to switch to Sandy's Shoes.
My formula is not working
I tried it using an ms excel 2010. 😓
36:48
This tutorial is great, except it introduces too many transformations in a row one after another one, to the point that the viewer loses track of them and does not have any time to digest them. Introduce one transformation at a time and emphasize what you are going to to. This way you get the attention of the viewer. This tutorial is just a little bit too long.
your video is not bright
36:47