A heck of approach to teaching. Easy to understand human voice, and organized manner in presenting what it matters. Bob clearly understand the principle of "Less Is More" and more importantly, how to use this value-add principle effectively. Thank you for taking the time to do this right. - God bless.
Exactly what I have been looking for in pivot table. Why haven't I known this earlier! I used to consolidate into one sheet for this job. Thank you very much.
That is very helpful especially for tables needing different sheets to look easy on the eyes instead of putting every columns in one single table. Thanks for sharing!
Omg thank you, I’m trying to update our inventory in quickbooks without hand entering each line item and I couldn’t figure out how to combine data. This is going to make life so much easier
Excellent tutorial thank you. I have a specific question a little different from your scenario. I have multiple sheets (lets say different accounts). Each have the exact same headers. However, the rows aren't linked (all unique transactions). I want a pivot table that will get data from multiple sheets but give me the flexibility of playing with combinations of headers whichever way I want. Creating a pivot table through the wizard and multiple ranges handicaps me as it puts all headers under column field and the first column on each sheet as the rows field. Is there a way around it? I am using Excel 2007
I enjoyed watching this video and recommend others to watch Host is an awesome teacher. Explains clearly and crisply. Thanks for educating the community and appreciate your volunteership. Keep posting some more videos. Thanks a bunch
Great tutorial, thank you, I wanted to see if it is possible to create a pivot just like you did with worksheets that pull the data from a Microsoft query? and if so will I be able to refresh my data on my pivot table anytime the data is refreshed on the worksheets?
I consider myself pretty intelligent but when it comes to tutorial video's, I always end up feeling like a complete dumb**s. Yours was 100% clear. Big thanks from Holland!
Nice Vid Thanks a lot. @ 7:24 you say there's nothing visibly different but actually the table icons change over on the right, they gain a 'filled in' header bar rather than empty :)
Great tutorial. Thank you very much. I follow the provided link to get the sample file to practice but couldn't file the zip file. Is there any other way I can get it ?
This is really helpful, but if there is a duplicate value in ORDER# column, is there anyway we can still run this process? Really need it as I do have a few duplicate values in the common column.
Dear , thank you for your tutorial , it was helpful i didnt know that 2013 does this , the issue that when creating the same pivots does it need to be as the same criteria ? i know having a unique value is the common thing between all sheets , but will it show for you ? i will try it , thanks
Hoping this older post may still be monitored. Thank you for this simply explained video! I've created a pivot using data from two worksheets within the same workbook. Both have the same heading names for Part Numbers and Part Quantities. The quantities from one sheet show correctly by item. The quantities from the second sheet show the summed quantity of all Part Quantities in the Part Quantity column. Any advice on how to return the correct quantities by item? I tried this in MS BI too and received the same results. Thanks in advance!
Does anybody know how I can do this but instead of different sheets in the same work book, I need to combine data from multiple workbooks... Thank you!
Do you have a video for this? I do all my estimates on an Excel spreadsheet. The cells that the address goes in is the same for all my saved estimates. I would like to collect the addresses from all my estimates and place it in one file for mailing. Can you help with this?
Great video! Just a question: If there are for example 5 order numbers (1, 2, 3, 4, 5) in one sheet, does it have to be the same for other sheets? What if another sheet has 1, 2, 3, 4, 5, 6, 7? How will the relation work for order number 6 and 7?
This was one of the best tutorial videos I have seen. A very relaxed but comprehensive style in delivery.
Great video! The presenter explains the technique well explained, concise, and informative. Thank you!
great... finally I was able to understand how to create a data model if you don't have the powerpivot feature.. Thanks a lot
You"re an incredibly good teacher. Thank you!
most legit Excel tutorial I've seen in a long time. Now I don't hate Pivot tables as much coming from a strictly database background.
This tutorial was crispy clear & easy to understand! Very helpful 🙌🏾...Thank you & GREAT JOB!!! 👍🏽
A heck of approach to teaching. Easy to understand human voice, and organized manner in presenting what it matters. Bob clearly understand the principle of "Less Is More" and more importantly, how to use this value-add principle effectively. Thank you for taking the time to do this right.
- God bless.
Exactly what I have been looking for in pivot table. Why haven't I known this earlier!
I used to consolidate into one sheet for this job.
Thank you very much.
Awesome tutorial. I really appreciate how you broke it down into easy to follow steps.
I just found your channel, and went to your site to view tutorials by using the free download workbooks! - Thank You!
One of the best video on data model. So simple yet elegant.
Nicely done Bob....to the point, clear explanations and good verbal presentation...thanks
Truly one of the best excel tutorial videos!
That is very helpful especially for tables needing different sheets to look easy on the eyes instead of putting every columns in one single table. Thanks for sharing!
What is the benefit of converted data into tabke format before creating a pivot table?
this is the best tutorial ...saved me tons of time
Amazing work, simple and practical explanation of one of the best features of excel that only few know of
The host teaches very easy to understand. Thank you for sharing! ❤️
I appreciate you sharing this nice tool. This, I call as Magic, and can smartly consolidate and reconcile Financial Data. Thanks a Ton.
best tutorial, thanks for share ...
Awesome! Thank you so much for the detailed explanation and helpful tutorial...love it!
Great JOn.. Please make more tutorial videos, you have helped countless sous.. Thanks a million!
Bob Flisser!!! Awesome job man... Thank you... Today I learned something new :)
Amazing! Thank you for posting this video.
Omg thank you, I’m trying to update our inventory in quickbooks without hand entering each line item and I couldn’t figure out how to combine data. This is going to make life so much easier
I was creating a tutorial of my own but I was stuck because I forgot to change to a table with headers. This tutorial has helped me, thank you.
Stumbled onto by accident but must say it was a very good instructional video. Thanks for putting this together
Thank you. This is what I have been looking for👍👍👍
Thanks. Very informative and concise coaching.
this an excellent explanation, thank you SO MUCH for sharing this.
BIG HELP. Excited to implement!
Excellent Bob I really got a lot of very useful information and I now understand!!!
WOWWWW! This is so great. A very helpful video. You used just 9 minutes to take me out of my sleepless nights. Thank you sir!
great info Bob, keep up the good work... all the best.....
You're a legend. What a great video, well explained. :-D
Thanks for this video ! Appreciated. It is useful.
Wonderful. Solved my problem that I would like to do comparison between data of sale & purchase. Thank you & happy new year 2020.
Thank you very much sir,
Really great..sir now I was able to understand how to create a data. Thanks a lot
THANKS FOR SHARING THIS EXEL FILE THIS IS VERY EASY TO UNDERSTAND AS SHOWN IN THIS VEDIO.
Excellent tutorial thank you. I have a specific question a little different from your scenario. I have multiple sheets (lets say different accounts). Each have the exact same headers. However, the rows aren't linked (all unique transactions). I want a pivot table that will get data from multiple sheets but give me the flexibility of playing with combinations of headers whichever way I want. Creating a pivot table through the wizard and multiple ranges handicaps me as it puts all headers under column field and the first column on each sheet as the rows field. Is there a way around it?
I am using Excel 2007
I enjoyed watching this video and recommend others to watch
Host is an awesome teacher. Explains clearly and crisply.
Thanks for educating the community and appreciate your volunteership.
Keep posting some more videos.
Thanks a bunch
Awesome tutorial. Thanks for the info
Beautifully explained
Thanks for this, but how can I combine my tables with the same labels using excel functions
Great tutorial, thank you!
Great tutorial, thank you, I wanted to see if it is possible to create a pivot just like you did with worksheets that pull the data from a Microsoft query? and if so will I be able to refresh my data on my pivot table anytime the data is refreshed on the worksheets?
Excellent Bob!!’ Thanks.
Thanks dear, honestly it is very useful and helpful, more than everything your teaching way is very good.....
Awesome, thanks! great tutorial!
Very useful video. Very timely help. Thank you.
I consider myself pretty intelligent but when it comes to tutorial video's, I always end up feeling like a complete dumb**s. Yours was 100% clear. Big thanks from Holland!
Thank you. it help a lot
This was extremely helpful. If we don't have an order number but only month and year, can we relate that instead?
Extremely helpful :-) Thanks
Extreme helpful; step to step exposition is fine too. Tks a lot!
Thanks a lot , Well explained.
One of the Best vedios I had ever seen about excel
Can I get relate a column to a row? I'm having a spreadsheet in which I need to extract data to match the data from the other
Good to watch, informative.
Very useful and explained in simple language
very useful for me and big thanks for you.
Very well explained!
Nice Vid Thanks a lot. @ 7:24 you say there's nothing visibly different but actually the table icons change over on the right, they gain a 'filled in' header bar rather than empty :)
Thanks a lot. It worked for me.
One of the best video with all the explanation... 👍☺️☺️
Thanks, very good info after "PIVOT TABLE"
Excellent video!
Very good. Thank you!
Great tutorial. Thank you very much. I follow the provided link to get the sample file to practice but couldn't file the zip file. Is there any other way I can get it ?
Awesome, Thank You!
Very nicely explained .Thanks
Great video, thanks!
So so useful for me. Thank you very much
Awesome. Thank you!
good demo... thanks for this.
Can you assist with a specific issue? I would like to work with you by phone re errors on my vlookup and pivot charts please
simple and very informative
*It''s very Advanced and tricky for report* *Ontime Edu* 👌 👌
what should i do when i go to insert the pivot table and "add this data to the Data Model" is not "select-able"?
+Vanessa Riley : Are you view the excel workbook in compatibility mode? If so, save it as a normal excel workbook and try again.
It was interesting, it will be great help to many
Please advise if this method can be used with Excel 2010.
Thank you.
Very Useful.
Saved my life
Thanks for video!
This is really helpful, but if there is a duplicate value in ORDER# column, is there anyway we can still run this process? Really need it as I do have a few duplicate values in the common column.
Thank you so much!! 🙌🏻
Dear , thank you for your tutorial , it was helpful i didnt know that 2013 does this , the issue that when creating the same pivots does it need to be as the same criteria ? i know having a unique value is the common thing between all sheets , but will it show for you ? i will try it , thanks
great learning feature, now I just have to see if I can combine sales with targets...
excellent video
The Order Number has really earned good Karma :)
Hoping this older post may still be monitored. Thank you for this simply explained video! I've created a pivot using data from two worksheets within the same workbook. Both have the same heading names for Part Numbers and Part Quantities. The quantities from one sheet show correctly by item. The quantities from the second sheet show the summed quantity of all Part Quantities in the Part Quantity column. Any advice on how to return the correct quantities by item? I tried this in MS BI too and received the same results. Thanks in advance!
Excellent Video
Does anybody know how I can do this but instead of different sheets in the same work book, I need to combine data from multiple workbooks... Thank you!
great help ! Thank you
Do you have a video for this? I do all my estimates on an Excel spreadsheet. The cells that the address goes in is the same for all my saved estimates. I would
like to collect the addresses from all my estimates and place it in one file for mailing. Can you help with this?
Good video. Thank you
this is useful without using power pivot thanks
Great video! Just a question:
If there are for example 5 order numbers (1, 2, 3, 4, 5) in one sheet, does it have to be the same for other sheets? What if another sheet has 1, 2, 3, 4, 5, 6, 7? How will the relation work for order number 6 and 7?
Thanks. Good job
Thanks a lot and i am using it n it is working .
Am unable to find this opeion on Excel 2007 version. How can we get it ?