Another top-notch video. Happy recommending your videos because they are consistently well-prepared, clearly presented and excellent for learning from.
This was great. I was just working on a project that needed to have data from multiple reports in one place. this video has really helped me understand what I need.
hey from morroco I wanted to express my sincerest gratitude for the amazing content you consistently share on your RUclips channel. Your videos have been a constant source of inspiration and entertainment for me, and I truly appreciate the effort and passion you put into each one. Thank you for creating such valuable and enjoyable content
Thank you sooo much!!! No one else I seen explained it or did it this way. A lot of people say to import from a folder, but that way runs into so many errors and then it puts each table on a different sheet. So thank you very much!!
No way. I was watching your another video about Pivot Table. And you didn't mention anything about multiple sheets. So I ended up Google it. But boom you just posted a video 35 mins ago. Thank you!
I think of myself as pretty good with pivot tables, but I've never used Power Query to combine source data before, so it's good to learn something new.
This is pretty cool way to import large chunks of data. It appears you do the query on the same workbook. I wouldn't think it would allow you do that since you're essentially loading a workbook while it's open. I tried this on my data and had to close the workbook to get it to work.
Great video! Relationships in Excel could make a lot of database use obsolete. Is there any practical size limit, beyond which using a database for the raw data would be more robust? I currently use Access database for this kind of work and it's been rock solid-my basic approach is Access for data, Excel for analysis and presentation.
I have the same approach. I guess it is also about what the data is (numbers or text) and how much data must be related. If it requires calculations I try to use Excel for the numbers. But printed reports are much easier made in Access. But I am also curious when to use what.
Power Query can handle large amounts of data, more so than you're able to load into an Excel sheet. Excel maxes out at a little over a million rows. I also used to use Access back in the day when I analyzed millions of rows of data, but this provides an alternative if you're comfortable using Excel.
Kevin, hello! First of all, let me thanks you for your lessons, they are great and useful. I'd like to ask you about how to connect several tables with different data into one pivot? In this lesson you used the tables with the similar headers, but what if my tables have different data and different quantity of columns? I have a timesheet tables of workers (one month in one table). The common between my tables is the names of workers and the project names, but none of them are the same each month.
You can rename the column header before append the query. It will match according to column name, so do not need the worry two tables have different quantity of columns. E.g this platform ABC may use the column header as OrderID, the platform XYZ is Order Number. You just need to rename Order Number to OrderID will do.
I love your tutorials, very well explained and easy to comprehend. I would like to know, which version of Microsoft excel are you using for illustrations. Thank You.
Hi Kevin, thank you for this awesome tutorial. However, I have a question. As a best practice, it is advisable to convert our data to a table before building out a PivotTable to support a growing dataset. So, my question is do we have to convert the datasets to tables before exporting to Power Query for consolidation?
Thank you so much for the very useful tips, right in time for my massive report. However, can I know if we can keep adding tabs/ sheet to the current append data? It looks like I have to rerun the append process in order to add new sheet. Thank you.
Awesome!! Please if you want to capitalize an already typed data in a sheet what is the shortcut in excel (I'm finding that tedious) Thank you for the sample workbooks too
This is a great educational tool. The issue is that version 2016 menus are completely different with some options not available. I am also so new to Excel that I could be lost.
Hi Kevin, this video has been incredibly useful. Just one question ... when I pull in the data into the main pivot table it always rounds the numbers up or down. Is there anyway to leave the numbers unrounded? I've tried formatting the pivot table to to decimal figures but it just seems that the numbers it pulls in have already been rounded. Thanks for your great work 🙂
![Visual Calculations in Power BI - DAX Made Easy! [Full Course]](http://i.ytimg.com/vi/JITM2iW2uLQ/mqdefault.jpg)
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
😊
Best excel presenter on RUclips. Thanks Kevin
By far the easiest tutorial on making pivot table from multiple sheets in excel. Thank you.
One of the best tutorials I have ever watched. Thanks for supplying the source material so that we could follow along.
VERY NICE & INFORMATIVE - EXCELLENT PRESENTATION TO EASY TO UNDERSTAND
Another top-notch video. Happy recommending your videos because they are consistently well-prepared, clearly presented and excellent for learning from.
This was great. I was just working on a project that needed to have data from multiple reports in one place. this video has really helped me understand what I need.
The easiest tutorial ever. Thank you so much. It's seemed so daunting and now it's not!!!! I did it
Best excel tutorial channel I’ve ever seen. Thank you!
I have no use for a pivot table at the present, it's good to have this available for future use. As always Kevin valuable information. Thanks Kevin.
It's one of the best / easiest to use analysis tools. It's a good one to have in your toolbelt.
hey from morroco I wanted to express my sincerest gratitude for the amazing content you consistently share on your RUclips channel. Your videos have been a constant source of inspiration and entertainment for me, and I truly appreciate the effort and passion you put into each one. Thank you for creating such valuable and enjoyable content
Always my best option when ever it comes to office products thank you sir. Much appreciated
big round of applause for you boss! learned tons of knowledge from you, thank you.
Thank you sooo much!!! No one else I seen explained it or did it this way. A lot of people say to import from a folder, but that way runs into so many errors and then it puts each table on a different sheet. So thank you very much!!
Thanks Kevin.
The carefully chosen selection of datasets was very helpful and made learning the steps self explanatory and motivating. Excellent work.
Thanks Kevin for sharing best excel content
Simply amazing and powerful tools in MS Excel. Great video, Kevin.
Great Kevin,
A very common need with very good and clear explanation.
It will help a lot.
OH! This is like you read my mind. I totally need this for my work! Thanks Kevin!
That was an amazing video, I learned so much in such a short time and was able to immediately put it to use. Thank you!
Awesome tutorial - you've saved me so time and effort. This is like pivoting on steroids!
Just created a report for my client. Thank you so much
No way. I was watching your another video about Pivot Table. And you didn't mention anything about multiple sheets. So I ended up Google it. But boom you just posted a video 35 mins ago.
Thank you!
Thank you so much Kevin. I think the KevinCookieCompany has more to offer us. Delicious cookies and great MS Excel content.
I have so much work to do now! 😀Thank you!!!
hopefully it makes all that work easier 😉
i am impressed the way you are teaching is amazing
wow wow wow , god only knows how much time you saved for me from this video , big heart for you kevin
Perfect you may make it soo easy thank you very much😊
It's absolutely amazing 🤩, thank you Kevin for the valuable content
Can't thank u enough for this 😊
Brilliant - Thanks
Hello "Kevin Stratvert"! Thank you for showing us such a wonderful video! I feel so happy! I'm looking forward to your next work! Have a nice day!
thanks!
Thank you so much! God bless you❤❤❤!!
Another fantastic video where it was clear explanations and examples! Thanks!
Great presentation Kevin.
Thanks.
Awesome work 👍 12:08
OMG Thank you. Learned something new that will help me meet a goal by end of week.
Great tutorial
thanks!
Great video sir. Thank you
what a beautiful explanation...you are not quick in ur explanation that makes it very easy to understand....
thank you very much. This has been such a huge help and made my work super convenient and easier. :)
Thank u Kevin
Thank you, this will be very helped
Very well put together and easy to follow, thank you
I think of myself as pretty good with pivot tables, but I've never used Power Query to combine source data before, so it's good to learn something new.
Great! i guess it is what i really needed lesson. Thank you Kevin .
Thank you Kevin, you are an excellent tutor
more than great
Thanks 🙏
Can't thank you more Kevin.
Kevin, this is just fabulous....keep it coming
Thank you
TOP SHELF THANK YOU! SAVED MY DAY 🙂
This was very good content especially the relationships feature which I haven't seen discussed much in similar channels
it's getting close to database territory 😯
This is great stuff! I'm going to try this out with my end of year data!
You explained it so well. Thank you so much Kevin!
Exactly what I was looking for.
Thank you!
Kavin! You are saiving my life!
Thank you so much!! Great video
Great Video! Thank you very much!
I was looking for this for a while. Thanks
This is perfection. Thank you.
This is pretty cool way to import large chunks of data. It appears you do the query on the same workbook. I wouldn't think it would allow you do that since you're essentially loading a workbook while it's open. I tried this on my data and had to close the workbook to get it to work.
Make sure one drive is turned off! I had to turn my off to get rid of that error! It needs to be saved locally and not on a cloud.
Great video! Relationships in Excel could make a lot of database use obsolete.
Is there any practical size limit, beyond which using a database for the raw data would be more robust? I currently use Access database for this kind of work and it's been rock solid-my basic approach is Access for data, Excel for analysis and presentation.
I have the same approach. I guess it is also about what the data is (numbers or text) and how much data must be related. If it requires calculations I try to use Excel for the numbers. But printed reports are much easier made in Access. But I am also curious when to use what.
Power Query can handle large amounts of data, more so than you're able to load into an Excel sheet. Excel maxes out at a little over a million rows. I also used to use Access back in the day when I analyzed millions of rows of data, but this provides an alternative if you're comfortable using Excel.
Thank you so much ❤
thanks
of course!
@@KevinStratvert its an honor to share it with us, thank you so much for this very informative and intelligently presented discussion......
You rock Kevin!!❤
Thanks Kelvin, this is very helpful
This is awesome! Thank YOU Kevin!
Kevin, hello! First of all, let me thanks you for your lessons, they are great and useful. I'd like to ask you about how to connect several tables with different data into one pivot? In this lesson you used the tables with the similar headers, but what if my tables have different data and different quantity of columns? I have a timesheet tables of workers (one month in one table). The common between my tables is the names of workers and the project names, but none of them are the same each month.
You can rename the column header before append the query. It will match according to column name, so do not need the worry two tables have different quantity of columns.
E.g this platform ABC may use the column header as OrderID, the platform XYZ is Order Number. You just need to rename Order Number to OrderID will do.
Thank you for the video. It's really helpful for me
God bless you sir
Nice
Very Informative. Thanks for the valuable tutorial.
💗
I love your tutorials, very well explained and easy to comprehend. I would like to know, which version of Microsoft excel are you using for illustrations. Thank You.
You are so amazing! Thank you so much!
Hi Kevin, thank you for this awesome tutorial. However, I have a question. As a best practice, it is advisable to convert our data to a table before building out a PivotTable to support a growing dataset. So, my question is do we have to convert the datasets to tables before exporting to Power Query for consolidation?
This is exactly what I have been looking for and such a great lesson. Thank you so much Kevin!
Thanks a lot! Really helpful 👏
Many thanks Kevin
Real heros don't wear capes ❤
This is just so cool!
Cannot thank you enough!👏
Great - as always! Thanks a stack, Kevin!
❤ amazing 😍
Are you able to use this method to consolidate the P&L for two different entities?
Could you do the same for Google sheets
On my list!
@@KevinStratvert thanks !
Thank you so much for the very useful tips, right in time for my massive report.
However, can I know if we can keep adding tabs/ sheet to the current append data? It looks like I have to rerun the append process in order to add new sheet. Thank you.
Do the column headers on the various data sources have to be in the same order on each sheet?
Awesome!!
Please if you want to capitalize an already typed data in a sheet what is the shortcut in excel (I'm finding that tedious)
Thank you for the sample workbooks too
Wow.. that was Gooooooooooooooooooood
amazing video content, it really help, thanks Kevin
You’re awesome.
This is a great educational tool. The issue is that version 2016 menus are completely different with some options not available. I am also so new to Excel that I could be lost.
Awesome.
Amazing tutorial. Next up, how to calculate between two columns in a power pivot
Can I use Power Query to combine monthly sales from different workbooks with different column headers?
Thank you
thank you so much
If you have a formula in use in your sheet will it carry over in power query or load the spreadsheet without the formula?
Hi Kevin, this video has been incredibly useful. Just one question ... when I pull in the data into the main pivot table it always rounds the numbers up or down. Is there anyway to leave the numbers unrounded? I've tried formatting the pivot table to to decimal figures but it just seems that the numbers it pulls in have already been rounded. Thanks for your great work 🙂
Oh, Kevin!