Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)

[@mkk530]

This is a perfect illustration of how internet and videos together benefit education! After the invention of internet and videos! We only need a good teacher like you to teach millions of students! While in the past, we may need thousands of teachers to teach millions of people. I definitely believe watching your videos to self-learn is much effective than taking courses. I will continue to support your video!Thank you for your efforts in making these videos.

[@excelisfun]

You are welcome! All business people need to know Excel if they want to get a job, so I cam glad the video help!

[@excelisfun]

You are welcome - I am glad that the videos help!!

[@excelisfun]

You are very welcome! I am happy that the videos help.

[@bluesbender69]

"THANK YOU, THANK YOU, THANK YOU!" The best Excel video on the whole internet. I used to be intimidated by Pivot Tables because some of the books I read on the subject made it seem hard. With your cool and fun teaching style, I have grown to love Pivot Tables and you are right, I can see where this would replace a lot of complicated formulas. Because of you, it will be so much easier now at work using this.

[@AngelFeenix]

You rock! These tutorials have changed my life and opened the door to a whole load of mega-fun at work. Im going to tell all my friends. Im becoming a pro!

[@excelisfun]

I am glad that you like the videos!

[@excelisfun]

You are welcome! Thanks for clicking the LIKE button!

[@excelisfun]

I am glad that you like the videos! The DVD is all that I have.

[@serendipity5366]

Jam packed full of info - moves along nicely, is conversational, and interesting. Actually, this is one of the best tutorials I've seen for advanced levels. THANK YOU!

[@excelisfun]

PivotTables make aggregate calculations, not extract records. You can use Filter to filter and then extract records. You can also double click any single cell in a PivotTbale and a new sheet with the records that make up that aggregate calculation will appear.

[@MiloLabradoodle]

This is one of the better summaries of pivot tables on KZbin. Thanks.

[@excelisfun]

I am glad that you liked it!

[@excelisfun]

I am glad that you liked this video! And yes, your method of studying this video rocks! PivotTables rule!

[@sarahliu122]

This video makes PivotTables much easier to understand and to use. I could put PivotTable on my resume now. Thanks a lot!

[@excelisfun]

This video has both the cross tabulated trick and the double click to get transactional data trick. I do not know if that will get you what you want, but it's worth a try.

[@jjgarson945]

This is the second video of yours that i've seen. As a business student in college I just wanted to say thank you for all the help you've been!

[@excelisfun]

Yes, it is the Office series I have posted.

[@excelisfun]

I am glad that you like it!

[@excelisfun]

@yanka369 , I am glad that this video can help to reduce Excel PivotTable shakes!!!

[@swathicwa]

am using excel from years, but thought pivot table is very difficult to do , because of the way the trainers explained me.. after seeing this video i feel very happy that i also can use the pivot table for sure. thanx for the videos...........

[@excelisfun]

@kannonne , I am glad that the videos help!!

[@vampirechunks]

Thank you so much for these fabulous tutorials. They're the best I've seen on youtube. I actually watched this video prior to taking an excel test for an interview. I not only passed every section, but I was the only applicant who did! Thanks for helping me get the job and for making this program so accessible. =D

[@excelisfun]

@krehkop11 , I am glad that you like it!

[@excelisfun]

I am glad that you like it!!

[@Siddharth316]

I had tried teaching myself pivot tables using the help sections but this is so much better. The tricks to work with data and presentation after creating the table were quite useful. Thanks for your efforts

[@excelisfun]

I am glad that the video helps!

[@excelisfun]

I am glad that the videos and workbook videos that I post help you! Wikipedia page!? I never thought of that...

[@excelisfun]

You can also group the dates you want and then drop the grouped date into Report Filter.

[@excelisfun]

@Fritzienator , you are welcome!

[@excelisfun]

@Yaqqob , I am glad it helped. But did you mean: EXCELlent work?

[@excelisfun]

Maybe create cross tabulated table with non-grouped date in row label and sales rep in column label and sales in values area, then double click intersecting cell to create new sheet with all transactions on that date for that sales rep.

[@excelisfun]

I am glad that it helped with the job!

[@AlexDawsonPSU]

You are most certainly the most entertaining/educational and above all awesome person for excel. You've helped me so much. Thank you!

[@cocoleong8616]

Your are my best teacher in my life . It's really the first time can self-study so sucessfully through your amazing video and work book.......Thanks so much for you efforts.........i don't know how to express my millions thanks for you ..............my dearest .....teacher...........

[@garyscostley]

