Excel Basics 5: PivotTable Power to Create Reports with Various Calculations & Layouts

[@neanderthal6845]

The way you speak is comfortable for non-English native speakers. Not too fast and understand totally. I cannot thank you enough.

[@excelisfun]

I am happy to help : )

[@jameszhou162]

Michael, you are by far the greatest teacher in my life hands down. The thing I love is that you teach things systematically and folks from all ages or levels can follow it through gradually. I have translated your work into Mandarin and did an internal training to my fellow accountants and they were all simply "shocked" to aware how little they know about Excel not to mention what Power BI can do. For majority of the repetitive reports can be done automatically by fresh and better yet timer to refresh. Heck, with most of my work automated, I got time to learn SQL language and Python to advance my career further. But most of all, ExcelisFun is always my place to humble myself :-). Thank you Mr. Girvin. Really appreciated it.

[@excelisfun]

Thank you for your very kind words! You are welcome for all the materials. It sounds like you have been watching and learning a long time.Be sure to help support excelisfun with those comments, Thumbs Ups and of course your Sub : )

[@123456789munish]

My mind is blown by your way of teaching and knowledge. PURE PERFECTION. Thank you for sharing these videos for free. Wish I had found your channel earlier!

[@関根由実]

👋😢🐮😢😫😫

[@bridgemasterx]

Hi. I consider myself an excel expert, but being self taught, I know that I have missed stuff along the way. Love your videos, as they fill these gaps, and I just enjoy watching them. Thanks.

[@excelisfun]

I am glad that the videos help fill in the gaps. Thank you for the support with your comments, Thumbs Up and Sub : )

[@joshualautenschlager3616]

I wish I had you as a teacher when I was in college! Amazing videos Mike, I have learned so much from them.

[@excelisfun]

I am glad that the videos help! Thanks for the support with your comment, Thumbs Up and Sub : )

[@meghnagautam5577]

So agree with you!!!

[@jannikretlow2860]

I agree with Traci and James (below): You ARE the best teacher in my life, hands down -- and you DO make Excel fun!!! (Janis Myrick here -- a former Highline Student from 2008 or 2009). I still use Excel almost daily at work -- and I still watch your videos (to refresh my Excel skills). Your videos help me to relearn something I've forgotten. Thank you for being so AWESOME!!!

[@excelisfun]

You are welcome, Fellow Highline Teammate, Janis!!!!! So lovely to hear from you : )

[@MrMingyong24]

Thank you so much Sensei! The length and efforts you went from the preparation of excel file, to the notes, and explaining every step by step, what's there not to love? It's just superb you are the best Excel instructor. Beginning from the very fundamentals which most teachers and students miss, you are the only one to throughly go through each concept. A top tier instructor. Thanks once again for making this world a better place. The basics course alone is at least worth thousands of dollars easily.

[@excelisfun]

Yup. When you love what you do, then you don't miss the small details and you put the details in a story telling order that helps to make complicated things less complicated. Most teachers on the planet earth either don't care or do not understand that story telling is the most important skill for a teacher.

[@MLiu-se1fi]

Excellent job! I really appreciate the combination of watching your tutorials and being able to immediately test my knowledge with your spreadsheets.

[@excelisfun]

Yes!!! I love to hear that, M. Liu!! Thanks for your your support : )

[@miraclepatron6465]

just stumble across your video's while looking where i can learn excel, right now i look no further .... Thanks so much

[@excelisfun]

You are welcome, miracle!!!!

[@kimchinguyen1241]

Thank so much for help. You are the best teacher so far.

[@excelisfun]

You are welcome, Kim!!!

[@ashishaggarwal2947]

If I were to thank Microsoft for inventing Excel then I thank you much more than that for making this so simple and easy for us to understand. You're a great teacher. Lots of love and wishes from India 💖👍🤗🙏

[@excelisfun]

You are welcome for the lessons, Ashish!!!! Thanks for the love and wishes : ) : )

[@ashishaggarwal2947]

@@excelisfun thanks again. I hope you and your family are doing fine during the pandemic 😊☺️

[@excelisfun]

