Man....You really changed my life here!!! I work with data every single day and wherever you are - if you could have heard my scream of joy when I saw “repeat header rows” you would have laughed so hard! I LOVE Pivot Tables, my friends actually make fun of me because of my fascination with them - I use them constantly to view data and analyze it and I’ve been doing it for years. This video is incredible and I really appreciate your putting it out here! THANK YOU SIR!!!
Excellent video. Even though I already knew some options, I learned a lot. It is always surprising what Excel has to offer. Thank you for presenting the options in a bundled way.
I was on Sabbatical for 5 years and resumed working Learning these advanced features gives me high. I have been big fan of excel throughout my life. Power query is in my next to do list. Thank you for helping me catch-up so quickly. Regards Respect and Gratitude
@@HowToExcelBlog Yeah, I've already subscribed to your channel. Great work you're sharing. Any chance you could point me to the best video or maybe tell me a good approach to get the functionality of 2 different functions: CountIf (E.g. COUNTIF(G8:G2009,">0") as I don't want to count entries with a 0, but also the Aggregate function (E.g. AGGREGATE(3,5,G$8:G2009) so I can ignore hidden rows when I filter my data? I'd rather not just create an additional column of data to hold the CountIf value. But I know I can apply the aggregate to the CountIF data in that column, but hoping there is a better option? Thanks
i thought that there only a few things that i dont know about pivot table but i was wrong, there are still new things that i learned here. Many thanks. i will share this to my team members.
Wow! I did not know that there are so many pivot table options. Most of them I do not use, but now I can't wait to start using them! Great tutorial and very useful! Thanks very much!
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
Oo
The best video I have ever seen on advanced pivot table
I had subscribed to a paid 6 hours long course on Pivot tables.
This video of 20 minutes worth 10 times to that.
Thanks very much for sharing.
Thanks 🤣
Man....You really changed my life here!!! I work with data every single day and wherever you are - if you could have heard my scream of joy when I saw “repeat header rows” you would have laughed so hard! I LOVE Pivot Tables, my friends actually make fun of me because of my fascination with them - I use them constantly to view data and analyze it and I’ve been doing it for years. This video is incredible and I really appreciate your putting it out here! THANK YOU SIR!!!
If you love pivot tables, then you might have an emotional breakdown when you discover power pivot 💪😮
How To Excel that’s how I found you!!!
Excellent video. Even though I already knew some options, I learned a lot. It is always surprising what Excel has to offer. Thank you for presenting the options in a bundled way.
Yes, there's even more features than this video has 🙂
I was on Sabbatical for 5 years and resumed working
Learning these advanced features gives me high. I have been big fan of excel throughout my life.
Power query is in my next to do list.
Thank you for helping me catch-up so quickly. Regards Respect and Gratitude
The most useful pivot table video I have found and can apply to what I am doing right away! Thanks a million sir~
A concentrated presentation of useful pivot table features in a clear and concise manner. Impressively done. Thank you.
Two words...THANK YOU. Great presentation. Just what I needed.
Awesome tutorial....thank you..
You're welcome Vivek!
This is great! Just discovered your Tips and Tricks. Game changer.
Thanks Claire 🙂
thank you very much, this is very useful for me
Fantastic and great course for 5hose MS Excel functions and Pivot Tables. Thank you.
most useful excel tips I have seen on youtube , thanks
Thank you Giorgi! Your comments help keep me motivated!
This is wonderful. In less than 1.5 mins you have solved one of my biggest headaches. Thanks!
Glad to hear it helped!
Helpful. Constantly reminds me something I forgot. Thanks.
Excellent information on Pivot Tables in a very quick and concise manner - well done and thank you!
Glad you enjoyed it Kevin!
@@HowToExcelBlog Yeah, I've already subscribed to your channel. Great work you're sharing. Any chance you could point me to the best video or maybe tell me a good approach to get the functionality of 2 different functions: CountIf (E.g. COUNTIF(G8:G2009,">0") as I don't want to count entries with a 0, but also the Aggregate function (E.g. AGGREGATE(3,5,G$8:G2009) so I can ignore hidden rows when I filter my data? I'd rather not just create an additional column of data to hold the CountIf value. But I know I can apply the aggregate to the CountIF data in that column, but hoping there is a better option? Thanks
Your shared each and every shortcut formula cleared my concept in details...
Super... Learned few new features of Pivot
Great!
Very Useful for data analytics. Thanks for this video
Best Tips on pivot tables..very well explained..excellent..
Thanks Karthik!
Your tip & tricks is very helpful to my works, Thankyou
You're welcome. I'm glad you found it helpful Cornelius.
A million thanks to you for such thoughtful video.
You're welcome!
No more struggling with pivot tables! Great video, wish I'd found it sooner.
Glad to hear you'll soon be slaying data in pivot tables with ease 😎
Thank you, I like the 17th trick
Huge amount of info, simply presented. Thanks.
Thanks Kirk! 😀
Hi John , it was awesome to find your study material that is very useful
Thanks Shahid!
Awesome video. Thank you.
You're welcome!
i thought that there only a few things that i dont know about pivot table but i was wrong, there are still new things that i learned here. Many thanks. i will share this to my team members.
Good to hear you learnt a few new things!
It is a great tutorial for pivot table users to advance their job skills! Thank you very much!
Thanks for the note! Any tips you're going to start using for work?
Thumbs up button pressed with pleasure! Very well done summary of quite useful operations within a pivot table. Thanks for sharing.
Thanks Aristonville!
Super Helping, thanks a lot comrade
No problem my friend 👍
Thank you so much. This video is very comprehensive and helpful!
Wow! I did not know that there are so many pivot table options. Most of them I do not use, but now I can't wait to start using them! Great tutorial and very useful! Thanks very much!
Yep, pivot tables have a lot of great features and there are still many others not featured in the video.
Good Video, mostly known but good for beginners.
Beginner and advanced are all relative terms. What's beginner to the advanced user is advanced to the beginner user 😂
I'm a big fan of pivot tables and your tips gonna help me a lot. Thank you so much!!
Glad to help you out!
Great video, very useful and easy to understand. Thank you very much
Glad to hear you found it useful Gisela.
Good guide! I need pivot table for my tmr presentation! And I got you and Vanna Excel to learn in 1 hour! Thanks!
Thanks John, this video is great! I learn a lot
Glad to hear, keep up the learning!
You are great, providing very useful information regarding pivot table
Thanks Madhu!
Impressive and concise thank you.
Thanks for video, it was a quick refresher for me.👍
you are great teacher, god bless !
Welcome!
WOW. Excellent explanation. Thank you so much.
The most helpful pivot table I have watched, thank millions for you ❤️
No problem Mohamed. Glad you found it useful.
Thanks John. That's quite useful. Loved your simplicity.
Thanks Jay! Glad to hear you got some use out of it.
I'm not familiar with pivot yet but this video summarized what I should know and review. Thank you.
Excellent. Knew a few, but now know a lot more!!!!!!!😇😇😇😇😇
This is a very good video. Highly recommend.
Share, like and subscribe!
Very helpful, thank you!
Superb video. Many thanks!
Thanks Luda, glad you found it superb 😀
This was awesome, John. Right to the point. Thank you!
You're welcome! 🙂
Hats Off...Great John.. super useful!
Glad to hear you found it useful Roshan!
Excellent video. Really helpful..
Glad it helped!
Very useful. Thank you so much
You're welcome Roxana.
Really good to find your video courses!
😀
Very useful video. Thank you so much for sharing. 👍
Awesome!! Thank you for your time and dedication to present this video. Great help!!
Glad it helped you Oscar 🙂
Thank you for sharing these useful tips.
No problem Jose, glad you found them useful.
Very helpful. Thank you.
No problem!
Its really good and educative thank you
You're welcome Shinu 🙂
I've learned a lot from this video. Thank you so much. Greetings from Turkey ;)
Glad you found it useful and hello from Canada 🇨🇦
Very interesting tips--clear and concise.
Glad they were interesting to you Sonia!
Excellent tips thanks for posting
No problem Khalid!
THANK YOU VERY MUCH , EXCELLENT VIDEO
Excellent and clear presentaion
Great Video. I've learned new tips which will be definitely helpful for my career and studies. Thank you
Very useful and well presented pivot table presentation
Thanks Paul!
Great Info. Thanks
Thanks a lot. Very valuable information. 👍
No problem. Good to hear it was valuable to you.
I should have checked this before my current project analysis... It could have saved me a lot of time!
Very nice Tipps….learnt a lot!
Great to hear Ajay!
Excellent tutorial 👌🏻
Thanks
Very useful, nicely explained
Thanks Deepak! Glad you found it useful.
Excellent video, useful video
Thanks dear brother very very useful massage!!!!
No problem my friend!
Thank You, Sir!
You're welcome sir 🙂
Great John.. super useful! Even for some of the tips I know.. great reinforcement to see them in your video. Thumbs up!
Thanks! Great job explaining, learned new tips.
Great value in a single video. Big thumbs up, thank you
Very good presentation
Thanks!
Thank you so much for this very useful information 😇
You're welcome. Glad you found it useful.
great help even for me as beginnner on pivot table
Glad it helped!
very useful......................thanks
You're welcome Ibrahim!
Thank you very much for sharing :)
Learned some new stuff. Thanks!
Hi john really enjoyed your excel tips, your deliberation, your to the point explanation and clear accent and pase is Osum 😁
Thanks! Glad you liked it Muhammad!
Thank u very much sir...u r a great...got to learn a so many things....
You're welcome!
One of the best Tips on pivot tables..very well explained..excellent 👍👏
Thanks for the kind words Vyshnava!
Thank you so much, love your video. Very helpful
Thanks Tien, glad you enjoyed it!
Excellent Video on PvotTable. I recommend all to watch this video.
Thanks Kowser!
THANK YOU! THIS VIDEO IS REALLY AN EXCELLENT TUTORIAL TOOL!
Thanks John. Glad you think it's EXCELLENT! 😊
Excellent 👍👌👍
Informative....
Glad it help Mohammed!
thank you for a great video!
You're welcome Michelle.
Awesome thank you for the calculated field!
Glad it helped you out 👍
Perfect video on Pivot tables.
Thanks!
great vid! thanks!
Thanks!
Thank you so much!
i love this tutorial. Easy to understand and just get through the point exact what i want to know thank you!
Excellent Stuff
Thanks!