Excellent Tutorial! I'm on a new project at work and everyone on our conference calls uses pivot tables. I have felt very overwhelmed, but your instruction will help me very much. Thanks for putting this together!

[@excelisfun]

Try dragging year field from row labels to column labels.

[@excelisfun]

Thank you for your support!

[@excelisfun]

Download the Finished 2010 workbook. Because you are not doing the whole class, you did not see the earlier video where we copied the sheet and named it "PT". The finished workbook has the sheet you want.

[@excelisfun]

You may shake for a while, but after a small bit of practice, you will be a master!! :)

[@mytungkai]

My boss asked me to prepare a report with 300,000+ line items in 1 hour. I managed to prepare it in less than 2 mins. You really saved my ass today. Thanks a lot.. :)

[@excelisfun]

I am glad that the video helped!!!

[@silverorion]

I almost never comment on a video (and I watch a LOT of videos) but I had to tell you I love your passion teaching these things. Very clear and concise. Thank you very much!!

[@excelisfun]

Maybe: You can drop the date in the Report Filter and then use the check boxes to unchecked the dates you do not want. Won't that work?

[@enriqueroque2206]

I just got a job that I need to be an expert in excel and access - your videos are so helpful. Thank you so much!

[@excelisfun]

empty cells or dates stores as text is the usual reason. You would have to change the data to get the Group feature to work.

[@aitchk]

Mike you're particularly good at explaining everything, Very much appreciated.

[@VygerFlix]

Like a lot of people I know I had heard the term but your video has just opened up a whole new horizon for data analysis in Excel for me and I am sure others - Thx

[@excelisfun]

Cool! Glad the video helped!

[@excelisfun]

@ContrastY , I am glad that the video is useful!

[@samirharrou4341]

ExcellsFun you are excellent and you make sound fun ...i don't usually comment in youtube videos but you are one of the rare ppl doing Awesome job on youtube ....Hug thanks from Morocco wish you the best luck bro.

[@excelisfun]

@MissT813 , you are welcome!!

[@excelisfun]

I am glad that it helps!

[@excelisfun]

I am glad that it helped!

[@Kfritzc]

I love your video tutorials that I actually subscribed to your channel. I got an assignment asking me to create charts using lookups, dynamic charts involving an overwhelming amount of data such as sales that has to be sorted and reported daily (sunday-saturday), weekly, per promo and promo line, etc.. I was stumped because it was my first time to hear about lookups! I have completed the assigned tasked and have learned a lot through your videos. Very easy to understand and follow :D

[@excelisfun]

You are welcome!

[@silvers_d]

Your videos are extremely helpful. I am trying to review excel for an interview I have next week and your videos are easy to understand and very help! Thank you!

[@wufuhai]

I just decided to take a look at this Pivot Table half an hour ago and I think I have got it already now! Thanks to this great video.

[@excelisfun]

@wsfosho , You are welcome!

[@excelisfun]

Glad you like it!

[@excelisfun]

You are welcome!!

[@Linkman311]

Just stumbled across this video, very helpful and I love how you explain what you are doing and what things mean. Can't wait to watch your other videos!

[@excelisfun]

Try the link under the video.

[@jacobinwood]

Thank you! This was infinitely more helpful than the information provided on office's website. Much appreciated

[@excelisfun]

Cool! I am glad that you like it!!

[@excelisfun]

10:30 minute mark has an example of cross tabulation and the double click trick.

[@excelisfun]

Cool! I am glad that it helps!

[@hassanhafez6675]

I gave up everything else to study here. This guy made me love Excel and understand the power of Excel. I love his all videos and I watch it most day to learn Excel in the best way.

[@excelisfun]

I am happy that the video help you!!! Thank you for your kind words and support, Hassan!!!!

[@hassanhafez6675]

I have an interview soon, I can tell after watching your videos about Vlookup, Pivot Tables, Data Mode that I am good at all these things. It is time to learn Macros, I will start from the beginning to the end of it. DO you have a playlist for Macros, please? Thank you so much for helping.

[@excelisfun]

I do not have a playlist of Macros. I have just one video that goes over basics: kzbin.info/www/bejne/jXzcf2ubbL2LoKs

[@vtstudent5161]

I have been binge-watching your videos since yesterday. I can literally hear your voice ringing in my ears while I showered. And to a great extent, it did depress me too knowing that You are doing such a great job of explaining, how could I go to Netflix. Screw Netflix. Welcome to Excel Is Fun. I recently binged on your Sumproduct videos and it literally made me feel like a geek. Bravo. At least I could call my ex and her I NOW know SUMPRODUCT (She is good with excel and programming..while I suck). Thank you so much for making these videos free. I sincerely appreciate it.