@@ashishaggarwal2947 I hope you are your family are well too : )

[@ashishaggarwal2947]

@@excelisfun Yes. We're doing well. Thank and take care.!!

[@vivekkumar-fm1tq]

i cannot skip a single second because don't in which second u share useful information. that is the thing makes you different teacher from others... Carry on.. lots of love from india...

[@excelisfun]

That is true. All details in the stories that I construct are import. I am glad that you like it and the story helps you, vivek : )

[@ZsoltPal23092011]

Come to think of that I've been using Excel for ten years pretty much every day, and yet these "basic" videos teach me so much.. Thank you for your time and dedication!

[@excelisfun]

You are so welcome! It makes me happy to hear that you are learn so much from this series. The reality of Excel users is that the vast majority of users are just like you and me (in my early days), we just never got the full story and used Excel without many of the useful tools that Excel offers!

[@MilesOfGratitude]

Mike! I am a big believer that everyone should take their passion and share it with the world to make this place better. You have truly done that, and it is making such a positive impact. Thank you for teaching Excel in a way that people can understand and WANT to learn more. My sincere gratitude.

[@excelisfun]

You are welcome, Christina!!!!

[@RobMichaels1]

Thanks Mike. Even your "beginner" videos contain helpful tips and good spreadsheet practices useful to "non beginners"!

[@excelisfun]

You are welcome! Thanks for your support and appreciation : )

[@SK-bv6yd]

Whever I watch your videos ,I feel so thankful I found such an excellent Excel teacher!

[@srulitevlo3718]

JUST WOW I by mistake bumped into your videos And I'm glued I know excel quite well And still in each video I learned New stuff And your teaching skills Are just unbelievable I hope my kids will have such a good teacher as you Thank you

[@excelisfun]

Yes!!!! I am so happy that what I post helps : )

[@northshoreunitarians6417]

Took this class (as Janis Elain) back in 2008 or 2009 -- and every few years, I re-watch these videos to refresh my memory of the things I may have forgotten. It's always wonderful to see these again! Michael, you are still MY FAVOURITE TEACHER of all time!! (And I've told all my friends about your FREE Excel courses). You're the best!

[@excelisfun]

Janis Elain!!!!!!!!!!!!! I LOVE that you keep boomeranging back : ) What are you doing for work these dyas?

[@excelisfun]

Thanks for the shout out to your freinds! It helps me to achieve my goal of bringing free Excel Education to the world : )

[@twindaykonii7533]

I even paid an instructor to teach me formulas but it just got me confused. This is so much better!! Excel is really fun!

[@tvts5157]

This video is really very easy to follow and helpful. PivotTables really are very convenient and efficient. Thank You!

[@excelisfun]

@tvts5157 You comment went away, but I prepared a detailed message about your question for a cross tabulated report. Here it is: Variable at row header and variable at column header, then intersecting calculation uses the two variables to make the conditional calculation, For example, the sum of sales for the column variable "Northwest" and the row variable "Quad" is 83,155.58. That is the total not for all the sales, but just for sales made in the "Northwest" region for the product "Quad". It is called cross tab, because the variable at the column and the variable at the row come together as a cross - just like the picture at the beginning of the video. Tab means tabulated, like sum. Did you watch the video? I went through all of what I just wrote in careful detail in this video. Check it out - watch it again. A cross tab report is one of the most common reports and if you understand, it brings real power : ) Reply Reply

[@excelisfun]

You are welcome and glad the video helps : )

[@tvts5157]

@excelisfun I actually asked that question right when I started watching the video because you mentioned cross tabulated reports at the beginning without explaining it. So, I thought that it was something common and that you might not explain it in the video. But, as you said, you explained it in detail in the video further. That is why I deleted my comment as I understood what cross tabulated report meant.

[@sssussse]

Thanks a lot Mike. Each time I finish one or your videos I feel more confident and happy.

[@vancehunter5085]

Besides all your clear explanations, logically ( and in a clear entertaining voice ), your videos are loaded with helpful tips, and hot key shortcuts ... tremendous value!

[@excelisfun]

