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.
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.
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 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.
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 😅
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.
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.
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
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.
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.
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.
This tutorial was awesome! I was able to follow along easily! Thank you so much!!!
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.
recently i happened to take this free course, IT IS MARVELOUS, teaching cant be better than this ❤❤❤
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!
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 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.
Excellent video that built in complexity and answered my questions about the basics. Thank you.
Glad it was helpful!
Excellent video, explained it nice and calmly and could understand everything you were saying. Great Job!
Glad you enjoyed it!
thank you , the tutorial is really clear and easy to understand and implement for the beginners!
You're very welcome!
Excellent video, your video really helped me understand power query and apply it to my data. Thank you so much
Yay, keep making these tutorials, I use them actively. More Excel tutorials too please, thank you!! You are amazing.
Thank you 🙏
So simple for starters! Thank you I enjoyed it!
Very easy to keep up, my mind did not wander hardly at all
Super great tutorial for beginners. Thank you!
Excellent video very informative yet very simplistic in delivery!
Thank you!
Thank you. Great tutorial!
Great well presented tutorials. Learned so much. Thank you.
Amazing! one of the most satisfying things I love doing is learning new functionality in Excel. I dunno why my brain works that way!
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!
Well done. Thank you for the instruction.
You’re welcome!
Thank you for the video, well detailed and easily understandable for a beginner.
Great crash course, thank you.
Very good! Ty. My organizations is too small for tableau and PowerBI. Hopefully, I can bring people into the PowerQuery methods.
Nicely Done. very clear and articulate
yipeee. Thanks so much. I am intoxicated by this knowledge. On to the next video
I can see how this would have amazing application value to reports, SQL and more. Amazing video! I subscribed.
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.
Thanks for tutorial🎉
I learned a lot ❤
Thank you, really well explained
your presentation is inspiring. thank you.
Great, thank you!!!!
Hello!! Thank you so much for the tutorial :) The only thing is that I cannot access the practice file
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.
Wonderful tutorial! keep it up!
thank you very much sir
That's a great tutorial. Thanks.
Glad you like it!
Very well organized and presented! Thank you,
thank you for sharing your knowledge! More power to you Sir!
Thank you for showing this.
Thanks!
Thank you so much 😊
thank you so much
My God u r brilliant 😇genius
Nice job
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.
thanks sir could u make video about power bi please
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.
Nicely presented. Thanks❤
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
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.
all great but first I need to know how to install and use it, my 0365 does not have it ?
so, how can i follow along with your excel spreadsheet while watching your video?
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?
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?
My formula is not working
36:47
I can't download your file
I tried it using an ms excel 2010. 😓
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.
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.
36:48