Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)
HTML-код
- Опубликовано: 22 авг 2024
- Excel Start File: people.highlin...
Excel Finished File: people.highlin...
Free Excel 2010 book: people.highlin...
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Topics Covered In Video:
1. PivotTables are easy: Just envision the table in advance
2. Field list has fields and areas that you can drag fields to
3. Column Labels -- Column Headers
4. Row Labels -- Row Headers
5. Value Area -- this is where the calculation goes
6. Cross tabulation (row label and column label)
7. Double Click to create new sheet with data
8. Filter area -- filters whole report
9. Slicers
10. Value Field Settings Dialog box
11. Number Format For Value Field in Value Field Settings Dialog box
12. SUM function
13. Change Function in Value Field Settings Dialog box
14. Average Function
15. Format PivotTable
16. Layout For PivotTable
17. Multiple calculations: just drop field into value area multiple times and change function
18. Change Field Names in Value Field Settings Dialog box
19. Frequency Table to Count
20. Group By Dates
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.
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!!
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
Cool! Glad the video helped!
This is one of the better summaries of pivot tables on RUclips. Thanks.
You are welcome! All business people need to know Excel if they want to get a job, so I cam glad the video help!
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!
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!
This video makes PivotTables much easier to understand and to use. I could put PivotTable on my resume now. Thanks a lot!
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 !
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.
You are welcome! Did you watch the 2 minute into video about how to find any video or class that I teach here at RUclips: ruclips.net/video/l1-1aVgFth4/видео.html 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 .
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.
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.
I am happy that the video help you!!! Thank you for your kind words and support, Hassan!!!!
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.
I do not have a playlist of Macros. I have just one video that goes over basics: ruclips.net/video/WKyN8e7XXjI/видео.html
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.
You are welcome!
You are welcome! Thanks for clicking the LIKE button!
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
You are very welcome! I am happy that the videos help.
You are welcome - I am glad that the videos help!!
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.. :)
I am glad that the video helped!!!
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!
"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.
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
You are most certainly the most entertaining/educational and above all awesome person for excel. You've helped me so much. Thank you!
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.
Great, VERY helpful. Most productive 24 minutes I've spent today!
Glad the video helped!
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!
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!
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
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...........
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...........
If only every teacher could teach this way!!!! Really great thanks soooo much!!
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!
I am glad that you like the videos! The DVD is all that I have.
Mike you're particularly good at explaining everything, Very much appreciated.
I cant tell you how helpful this has been, thank you very much
Pivot table made easy!!! That was an amazing tutorial which I can use at work everyday. Thanks very much mate!!!
You are welcome!
I am glad that you like the videos!
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!
Thank you! This was infinitely more helpful than the information provided on office's website. Much appreciated
I am glad that the video helps!
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
I am glad that you liked this video! And yes, your method of studying this video rocks!
PivotTables rule!
I truly enjoyed this video! Very informative and straight to the point...I agree, "Pivot Tables" are easy and a great time saver!
Thank you:)
You are welcome!
Seems like I know well the function but there're always some new tricks I learn in your videos. I like the Insert Slicer! Thank you!!
I am glad that you liked it!
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.
Another great tutorial !!! Thanks for covering such a range from easy to advanced...
I love it when you do the "boss voice" impression. LOL good stuff!
Glad you like it!
Your videos are great by the way! I have benefited from many.. Don't you have a book out? I think I will have to buy that..
I have 2 books at Amazon:
Slaying Excel Dragons
www.amazon.com/Slaying-Excel-Dragons-Conquering-Frustrations/dp/161547000X
Ctrl + Shift + Enter: Mastering Excel Array Formulas
www.amazon.com/Ctrl-Shift-Enter-Efficient-Calculating/dp/1615470077
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!
I am glad that you like it!
You're the first person I turn to when I get a new job! Happy New Year!
Glad the videos help!
Thank you for your support!
Still having trouble with understanding the purpose for some of the pivot tables but really good presentation. It was easy to follow along and I feel like I learned a lot. Thank you!
Love your Excel videos! Concise and right to the point.
I am glad that it helped with the job!
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.
This was a super exciting video, no joke. Should have learned pivot tables years ago. Thank you!
Awesome series! I'm glad to see that Ross from the show Friends has found work that he is good at.
Thank you Sir! Best tute on O10 Pivots I have ever seen.
Glad you like it!
Thank you for the effort you put in making these videos! You're awesome!
Cool. Glad you like them! Thanks for LIKING!!
Thanks for this video- extraordinarily clear and full of win. I like your teaching style.
Thank you so much. I learnt a lot. You explained it very clearly and in an uncomplicated way.
@kannonne , I am glad that the videos help!!
Thank you for making using Pivot tables easy.
I am glad that you like it!!
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.
Thank you for your continued knowledge and help on these subjects. It is much appreciated.
You are welcome!
Love your method of teaching, very easy to understand!!!
I am glad that it helps!
I am glad that the videos and workbook videos that I post help you! Wikipedia page!? I never thought of that...
Thank you so much for sharing! You're a great teacher!! I've learned so much from your videos! Thanks again!
You have made my life so much easier. Thank you.
Thank you for this amazing video. It's a nice crash course on pivot tables and really easy to follow!
Glad you like it!
It's terrific !! Thank you some much for puting so much love in these tutorials !!
I am glad that it helped!
Excellent presentation of Pivot tables! Thank you!
Finally! I get pivot tables! Thank you soooooo! much man :-) You explain things great.
Glad the videos help !!! You can help me by clicking that Thumbs Up and commenting on each video : ) Sub too so you know when the new vids are posted : )
@yanka369 , I am glad that this video can help to reduce Excel PivotTable shakes!!!
To download the video, click on the link below the video.
link below video, in the Excel Basics Series section. Download the 2010 workbook.
You videos help me a lot. Really appreciated.
You are welcome!
Thanks for the lesson. I hope to use what I've learnt here at work.
The way you present is awesome.
Glad you like it!
@ContrastY , I am glad that the video is useful!
Yes, it is the Office series I have posted.
Great job. Simple and easy to understand.
Glad you like it!
I thought it was cool and good presentation. Pivot table makes works so much easier.
Thank you so much. Very very helpful and so easy to understand!
You are welcome!
Thank you so much. It was so helpful and pretty informative.
Glas the video helped!
Glad the video helped!
Glad you like it!
You are the man in this!!!! Excellent work
Thank you very much for all the videos. They are very easy to understand.
I really appreciate this video. Thank you very much for your kind effort. I got my job now..yaaaaay
Congratulations on getting the job!
You are welcome!
You are welcome!!
You may shake for a while, but after a small bit of practice, you will be a master!! :)
Cool! I am glad that it helps!
Cool! I am glad that you like it!!
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.
You can also group the dates you want and then drop the grouped date into Report Filter.
I love this channel. I learnt a lot about excel :) Thanks for your work!
cant thank you enough~it has helped me tremendously in obtaining a job!