Glad they are valuable to you, Vance! Thanks for your support with Thumbs Ups, Comments and Sub : )

[@karenparsons8085]

I'm just starting seriously on my road to Excel, after using it on a basic level years ago. I'm a little intimidated but Michael Girvin is SUCH an amazing and vibrant instructor! Thank you so much!!!!!!

[@excelisfun]

You will do great in this class because for the first 5 videos I give an overview of everything, and then the next 20 videos I go into more details. Are you finding the files so you can follow along? and the pdf notes that summarize everything from the video? Also, here is the full class playlists, that allows you to join and then it remembers where you left off: kzbin.info/aero/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k

[@excelisfun]

You are welcome, and if you have trouble finding what you need, just ask : )

[@karenparsons8085]

@@excelisfun I have been downloading, saving, and following along with the files. THANK YOU SO MUCH! Very comprehensive! Thanks for the full class playlist also!!

[@karenparsons8085]

You may regret telling this I can do so! LOL. Thank you again!!

[@excelisfun]

@@karenparsons8085 No regrets. You can help me. How? Just be sure to click thumbs up and leave a comment on each video (this helps promote and get the free Excel eductaion to more people in the world). And of course your Sub : )

[@ajaydesai9694]

Thanks Michael Girvin. Your videos are very informative and teaches in a perfect manner. Pivet Table was my most weak point. Your videos helped me a lot in making feel easy & got rid of my fear. I am saving all your files in a special folder, " Excel Guru Files". Thanks for all your time. You must have received many hundreds of blessings from people like me. Ajay Shah. Dallas. Texas. US

[@excelisfun]

Your blessing and others help a lot thanks! Thanks for the support with your comment, Thumbs Up and Sub : )

[@andygaming2728]

You are a great teacher sir. Thank you for this amazing video's by far the best teacher in Excel I have ever seen.😃

[@excelisfun]

You are welcome, Andy!!!!!

[@helmyfenisia5266]

Hi Michael, I have watched many excel videos and your videos are the best. You have simple way to make people understand easily and make learning excel fun! And your keyboard shortcut really helps to make report finish faster. You are excellent teacher!

[@excelisfun]

You are welcome for the stories that I tell that try to make the complicated, less complicated, Helmy : ) : )

[@applesoranges559]

I love the "WELCOMEEEEE" ....its so welcomingly refreshing...makes my day all ready for a new class today from THE Teacher ..

[@excelisfun]

It is because I am happy to see you : )

[@MadhuraTaskar]

Your enthusiasm for Excel rings through your voice! It makes an otherwise plain video with just a computer screen interesting :D :D

[@excelisfun]

Glad you like the fun Excel videos, Madhura!!! Thanks for your support on each video with your comment, thumbs up and of course your Sub : )

[@zbigniewgora8283]

The best guy ever, professional lecturer!

[@excelisfun]

Glad it is best for you, Zbigniew!!! Thanks for the support with your comment, Thumbs Up and Sub : )

[@shwetanksinha1142]

i have search a lot for excel course but didn't find better than this. thank u very much for providing this course with a detailed explanation.

[@excelisfun]

You are welcome, Shwetank! Thanks for your support with comment, thumbs up and Sub : )

[@SamerDebs]

Best Excel Instructor period!

[@excelisfun]

Thanks for the kind words! I am glad that the video help! Thanks for the support with your comment, Thumbs Up and Sub : )

[@Saab1100]

Hi Mike, Just found your channel on KZbin and also just started to watch your Excel Video's, there is so much enthusiasm in your voice it is lovely to hear. I will be watching a lot more of these.

[@excelisfun]

Glad you found the channel and are finding the videos helpful. Thank you for the support with your comments, Thumbs Up and Sub : )

[@marcousgoose9195]

