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
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 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.
thanks for learning me the modalities of pivot table if you have any such video for power BI kindly share. Now i am learning to master power BI so be my tutor. thanks a lit again
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!
An exceptional video. Very well done. I knew about 2/3 of these but watching the whole was well worth it. Q: re show values as % - the default option is clear. BUT I want to to show values as % of Column total but ignore filters constraints. Is there a way to do that? I haven't found one.
Thanks for these super tips. Can I please make a comment about "recreating the source data that may have been deleted" segment of your video? When one uses the "Show Details" trick on the grand total cell (which is a life saver) the name of the table recreated will not match the "Original" name of the Table used when the PT was created. Thus the PT will not be able to refresh. So all one needs to do is to click on "Change Data Source" of the Pivot Table to see what was the name of the "lost" table, copy it and paste it in the newly resurrected "Table Name" from the Table Tools tab. Now adding row to that table will allow the PT to refresh as expected. Tks for giving me to opportunity to add this pointer. Keep up the great work...
@@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
Very good video. But while practicing with the same working file when I create a new pivot with the same source data try grouping i get the error" cannot group that selection". I tried online sources there are no blank data . But the same works in your pivot. Any idea?
Thanks! Very Nice. I do have to say that so far I am on number 10 and your number 8 and 10 don't work on Macbook. 8. Group Date Fields Into Ranges and 10. Automatically Create a Pivot Table for each Item in a Filter. Rest I have not even tried.
Dear Sir, Very very nice & useful information. THANKS. But I have a problem, I want calculations for my inventory. Like opening balance +purchased-sale=closing balance. I want to it in calculate feild. How it is possible?please help me out. THANKS.
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
Oo
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 🤣
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 best video I have ever seen on advanced pivot table
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!!!
The most useful pivot table video I have found and can apply to what I am doing right away! Thanks a million 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.
Yes, there's even more features than this video has 🙂
A concentrated presentation of useful pivot table features in a clear and concise manner. Impressively done. Thank you.
Awesome tutorial....thank you..
You're welcome Vivek!
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!
Two words...THANK YOU. Great presentation. Just what I needed.
thank you very much, this is very useful for me
This is wonderful. In less than 1.5 mins you have solved one of my biggest headaches. Thanks!
Glad to hear it helped!
Fantastic and great course for 5hose MS Excel functions and Pivot Tables. Thank you.
Your shared each and every shortcut formula cleared my concept in details...
Best Tips on pivot tables..very well explained..excellent..
Thanks Karthik!
Thank you for not having a super thick accent that greatly reduces the communication of the content.
This is a very good video. Highly recommend.
Share, like and subscribe!
Thank you, I like the 17th trick
Your tip & tricks is very helpful to my works, Thankyou
You're welcome. I'm glad you found it helpful Cornelius.
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 😎
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 😂
Thanks for video, it was a quick refresher for me.👍
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!!!!!!!😇😇😇😇😇
Excellent video. Really helpful..
Glad it helped!
most useful excel tips I have seen on youtube , thanks
Thank you Giorgi! Your comments help keep me motivated!
Helpful. Constantly reminds me something I forgot. Thanks.
Very Useful for data analytics. Thanks for this video
Excellent and clear presentaion
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?
thanks for learning me the modalities of pivot table if you have any such video for power BI kindly share.
Now i am learning to master power BI so be my tutor.
thanks a lit again
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.
This is great! Just discovered your Tips and Tricks. Game changer.
Thanks Claire 🙂
Wonderful exlplanation & these is not shared in any videos - all were unknown tips
Glad you liked it!
Thank you so much for great tips! Do we need always mark "Refresh data when opening the file"? if answer is no, please explain...
Is someone else going to be adding data to the workbook without you knowing? Enable that option to always refresh so you don't miss the new data.
Very very helpful, thank you
You're welcome Jalaram. Glad you found it helpful 🙂
very useful......................thanks
You're welcome Ibrahim!
Super sir
Thanks Krishna!
Its really good and educative thank you
You're welcome Shinu 🙂
you are great teacher, god bless !
Welcome!
An exceptional video. Very well done. I knew about 2/3 of these but watching the whole was well worth it.
Q: re show values as % - the default option is clear. BUT I want to to show values as % of Column total but ignore filters constraints. Is there a way to do that? I haven't found one.
You'll need to use some DAX formulas for that.
Super Helping, thanks a lot comrade
No problem my friend 👍
Super... Learned few new features of Pivot
Great!
Thanks for these super tips. Can I please make a comment about "recreating the source data that may have been deleted" segment of your video? When one uses the "Show Details" trick on the grand total cell (which is a life saver) the name of the table recreated will not match the "Original" name of the Table used when the PT was created. Thus the PT will not be able to refresh. So all one needs to do is to click on "Change Data Source" of the Pivot Table to see what was the name of the "lost" table, copy it and paste it in the newly resurrected "Table Name" from the Table Tools tab. Now adding row to that table will allow the PT to refresh as expected.
Tks for giving me to opportunity to add this pointer. Keep up the great work...
Thanks Toni, great tip!
Helpful!
I should have checked this before my current project analysis... It could have saved me a lot of time!
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
Excellent - I will make my life much easier. GREAT! I knew some of them, but some new very good tools!
Yes, pivot tables have a few great hidden features.
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!
Very good presentation
Thanks!
A million thanks to you for such thoughtful video.
You're welcome!
great help even for me as beginnner on pivot table
Glad it helped!
The most helpful pivot table I have watched, thank millions for you ❤️
No problem Mohamed. Glad you found it useful.
Huge amount of info, simply presented. Thanks.
Thanks Kirk! 😀
Awesome video. Thank you.
You're welcome!
You are great, providing very useful information regarding pivot table
Thanks Madhu!
Great John.. super useful! Even for some of the tips I know.. great reinforcement to see them in your video. Thumbs up!
THANK YOU VERY MUCH , EXCELLENT VIDEO
Helpful tips. Thanks for providing the video
No problem, you're welcome 👍
Hi John , it was awesome to find your study material that is very useful
Thanks Shahid!
Great video, very useful and easy to understand. Thank you very much
Glad to hear you found it useful Gisela.
thanks from Vietnam
You're welcome, from Canada 🇨🇦 🙂
this is quite useful, simple, short.
Good guide! I need pivot table for my tmr presentation! And I got you and Vanna Excel to learn in 1 hour! Thanks!
Impressive and concise thank you.
Now i realize i suffered a lot in the last 15 years not knowing so many excellent excel tips. Thank you Man
Table trick is a good one.
Yep, if it's data in a table format put it in a table.
Thank you so much. This video is very comprehensive and helpful!
Thank you so much
Welcome Ajay!
That's so amazing! Explained with such an ease! can you suggest any exercises to practice the learned info?
Gergana Eugenie squats
Thumbs up button pressed with pleasure! Very well done summary of quite useful operations within a pivot table. Thanks for sharing.
Thanks Aristonville!
Really great pivot table video. Thank you.
Thanks Eric! You're welcome!
Superb indeed
Thanks Faisal
WOW. Excellent explanation. Thank you so much.
Very good video. But while practicing with the same working file when I create a new pivot with the same source data try grouping i get the error" cannot group that selection". I tried online sources there are no blank data . But the same works in your pivot. Any idea?
Is your data in the data model? Grouping isn't available for that.
it was awesome.. Pls share u r guide to know in detail.
Very useful video. Thank you so much for sharing. 👍
This is very helpful. Thanks a lot for the tips
You're welcome!
Excellent Stuff
Thanks!
Excellent compilation!!
Thanks Sarah!
Thanks John. That's quite useful. Loved your simplicity.
Thanks Jay! Glad to hear you got some use out of it.
Very Great Video
Thanks!
One of the best Tips on pivot tables..very well explained..excellent 👍👏
Thanks for the kind words Vyshnava!
Thanks John, this video is great! I learn a lot
Glad to hear, keep up the learning!
Thanks! Very Nice. I do have to say that so far I am on number 10 and your number 8 and 10 don't work on Macbook. 8. Group Date Fields Into Ranges and 10. Automatically Create a Pivot Table for each Item in a Filter. Rest I have not even tried.
Lots of things don't work on Mac unfortunately.
@@HowToExcelBlog Thank you! It is really nice that you are sharing your knowledge with us. May God bless you.
Excellent video, useful video
Interesting Lesson
Thanks Ayena!
Thanks dear brother very very useful massage!!!!
No problem my friend!
Wow. This was an incredible video. You helped me solve more than for annoying problems that I face daily.
Thanks Dan. Glad it helped.
What were the annoying problems?
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!
Great value in a single video. Big thumbs up, thank you
I've learned a lot from this video. Thank you so much. Greetings from Turkey ;)
Glad you found it useful and hello from Canada 🇨🇦
Great Info. Thanks
Great Video. I've learned new tips which will be definitely helpful for my career and studies. Thank you
great content, i knew most of it, but few useful things i had no idea existed in excel, like creating multiple sheets with pivot tables
Good to hear it expanded your knowledge 🙂
Dear Sir,
Very very nice & useful information. THANKS. But I have a problem,
I want calculations for my inventory. Like opening balance +purchased-sale=closing balance. I want to it in calculate feild. How it is possible?please help me out.
THANKS.
Depends how your data is structured. If calculated columns won't do it, try the data model and DAX formulas.
Thank u very much sir...u r a great...got to learn a so many things....
You're welcome!
Excellent tutorial 👌🏻
Thanks
Hats Off...Great John.. super useful!
Glad to hear you found it useful Roshan!
Excellent Video on PvotTable. I recommend all to watch this video.
Thanks Kowser!