[@excelisfun]

You are welcome! Did you watch the 2 minute into video about how to find any video or class that I teach here at KZbin: kzbin.info/www/bejne/omKQYpSMnKunnpY You probably did if you are binging on SUMPRODUCT : ) Any way excelisfun is a much better use of time than NetFlix, and I am pretty sure I have more content too ? ) Need help finding something just let me know .

[@excelisfun]

@zee123sam , I am glad that the videos make it easy to do PT!!

[@Gototheshow]

Awesome series! I'm glad to see that Ross from the show Friends has found work that he is good at.

[@excelisfun]

@thebusyman1 , Cool, I am glad that this helps!

[@excelisfun]

Cool! You are welcome for the videos!

[@excelisfun]

link below video, in the Excel Basics Series section. Download the 2010 workbook.

[@excelisfun]

PivotTable do aggregate calculations - they do not extract records. Try Filter for that.

[@pauls7056]

Thanks for this. I didn't have a clue what pivot tables were about. Now I am looking forward to getting to work on them.

[@jingp9193]

You're amazing, I'm not following and will keep watching your videos.... I will start w/ the very first lesson you have until I will finish watching all of them.. You're truly amazing teacher.. Thank you very much! God bless you !

[@abigailholland7654]

Can't wait to try this on the data sheets I am working on for my job. Your video is great. Very easy to follow and very informative. I have had limited exposure to Excel and I'm thrilled to know about your resource!

[@excelisfun]

@krehkop11 , I am glad that the vid helped!

[@DaveMaharaj]

Thank You Very Much :) Some people write a fat book to explain what you just did in 24 minutes. Your option is better in the real world. And you are fun to listen to.

[@Stegmutt]

Thanks for this video- extraordinarily clear and full of win. I like your teaching style.

[@wenleeatwork]

THANK YOU, THANK YOU, THANK YOU! Your instruction is really clear and fun to watch. This is the best 25 minutes I spent on my 2013 holiday break. Thanks a lot.

[@excelisfun]

You are welcome!

[@excelisfun]

Glad it helped!

[@dkychen888]

You're the first person I turn to when I get a new job! Happy New Year!

[@excelisfun]

Glad the videos help!

[@krehkop11]

Love your method of teaching, very easy to understand!!!

[@jugmez]

It's terrific !! Thank you some much for puting so much love in these tutorials !!

[@gemsubong]

Thank you so much. I learnt a lot. You explained it very clearly and in an uncomplicated way.

[@excelisfun]

They are similar in method and same in result. See: Excel Magic Trick # 166: CONCATENATE function & Ampersand

[@krismaly6300]

Amzing Teacher is knowledgeable and funny. Purposely makes a mistake and teaches that's what exactly I want. Everybody can teach happy path but all roads are not straight. I recommend others to watch. I enjoyed watching this video. Thanks for educating the community and appreciate your volunteer-ship. When you make new video drop in my email I will review and write comments. Thanks a bunch

[@manuelmejia2234]

If only every teacher could teach this way!!!! Really great thanks soooo much!!

[@excelisfun]

worbook here in Excel Basics 2010 sections: people.highline.edu/mgirvin/ExcelIsFun.htm

[@excelisfun]

This video is about Excel 2010.

[@MissT813]

You have made my life so much easier. Thank you.

[@excelisfun]

To download the video, click on the link below the video.

[@TheSpiritSing]

Great, VERY helpful. Most productive 24 minutes I've spent today!

[@excelisfun]

Glad the video helped!

[@excelisfun]

I have no idea. Sorry, I do not know how to use a Mac (even though I started my business career in 90s on a MAC, I got chased off of it cuz of accounting...)

[@nedavahedi6381]

Love your Excel videos! Concise and right to the point.

[@Skullptor666]

Pivot table made easy!!! That was an amazing tutorial which I can use at work everyday. Thanks very much mate!!!

[@excelisfun]

You are welcome!

[@4marcoscasillas]

Another great tutorial !!! Thanks for covering such a range from easy to advanced...

[@jsurfer23]

Mike, I have found the pivot table segment, and found it to be very educational and helpful. I downloaded the worksheet, and am wondering do you go over the entire worksheet in more videos? I would love to do it start to finish, if at all possible. I hope I can, please let me know. Thanks again!

[@prakashgautam1759]

The way you present is awesome.

[@excelisfun]

Glad you like it!

[@ChrisHerft]

Thank you Sir! Best tute on O10 Pivots I have ever seen.

[@excelisfun]

Glad you like it!