2:48 Create pivot table: Alt + N + V 4:58 Cross-tabulated report (two criteria (or conditions) 6:16 Can use "ctrl" and selecting desired cells and then look at the status bar 6:57 8:03 Changing calculation of the "Values" column Select a single cell in the "Values" column -> "Summarize Values By" -> select desired choice 9:31-10:25 What if you need to count how many sales in each region 10:25 Boss wants one report for count and one for the total sales Highlight entire pivot table -> "ctrl" + "C" -> paste -> remove "Count of Region" -> drag "Sales" to "Values" 11:58 Shortcut to jump to top and bottom Jump to top - "ctrl" + "up arrow" Jump to bottom - "ctrl" + "down arrow" 16:46-19:24 Filter "Analyze" -> insert "Slicer"

[@lingc9195]

I am watching one video every day! I have never thought I would ever be good at Excel (in fact, I did not even want to learn excel) but now I feel like an expert haha! You are an amazing teacher!!!! Thank you sir:) Excel is so much fun learning with your videos!

[@excelisfun]

You definitely can become an Expert, Ling! It will be fun : )

[@taimoorawan]

the way you explain everything makes it so interesting to learn. you are my first choice if I want a solution to my excel problems.

[@excelisfun]

I am glad to help! Yes, a good explanation, or story about the topic, can make the complicated, less complicated : )

[@KWChamonix]

Really appreciate the way you explain, so easy to understand formulas that are sometimes difficult

[@excelisfun]

You are welcome! Thank you for the support with your comment, Thumbs Up and Sub : )

[@manouksatamian8300]

Excellent job mike , waiting the publishing of Your valuable book , keep us in touch as soon as the book is ready . I hope everybody in the comments list will like to have it despite the price . God bless you Mike , Your job is too much appreciated .

[@excelisfun]

You are very welcome, Manouk : ) : )

[@excelisfun]

@tvts5157 You comment went away, but I prepared a detailed message about your question for a cross tabulated report. Here it is: Variable at row header and variable at column header, then intersecting calculation uses the two variables to make the conditional calculation, For example, the sum of sales for the column variable "Northwest" and the row variable "Quad" is 83,155.58. That is the total not for all the sales, but just for sales made in the "Northwest" region for the product "Quad". It is called cross tab, because the variable at the column and the variable at the row come together as a cross - just like the picture at the beginning of the video. Tab means tabulated, like sum. Did you watch the video? I went through all of what I just wrote in careful detail in this video. Check it out - watch it again. A cross tab report is one of the most common reports and if you understand, it brings real power : ) Reply

[@MonirulIslam-zj3ve]

Sir, Your every video is more than excellent. I am so confident that there is no other advanced tutorial and trainer like you. I am not interested to follow any other trainer's tutorial if you have tutorial in which I am interested to learn. If it is possible, I will give a lot of Thumbs Up in every of your videos. We need trainer like you to make the world more better. I usually suggest to download and follow your videos whoever want to learn excel meeting with me. Thanks a lot to keep love and patience in your teaching field.

[@excelisfun]

Glad that the videos and teaching helps! Thanks for the support with your comments, Thumbs Up and Sub : ) Please tell all your friends and colleagues to come and learn for free at KZbin : )

[@PRATEEKsirji]

Your basics series is much better than many self proclaimed excel gurus out there. So I would like to thank for making learning excel easy. I have just one question for this video, at 18:00 you entered slicer tool option where one can see data according to sales rep. but what if we want to go back and see data again in total. I mean once we add slicer, data appears to be sliced according to different sales rep. what if we want to see total sales figure again without slicer effect? How to do that?

[@excelisfun]

Glad you like my classes! Been posting free classes at KZbin for past 14 years : )

[@excelisfun]

To "unslice", if that is what you mean, click the un-filter button in the top right corner of the Slicer.

[@PRATEEKsirji]

@@excelisfun Thank you ! It worked..

[@excelisfun]

@@PRATEEKsirji Yes!!! Love your cat picture : )

[@PRATEEKsirji]

@@excelisfun Haha 😂 thank you 😄

[@lonchuot8990]

You've made Excel a lot more learn-able!! Thanks sooo much!!!

[@excelisfun]

I am glad that Excel is more learn-able!!! Thanks for the support with your comment, Thumbs Up and Sub : )

[@alyssamcwhorter7905]

😮 WOW 😮 !!! That was amazing! Loving the pivot tables. Can not WAIT to see what I learn next. EPIC and life changing. Excel is SO fun. Thank you!

