Advanced PivotTables: Combining Data from Multiple Sheets

  Рет қаралды 1,762,389

Tuts+ Computer Skills

Tuts+ Computer Skills

10 жыл бұрын

See companion tutorial and sample files on Tuts+: computers.tutsplus.com/tutori....
By Bob Flisser.

Пікірлер: 249
@tonyhartigan4668
@tonyhartigan4668 6 жыл бұрын
This was one of the best tutorial videos I have seen. A very relaxed but comprehensive style in delivery.
@danyos777
@danyos777 5 жыл бұрын
Great video! The presenter explains the technique well explained, concise, and informative. Thank you!
@vladtheinhaler896
@vladtheinhaler896 4 жыл бұрын
You"re an incredibly good teacher. Thank you!
@nadaudjacques-louis7426
@nadaudjacques-louis7426 5 жыл бұрын
This tutorial was crispy clear & easy to understand! Very helpful 🙌🏾...Thank you & GREAT JOB!!! 👍🏽
@jazzista1967
@jazzista1967 8 жыл бұрын
great... finally I was able to understand how to create a data model if you don't have the powerpivot feature.. Thanks a lot
@emoticonprime
@emoticonprime 8 жыл бұрын
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.
@mkoptions5103
@mkoptions5103 2 жыл бұрын
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.
@mishellefisher8925
@mishellefisher8925 7 жыл бұрын
Awesome tutorial. I really appreciate how you broke it down into easy to follow steps.
@kangsungho1752
@kangsungho1752 4 жыл бұрын
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.
@SteelerY360Nation
@SteelerY360Nation 7 жыл бұрын
I just found your channel, and went to your site to view tutorials by using the free download workbooks! - Thank You!
@rameshdorairaj9906
@rameshdorairaj9906 4 жыл бұрын
Nicely done Bob....to the point, clear explanations and good verbal presentation...thanks
@LinaLeyda
@LinaLeyda 4 жыл бұрын
Truly one of the best excel tutorial videos!
@abe4214
@abe4214 4 жыл бұрын
One of the best video on data model. So simple yet elegant.
@nholmes86
@nholmes86 4 жыл бұрын
this is the best tutorial ...saved me tons of time
@mkhodr1
@mkhodr1 4 жыл бұрын
Amazing work, simple and practical explanation of one of the best features of excel that only few know of
@ldmlhome
@ldmlhome 4 жыл бұрын
Awesome! Thank you so much for the detailed explanation and helpful tutorial...love it!
@gintomino4136
@gintomino4136 4 жыл бұрын
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
@sallyho146 Жыл бұрын
What is the benefit of converted data into tabke format before creating a pivot table?
@leslieserrano8171
@leslieserrano8171 8 жыл бұрын
best tutorial, thanks for share ...
@Mansoorsadat
@Mansoorsadat 8 жыл бұрын
Bob Flisser!!! Awesome job man... Thank you... Today I learned something new :)
@DanAlvard
@DanAlvard 8 жыл бұрын
Great JOn.. Please make more tutorial videos, you have helped countless sous.. Thanks a million!
@uttamdutta1762
@uttamdutta1762 3 жыл бұрын
I appreciate you sharing this nice tool. This, I call as Magic, and can smartly consolidate and reconcile Financial Data. Thanks a Ton.
@induonyoutube
@induonyoutube 8 жыл бұрын
Amazing! Thank you for posting this video.
@traceylu5283
@traceylu5283 2 жыл бұрын
The host teaches very easy to understand. Thank you for sharing! ❤️
@jasoncracraft1924
@jasoncracraft1924 4 жыл бұрын
BIG HELP. Excited to implement!
@celeb-news
@celeb-news 3 жыл бұрын
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.
@wifuu4941
@wifuu4941 2 жыл бұрын
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
@rajachauhan8041
@rajachauhan8041 7 жыл бұрын
great info Bob, keep up the good work... all the best.....
@marianabitencourt78
@marianabitencourt78 4 жыл бұрын
this an excellent explanation, thank you SO MUCH for sharing this.
@malcolmgay2206
@malcolmgay2206 8 жыл бұрын
Thanks. Very informative and concise coaching.
@TheQuirby
@TheQuirby 4 жыл бұрын
Stumbled onto by accident but must say it was a very good instructional video. Thanks for putting this together
@pennycox815
@pennycox815 6 жыл бұрын
You're a legend. What a great video, well explained. :-D
@zippychan3252
@zippychan3252 4 жыл бұрын
Thank you. This is what I have been looking for👍👍👍
@Zandor434
@Zandor434 4 жыл бұрын
Awesome tutorial. Thanks for the info
@nandhagopal8699
@nandhagopal8699 5 жыл бұрын
Beautifully explained
@ynaartsasyouliveandbreathe3533
@ynaartsasyouliveandbreathe3533 8 жыл бұрын
Great tutorial, thank you!
@kaynoad6571
@kaynoad6571 4 жыл бұрын
Excellent Bob I really got a lot of very useful information and I now understand!!!
@jammalelamarti6467
@jammalelamarti6467 6 жыл бұрын
Thanks for this video ! Appreciated. It is useful.
@xochitlc.1659
@xochitlc.1659 4 жыл бұрын
Awesome, thanks! great tutorial!
@dph22013
@dph22013 5 жыл бұрын
Excellent Bob!!’ Thanks.
@adarshmaurya836
@adarshmaurya836 9 жыл бұрын
THANKS FOR SHARING THIS EXEL FILE THIS IS VERY EASY TO UNDERSTAND AS SHOWN IN THIS VEDIO.
@sunpureoranges5646
@sunpureoranges5646 6 жыл бұрын
Thank you very much sir, Really great..sir now I was able to understand how to create a data. Thanks a lot
@ibejoseph19
@ibejoseph19 2 жыл бұрын
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!
@diptisharma9900
@diptisharma9900 5 жыл бұрын
Thanks a lot , Well explained.
@peluso_palit
@peluso_palit 4 жыл бұрын
Wonderful. Solved my problem that I would like to do comparison between data of sale & purchase. Thank you & happy new year 2020.
@dastageera9626
@dastageera9626 4 жыл бұрын
Thanks dear, honestly it is very useful and helpful, more than everything your teaching way is very good.....
@vishankhandelwal2993
@vishankhandelwal2993 7 жыл бұрын
Extremely helpful :-) Thanks
@alexab200926
@alexab200926 6 жыл бұрын
Very well explained!
@43214541
@43214541 7 жыл бұрын
Thank you. it help a lot
@alexrosen8762
@alexrosen8762 7 жыл бұрын
Very good. Thank you!
@ramkumarjayabalan2135
@ramkumarjayabalan2135 6 жыл бұрын
very useful for me and big thanks for you.
@andreimarusic865
@andreimarusic865 5 жыл бұрын
Thanks a lot. It worked for me.
@manigr3538
@manigr3538 7 жыл бұрын
Very useful and explained in simple language
@ycw2514
@ycw2514 3 жыл бұрын
Very useful video. Very timely help. Thank you.
@riverboat8943
@riverboat8943 6 жыл бұрын
Excellent video!
@WilliamCulver
@WilliamCulver 6 жыл бұрын
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 :)
@jjbean321
@jjbean321 6 жыл бұрын
Awesome, Thank You!
@krismaly6300
@krismaly6300 7 жыл бұрын
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
@jeenapk
@jeenapk 4 жыл бұрын
Very nicely explained .Thanks
@desipindu420
@desipindu420 4 жыл бұрын
good demo... thanks for this.
@kishoretholana7832
@kishoretholana7832 6 жыл бұрын
simple and very informative
@deepakjohn9295
@deepakjohn9295 4 жыл бұрын
Awesome. Thank you!
@mohammedziaullah3176
@mohammedziaullah3176 6 жыл бұрын
Thanks, very good info after "PIVOT TABLE"
@jokaiadam5408
@jokaiadam5408 3 жыл бұрын
Great video, thanks!
@75eneto
@75eneto 7 жыл бұрын
Extreme helpful; step to step exposition is fine too. Tks a lot!
@ravilifestylevlogs8496
@ravilifestylevlogs8496 4 жыл бұрын
One of the best video with all the explanation... 👍☺️☺️
@josvgorkum7968
@josvgorkum7968 5 жыл бұрын
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!
@haarismo2
@haarismo2 3 жыл бұрын
Thank you so much!! 🙌🏻
@ayanahmed4210
@ayanahmed4210 Жыл бұрын
Good to watch, informative.
@caseyleftwich4614
@caseyleftwich4614 7 жыл бұрын
This was extremely helpful. If we don't have an order number but only month and year, can we relate that instead?
@torukmakto0
@torukmakto0 3 жыл бұрын
So so useful for me. Thank you very much
@blalalalala3255
@blalalalala3255 4 жыл бұрын
Thanks for this, but how can I combine my tables with the same labels using excel functions
@bharathnathreddy953
@bharathnathreddy953 3 жыл бұрын
One of the Best vedios I had ever seen about excel
@yurd563
@yurd563 5 жыл бұрын
Thanks for video!
@monsterstream4420
@monsterstream4420 6 жыл бұрын
Good video. Thank you
@Excel_Mantra
@Excel_Mantra 5 жыл бұрын
*It''s very Advanced and tricky for report* *Ontime Edu* 👌 👌
@balasubramanianshanmugam3721
@balasubramanianshanmugam3721 5 жыл бұрын
Thanks. Good job
@chrislin4079
@chrislin4079 3 жыл бұрын
great help ! Thank you
@mohanpant471
@mohanpant471 7 жыл бұрын
Excellent Video
@DavoDevigne
@DavoDevigne 7 жыл бұрын
Yep, pretty damn goooood!
@azzeddinechergui4009
@azzeddinechergui4009 6 жыл бұрын
Thank you a lot !
@christophmeirich5928
@christophmeirich5928 6 жыл бұрын
very helpfull ... thx a lot!!!!
@iecivil
@iecivil 5 жыл бұрын
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
@jessicamunoz3515
@jessicamunoz3515 8 жыл бұрын
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?
@babu-tanguturi-7476
@babu-tanguturi-7476 5 жыл бұрын
Thanks for the Video
@Avi8053
@Avi8053 6 жыл бұрын
The Order Number has really earned good Karma :)
@xankru5270
@xankru5270 5 жыл бұрын
great learning feature, now I just have to see if I can combine sales with targets...
@TheADIDAMAC
@TheADIDAMAC 8 жыл бұрын
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
@chewcatherine3063
@chewcatherine3063 3 жыл бұрын
I absolutely love this function! Can't believe I only learn it 6 years after you shared this tutorial. Unfortunately I can't find the tutorial zip file, would you be kind enough to share it again? Thanks.
@jebasingh9376
@jebasingh9376 2 жыл бұрын
Very Useful.
@thebesttechnical3608
@thebesttechnical3608 4 жыл бұрын
Very good and informative video
@nancymahmoud1841
@nancymahmoud1841 4 жыл бұрын
excellent video
@bishoykailini1
@bishoykailini1 8 жыл бұрын
Thank you so much
@gravittii
@gravittii 5 жыл бұрын
Thank You!
@sachinkishore4115
@sachinkishore4115 3 жыл бұрын
Thanks a lot and i am using it n it is working .
@cathyrichey3023
@cathyrichey3023 6 жыл бұрын
Thank you so much! This was quite helpful!
@AAsup
@AAsup Жыл бұрын
Thank you. ❤️❤️❤️
@lnyace
@lnyace 3 жыл бұрын
It was interesting, it will be great help to many
@indrayanbhattacharya3415
@indrayanbhattacharya3415 8 жыл бұрын
Thanks. Good tutorial.
@gintomino4136
@gintomino4136 4 жыл бұрын
this is useful without using power pivot thanks
@anilkushwaha3225
@anilkushwaha3225 3 жыл бұрын
Saved my life
How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX
15:54
Tuts+ Computer Skills
Рет қаралды 5 МЛН
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
Sigma Kid Hair #funny #sigma #comedy
00:33
CRAZY GREAPA
Рет қаралды 15 МЛН
КАК ДУМАЕТЕ КТО ВЫЙГРАЕТ😂
00:29
МЯТНАЯ ФАНТА
Рет қаралды 6 МЛН
Create Excel Pivot Table from Multiple Sheets: The FASTEST Way
10:31
Teacher's Tech
Рет қаралды 17 М.
☑️ Top 25 Advanced Pivot Table Tips & Tricks For Microsoft Excel
28:30
AWESOME Excel trick to combine data from multiple sheets
7:27
Join multiple tables in a PivotTable
10:00
Excel Off The Grid
Рет қаралды 79 М.
Advanced Pivot Table Techniques (to achieve more in Excel)
11:47
Leila Gharani
Рет қаралды 1,9 МЛН
Excel - Merge Data from Multiple Sheets Based on Key Column
9:05
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 568 М.
Create a Pivot Table from multiple worksheets of a workbook
9:33
Ashish Mathur
Рет қаралды 270 М.
Excel PivotTables for Beginners (2024)
9:59
Excel University
Рет қаралды 35 М.
Игровой Комп с Авито за 4500р
1:00
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 2,3 МЛН
Здесь упор в процессор
18:02
Рома, Просто Рома
Рет қаралды 346 М.
Cheapest gaming phone? 🤭 #miniphone #smartphone #iphone #fy
0:19
Pockify™
Рет қаралды 2,9 МЛН
OZON РАЗБИЛИ 3 КОМПЬЮТЕРА
0:57
Кинг Комп Shorts
Рет қаралды 1,8 МЛН
PART 52 || DIY Wireless Switch forElectronic Lights - Easy Guide!
1:01
HUBAB__OFFICIAL
Рет қаралды 52 МЛН