See companion tutorial and sample files on Tuts+: computers.tutsplus.com/tutori.... By Bob Flisser.
Жүктеу.....
Пікірлер: 249
@tonyhartigan46686 жыл бұрын
This was one of the best tutorial videos I have seen. A very relaxed but comprehensive style in delivery.
@vladtheinhaler8964 жыл бұрын
You"re an incredibly good teacher. Thank you!
@mkoptions51032 жыл бұрын
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.
@emoticonprime8 жыл бұрын
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.
@danyos7775 жыл бұрын
Great video! The presenter explains the technique well explained, concise, and informative. Thank you!
@mishellefisher89257 жыл бұрын
Awesome tutorial. I really appreciate how you broke it down into easy to follow steps.
@nadaudjacques-louis74265 жыл бұрын
This tutorial was crispy clear & easy to understand! Very helpful 🙌🏾...Thank you & GREAT JOB!!! 👍🏽
@kangsungho17524 жыл бұрын
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.
@jazzista19678 жыл бұрын
great... finally I was able to understand how to create a data model if you don't have the powerpivot feature.. Thanks a lot
@SteelerY360Nation7 жыл бұрын
I just found your channel, and went to your site to view tutorials by using the free download workbooks! - Thank You!
@rameshdorairaj99064 жыл бұрын
Nicely done Bob....to the point, clear explanations and good verbal presentation...thanks
@abe42144 жыл бұрын
One of the best video on data model. So simple yet elegant.
@LinaLeyda4 жыл бұрын
Truly one of the best excel tutorial videos!
@traceylu52832 жыл бұрын
The host teaches very easy to understand. Thank you for sharing! ❤️
@gintomino41364 жыл бұрын
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!
@sallyho146
Жыл бұрын
What is the benefit of converted data into tabke format before creating a pivot table?
@Mansoorsadat8 жыл бұрын
Bob Flisser!!! Awesome job man... Thank you... Today I learned something new :)
@DanAlvard8 жыл бұрын
Great JOn.. Please make more tutorial videos, you have helped countless sous.. Thanks a million!
@ldmlhome4 жыл бұрын
Awesome! Thank you so much for the detailed explanation and helpful tutorial...love it!
@celeb-news3 жыл бұрын
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.
@ibejoseph192 жыл бұрын
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!
@mkhodr14 жыл бұрын
Amazing work, simple and practical explanation of one of the best features of excel that only few know of
@wifuu49412 жыл бұрын
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
@nholmes864 жыл бұрын
this is the best tutorial ...saved me tons of time
@TheQuirby4 жыл бұрын
Stumbled onto by accident but must say it was a very good instructional video. Thanks for putting this together
@induonyoutube8 жыл бұрын
Amazing! Thank you for posting this video.
@rajachauhan80417 жыл бұрын
great info Bob, keep up the good work... all the best.....
@uttamdutta17623 жыл бұрын
I appreciate you sharing this nice tool. This, I call as Magic, and can smartly consolidate and reconcile Financial Data. Thanks a Ton.
@jasoncracraft19244 жыл бұрын
BIG HELP. Excited to implement!
@leslieserrano81718 жыл бұрын
best tutorial, thanks for share ...
@malcolmgay22068 жыл бұрын
Thanks. Very informative and concise coaching.
@zippychan32524 жыл бұрын
Thank you. This is what I have been looking for👍👍👍
@marianabitencourt784 жыл бұрын
this an excellent explanation, thank you SO MUCH for sharing this.
@kaynoad65714 жыл бұрын
Excellent Bob I really got a lot of very useful information and I now understand!!!
@krismaly63007 жыл бұрын
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
@pennycox8156 жыл бұрын
You're a legend. What a great video, well explained. :-D
@Zandor4344 жыл бұрын
Awesome tutorial. Thanks for the info
@josvgorkum79685 жыл бұрын
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!
@dph220135 жыл бұрын
Excellent Bob!!’ Thanks.
@ynaartsasyouliveandbreathe35338 жыл бұрын
Great tutorial, thank you!
@sunpureoranges56466 жыл бұрын
Thank you very much sir, Really great..sir now I was able to understand how to create a data. Thanks a lot
@adarshmaurya8369 жыл бұрын
THANKS FOR SHARING THIS EXEL FILE THIS IS VERY EASY TO UNDERSTAND AS SHOWN IN THIS VEDIO.
@peluso_palit4 жыл бұрын
Wonderful. Solved my problem that I would like to do comparison between data of sale & purchase. Thank you & happy new year 2020.
@jammalelamarti64676 жыл бұрын
Thanks for this video ! Appreciated. It is useful.
@xochitlc.16594 жыл бұрын
Awesome, thanks! great tutorial!
@nandhagopal86995 жыл бұрын
Beautifully explained
@ycw25143 жыл бұрын
Very useful video. Very timely help. Thank you.
@dastageera96264 жыл бұрын
Thanks dear, honestly it is very useful and helpful, more than everything your teaching way is very good.....
@75eneto7 жыл бұрын
Extreme helpful; step to step exposition is fine too. Tks a lot!
@manigr35387 жыл бұрын
Very useful and explained in simple language
@bharathnathreddy9533 жыл бұрын
One of the Best vedios I had ever seen about excel
@vishankhandelwal29937 жыл бұрын
Extremely helpful :-) Thanks
@diptisharma99005 жыл бұрын
Thanks a lot , Well explained.
@ravilifestylevlogs84964 жыл бұрын
One of the best video with all the explanation... 👍☺️☺️
@432145417 жыл бұрын
Thank you. it help a lot
@ramkumarjayabalan21356 жыл бұрын
very useful for me and big thanks for you.
@mohammedziaullah31766 жыл бұрын
Thanks, very good info after "PIVOT TABLE"
@alexab2009266 жыл бұрын
Very well explained!
@riverboat89436 жыл бұрын
Excellent video!
@andreimarusic8655 жыл бұрын
Thanks a lot. It worked for me.
@ayanahmed4210 Жыл бұрын
Good to watch, informative.
@alexrosen87627 жыл бұрын
Very good. Thank you!
@jeenapk4 жыл бұрын
Very nicely explained .Thanks
@jjbean3216 жыл бұрын
Awesome, Thank You!
@WilliamCulver6 жыл бұрын
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 :)
@deepakjohn92954 жыл бұрын
Awesome. Thank you!
@Excel_Mantra5 жыл бұрын
*It''s very Advanced and tricky for report* *Ontime Edu* 👌 👌
@jokaiadam54083 жыл бұрын
Great video, thanks!
@torukmakto03 жыл бұрын
So so useful for me. Thank you very much
@kishoretholana78326 жыл бұрын
simple and very informative
@desipindu4204 жыл бұрын
good demo... thanks for this.
@blalalalala32554 жыл бұрын
Thanks for this, but how can I combine my tables with the same labels using excel functions
@Avi80536 жыл бұрын
The Order Number has really earned good Karma :)
@haarismo23 жыл бұрын
Thank you so much!! 🙌🏻
@yurd5635 жыл бұрын
Thanks for video!
@TheADIDAMAC8 жыл бұрын
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
@mohanpant4717 жыл бұрын
Excellent Video
@jessicamunoz35158 жыл бұрын
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?
@caseyleftwich46147 жыл бұрын
This was extremely helpful. If we don't have an order number but only month and year, can we relate that instead?
@ousmanesidibe9512 ай бұрын
This videos has 9 years old but bet 90% of excel users doesn't know about this useful feature
@chrislin40793 жыл бұрын
great help ! Thank you
@monsterstream44206 жыл бұрын
Good video. Thank you
@balasubramanianshanmugam37215 жыл бұрын
Thanks. Good job
@xankru52705 жыл бұрын
great learning feature, now I just have to see if I can combine sales with targets...
@thebesttechnical36084 жыл бұрын
Very good and informative video
@cathyrichey30236 жыл бұрын
Thank you so much! This was quite helpful!
@gintomino41364 жыл бұрын
this is useful without using power pivot thanks
@azzeddinechergui40096 жыл бұрын
Thank you a lot !
@jebasingh93762 жыл бұрын
Very Useful.
@lnyace3 жыл бұрын
It was interesting, it will be great help to many
@DavoDevigne7 жыл бұрын
Yep, pretty damn goooood!
@nancymahmoud18414 жыл бұрын
excellent video
@iecivil5 жыл бұрын
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
@babu-tanguturi-74765 жыл бұрын
Thanks for the Video
@gravittii5 жыл бұрын
Thank You!
@anilkushwaha32253 жыл бұрын
Saved my life
@keelysoto33887 жыл бұрын
Awesome!
@French_Connection4 жыл бұрын
Amazing. I was able to do it. Newer videos here teach how to use vlookup to add fields. Very difficult and long. This one easy and reliable.
@philcyclelife4 жыл бұрын
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?
Пікірлер: 249
This was one of the best tutorial videos I have seen. A very relaxed but comprehensive style in delivery.
You"re an incredibly good teacher. Thank you!
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.
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.
Great video! The presenter explains the technique well explained, concise, and informative. Thank you!
Awesome tutorial. I really appreciate how you broke it down into easy to follow steps.
This tutorial was crispy clear & easy to understand! Very helpful 🙌🏾...Thank you & GREAT JOB!!! 👍🏽
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.
great... finally I was able to understand how to create a data model if you don't have the powerpivot feature.. Thanks a lot
I just found your channel, and went to your site to view tutorials by using the free download workbooks! - Thank You!
Nicely done Bob....to the point, clear explanations and good verbal presentation...thanks
One of the best video on data model. So simple yet elegant.
Truly one of the best excel tutorial videos!
The host teaches very easy to understand. Thank you for sharing! ❤️
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!
@sallyho146
Жыл бұрын
What is the benefit of converted data into tabke format before creating a pivot table?
Bob Flisser!!! Awesome job man... Thank you... Today I learned something new :)
Great JOn.. Please make more tutorial videos, you have helped countless sous.. Thanks a million!
Awesome! Thank you so much for the detailed explanation and helpful tutorial...love it!
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.
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!
Amazing work, simple and practical explanation of one of the best features of excel that only few know of
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
this is the best tutorial ...saved me tons of time
Stumbled onto by accident but must say it was a very good instructional video. Thanks for putting this together
Amazing! Thank you for posting this video.
great info Bob, keep up the good work... all the best.....
I appreciate you sharing this nice tool. This, I call as Magic, and can smartly consolidate and reconcile Financial Data. Thanks a Ton.
BIG HELP. Excited to implement!
best tutorial, thanks for share ...
Thanks. Very informative and concise coaching.
Thank you. This is what I have been looking for👍👍👍
this an excellent explanation, thank you SO MUCH for sharing this.
Excellent Bob I really got a lot of very useful information and I now understand!!!
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
You're a legend. What a great video, well explained. :-D
Awesome tutorial. Thanks for the info
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!
Excellent Bob!!’ Thanks.
Great tutorial, thank you!
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.
Wonderful. Solved my problem that I would like to do comparison between data of sale & purchase. Thank you & happy new year 2020.
Thanks for this video ! Appreciated. It is useful.
Awesome, thanks! great tutorial!
Beautifully explained
Very useful video. Very timely help. Thank you.
Thanks dear, honestly it is very useful and helpful, more than everything your teaching way is very good.....
Extreme helpful; step to step exposition is fine too. Tks a lot!
Very useful and explained in simple language
One of the Best vedios I had ever seen about excel
Extremely helpful :-) Thanks
Thanks a lot , Well explained.
One of the best video with all the explanation... 👍☺️☺️
Thank you. it help a lot
very useful for me and big thanks for you.
Thanks, very good info after "PIVOT TABLE"
Very well explained!
Excellent video!
Thanks a lot. It worked for me.
Good to watch, informative.
Very good. Thank you!
Very nicely explained .Thanks
Awesome, Thank You!
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 :)
Awesome. Thank you!
*It''s very Advanced and tricky for report* *Ontime Edu* 👌 👌
Great video, thanks!
So so useful for me. Thank you very much
simple and very informative
good demo... thanks for this.
Thanks for this, but how can I combine my tables with the same labels using excel functions
The Order Number has really earned good Karma :)
Thank you so much!! 🙌🏻
Thanks for video!
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
Excellent Video
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?
This was extremely helpful. If we don't have an order number but only month and year, can we relate that instead?
This videos has 9 years old but bet 90% of excel users doesn't know about this useful feature
great help ! Thank you
Good video. Thank you
Thanks. Good job
great learning feature, now I just have to see if I can combine sales with targets...
Very good and informative video
Thank you so much! This was quite helpful!
this is useful without using power pivot thanks
Thank you a lot !
Very Useful.
It was interesting, it will be great help to many
Yep, pretty damn goooood!
excellent video
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
Thanks for the Video
Thank You!
Saved my life
Awesome!
Amazing. I was able to do it. Newer videos here teach how to use vlookup to add fields. Very difficult and long. This one easy and reliable.
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?
very helpfull ... thx a lot!!!!
Thank you so much