[@excelisfun]

Thank you so much for the kind words! I am glad the series helps! Thank you for the support with your comment, Thumbs Up and Sub : )

[@WOS1962]

I think I've been addicted to watching your videos because every day I have to follow at least one lesson.

[@excelisfun]

That is great! They will help you to become awesome with Excel and do great things in your job !!! Thanks for your support with Thumbs Ups, Comments and Sub : )

[@sherrihackett7374]

THESE ARE AMAZING!!!! ITS REMEMBERING EVERYTHING WHEN I AM NOT WORKING EVERYDAY AND TRYING TO GET BACK INTO THE JOB MARKET

[@excelisfun]

SUPER GLAD THEY HELP!!!! Thanks for the support with your comment, Thumbs Up and Sub : )

[@peterwoods35]

Thank you. Now I finally understand slicers. A filter on steroids. Thanks

[@excelisfun]

Love your description: A filter on steroids : ) : )

[@peterwoods35]

@@excelisfun Your explanation and analysis of Excel are superior.

[@excelisfun]

@@peterwoods35 I am glad my detailed story telling helps! : )

[@guymagen1944]

By far the best tutor I've encountered! Thank you so much '🙏

[@excelisfun]

You are welcome very much!!!!

[@tracichristenson9957]

OMIGOD!!!! Excel really IS fun!!!! Lol... I'm cancelling my Netflix!!!

[@alexandrailubs2945]

Traci Christenson 😂👌🏻

[@andrewmtgx]

lol is excel useful to see your spending???

[@michaelanazodo5939]

Wild😂😂

[@samnunshams6093]

So much fun; love the way you explain

[@excelisfun]

Glad you like the videos and the fun!!!!!

[@chandu7spark]

The way of your teaching is making my mind to listen to your next video.:)

[@ashrafmohd3056]

Thanks a lot . please do not stop , your videos are very useful and are the best in youtube .

[@excelisfun]

You are welcome a lot! I will keep posting : )

[@shivakant4698]

Very Good sir your teaching is amazing.

[@excelisfun]

Glad you like the videos and teaching, Shiva!!!!

[@lenkaadamova2349]

Thank you very much for all your effort you put into making all those videos. Reall thankful that I have found it on youtube. I am starting to like Excel more and more because you really make it look easy and fun. So thank you for your passion and hard work.

[@excelisfun]

You are welcome, Lenka!!!!

[@joserea2993]

Excellent way to learn very helpful

[@sawaimalhi8439]

very nice sir each and every your notes files so usefull for all love you sir ...

[@excelisfun]

Thanks for the love - I am glad that it all helps : )

[@SteveCancel78]

Loving your videos! This is an amazing excel tutorial. Thanks for all the hard work!

[@excelisfun]

You are welcome for all the hrd work! Thanks for the support with your comment, Thumbs Up and Sub : )

[@rishajagadish2983]

I LOVE your videos! You make everything so concise, easy and fun

[@excelisfun]

You are welcome for the concise, easy and fun Excel, Risha!!!!

[@shajupauljohn3244]

Hi Mike, You are a true Excel Genius

[@excelisfun]

Just a guy having fun with Excel ; ) Glad the videos help, Shaju!!!

[@Irissssss416]

I am learning so much. You really do make it fun. I am on a roll!!!

[@excelisfun]

Rock on, Iris : ) : )

[@lascur0513]

heres my notes from this video for others to view: I took notes using Online Excel in browser which has slightly different access to features/tools keybind: alt + n, then alt + v = create a pivot table. useful for when you create pivot tables at a high frequency Why is a PivotTable called a "pivot" table? because you can easily change it on the fly with the click or drag of a field, drastically changing how the data is represented cross tabulated report - any intersecting value shows by adding with any two conditions right click pivot table a number value in pivot table -> summarize value by... avg, sum, count, etc. this is a great quick way to change the data's representation for your needs how to tell if you have a large dataset? try this keybind: ctrl + downArrow. this brings you all the way down the table until you hit an empty cell, then you can check the row number on the left to increase a column/row's width/height, click the first column/row you want to select, drag select across, then do the click n drag to increase or decrease to change the design of the pivot table, click Design (or in Excel365, PivotTable), then find the styles ribbon to select/customize a style to filter a pivot table by a certain value within a field, like Sales Rep for example, go to pivot table's Field List, drag Sales Rep in filters, click the drop down for Sales Rep and select "Add as Slicer". From here you can choose a sales rep to filter by, and you can also select the multi-filter button at the top to select multiple sales reps to filter by. OR you can go to ribbon tab Analyze (or "PivotTable" for excel365), click "Insert slicer". from here you can do the same thing as stated above, but its a little easier to access and use. right click slicer pop-out and click settings to customize it when right clicking a row or column, you can insert rows/columns above/below || left/right

[@excelisfun]

A+ grade on your notes : ) Thanks for sharing with the whole Team!!!!

[@lascur0513]

@@excelisfun no no, thank you. I didn't think learning excel could actually be fun, but you make it fun! I really appreciate your free education, you are doing a fantastic service.

[@ndelpurg]

its and honor and privilege to attend your class !

[@excelisfun]

I am happy to provide it to you : )

[@isealiman]

Hey Mike, your class are so accurate and helpful, Thanks

[@excelisfun]

You are welcome, becher! Thanks for the support with your comment, Thumbs Up and Sub : )

[@ahmedali-oi9wv]

with your voice Mr. Mike , Excel is fun indeed . thx

[@mohamedamin3393]

Teaching is the greatest act of optimism - Colleen Wilcox

[@sayeedlashkari833]

Mike, thank you so much for your greate videos. You are really doing a great job and the videos you make change millions people application system skills.

[@excelisfun]

Yes, sayeed, that has been mt goal here at KZbin since 2008: Free Excel Education for the world : )

[@siansuanpau1]

Thanks a lot. I really appreciate you for all these lessons. God bless you.

[@coreamv2802]

It's really fun to follow through all your work on my own database Keep it up !!!!

[@excelisfun]

Glad it helps, CoreAmv!!!!

[@Ramzankhan-nk1ls]

Thanks a lot for teaching Excel God bless you.

[@excelisfun]

You are welcome! Thanks for the support with your comment, Thumbs Up and Sub : )

[@Ramzankhan-nk1ls]

Thanks Sir

[@aamir_curious]

you're awesome, prof!

[@excelisfun]

Go Team!!!!!!

[@aammar7987]

Your way of teaching is very interesting, keep it up 👆

[@excelisfun]

Okay! I will do that : ) Thanks for your support, Abd!!!!

[@guruntr6481]

Thanks Mike....you're doing a great job!!!

[@excelisfun]

Glad you like the vids! Thanks for the support with your comment, Thumbs Up and Sub : )

[@mohamedchakroun4973]

Hi Mike Thankssss a lot for this great reviewww in excel it make us more perfectionist your are awsome I really like watching and hearing you teaches Excel you are the best.

[@excelisfun]

You are welllllllllllllllcommme!!! Thank you very much for your kind words : )

[@SyedMuzammilMahasanShahi]

Yet another EXCELlent video. Thanks Mike.

[@excelisfun]

You are welcome : )

[@khayrulamin5412]

Thanks a lot. I learn a lot of from your online class.

[@excelisfun]

You are welcome! Thanks for watching and thanks for your support with comment. Thumbs up and Sub : )

[@khayrulamin5412]

It' possible to add slicer in pie chart to make the pie chart by pivot table. I add slicer but when use percentage show 100%. Can you help me?

[@anubhavwadhwaindia]

Thank you so much for this slicer thing... My life is much more easier now... 🙏🙏🙏

[@excelisfun]

You are welcome! Slicers are so easy. Thank you for your support, anubhav, with your comments, thumbs ups and of course your Sub : )

[@ББИ184]

Absolutely great video, you are awesome teacher! Thanks for homework files, really helps to learn the formulas and shortcuts!

[@excelisfun]

You are welcome!!!

[@ld-vh8jx]

the best education i have ever seen

[@excelisfun]

Thanks for the kind words, lucija!!!! Thanks for your support with your comment, Thumbs Up and Sub : )

[@rc-mp9ys]

Using slicer has been such a joy

[@excelisfun]

O, Yes! The simple joys in life: Slicer in a PivotTable : ) Thanks for your support, rc, with your comment, Thumbs Up and Sub !!!!

[@fatimazehra4881]

simply incredible please upload more ExcellsFun Python, SAP, C++, ERP, Payroll, Invoicing, etc. videos

[@texman1166]

Thank you, sir. You are magnificent.

[@excelisfun]

Glad it helps, TexMan11!!! Thank you for your support : )

[@playlistyee8099]

wow amazing again. Every video is very informative keep up the good work!

[@excelisfun]

Glad the videos help, Playlist Yee!!!!

[@Nyuklehead]

Thank you for another fantastic video! I can definitely use this to spruce up some of my spreadsheets in the office.

[@excelisfun]

Sprucing up is good ; )

[@darinsejkora3267]

Exceptional trainer!!

[@excelisfun3903]

Glad it helps, Darin!!!! Thank you for the support with your comment, Thumbs Up and Sub : )

[@WayneThompson1101]

very clear explanation, thanks so much for doing these videos!

[@excelisfun]

You are welcome, Wayne!!!

[@favourphilicvictor1059]

God bless, you have made it too easy to learn

[@excelisfun]

You are welcome for the easy and fun : )

[@vishnu8899]

Ha ha ha love the comedic timing at 4:11

[@excelisfun]

Just having fun ; )

[@Nobody_AL]

Thank you so much for the good work..It really helped me a lot to learn tricks!

[@excelisfun]

You are welcome, Aliyasmin!!!! Thanks for the support with your comment, Thumbs Up and Sub : )

[@yashgattani1082]

Really awesome videos! I have learnt so much. Thanks a lot!

[@excelisfun]

You are welcome, Yash : )

[@Fendy1]

I enjoyed following that - I think I learned something too!

[@excelisfun]

Learning something is always EXCELlent! Thank you for the support with your comments, Thumbs Up and Sub : )

[@amehziishike4061]

Just brilliant!!!

[@excelisfun]

Glad it helps!!!

[@quentindaniels7460]

Love it! Thanks for the video, Mike!

[@excelisfun]

You are welcome, Frank!!!! Thanks for the support : )

[@ismailismaili0071]

Thank you Mr. Mike the video is really useful

[@excelisfun]

You are welcome for the useful video! Thanks for your support : )

[@ismailismaili0071]

ExcelIsFun I'm the one who should thanks u Mr. Mike you are helping us to be great in our Jobs

[@daries]

One more time, thank you, great videos.

[@excelisfun]

You are welcome! Your comments on each video are greatly appreciated, daries : )

[@NeoJack-one]

it feels as if your my best Friend who make learning alot easy and fun

[@excelisfun]

I am here to teach and help you with Excel, nitesh!!!!

[@NeoJack-one]

@@excelisfun thanks man !!😊

[@Saad-GamingZ]

This is a great video to learn Pivot table for beginners

[@excelisfun]

Glad the video helps, Mohammad!!!! Thanks for the support with your comment, Thumbs Up and Sub : )

[@Howtoexcelatexcel]

Good solid stuff Mike as ever.

[@excelisfun]

Thanks!

[@sohailyounas9645]

superb video and great efforts

[@johnsoe7385]

Thank Sir . Very good video . May GOD bless you.

[@excelisfun]

You are welcome, JOHN SOE : ) Thanks for your support on each video you learn from with your comment, thumbs up and of course your Sub : )

[@donghuaye3722]

Pivot Table is really powerful.

[@excelisfun]

Yes, there are few other tools in the world that help people to easily summarize data to make calculations with criteria than the PivotTable!!!!! Thank you very much for your support, Donghua Ye!!!

[@AbelTravel]

Thanks Mike. Very helpful.

[@excelisfun]

You are welcome, Karen! Thanks for the support : )

[@kisslaci36]

great video. thanks for the upload.

[@excelisfun]

You are welcome! Thanks for the support : )