Hi Chandoo Thank for this tutorial, it is indeed very deep on how to use pivot tables. I realy enjoy you tutorials, my skills are getting better and better.
I am a MBA student, my aim is to be a data analyst. i am following your every videos for my learning. Thanks so much sir. looking for more interesting corporate related videos
You are one of the best teacher i have come across. You are simply awesome! Thank you Chandoo :) Also, any sources where i could practice more on pivot tables?
Hi Avinash.. thank you. I suggest visiting the below links for everything on Pivot Tables 1. chandoo.org/wp/excel-pivot-tables-tutorial/ 2. chandoo.org/wp/pivot-table-time-saving-tricks/ 3. chandoo.org/wp/advanced-pivot-tables/ All the best.
Thank you so much sir .LOVE AND BLESSINGS ALL THE WAY FROM CHANDIGARH,INDIA. I AM ABOUT TO JOIN A BIG 4 AS AN AUDIT ASSISTANT,SO THIS WOULD BE REALLY HELPFUL.
Thank you This was so helpful What if you change the amounts of different cells, or correct names spellings etc Will the refresh button update the pivot tables What you have shown is just new data addition I will be grateful if you advise Thank you
Hi Sir, I am stuck with a college project. I am using Pivot, but I have a column where each text value is hyperlinked. The hyperlinks are not working in the pivot. Could you help me here? Or if you have any video on that? I could not find any solution for this on your channel. Please advise :)
You don't need to go to Value field settings, dude.. @12:58 after the right click there's an option for Number format..just use that which can skip an extra step.
If you have a custom list, you need to apply A->Z sorting order on the data to tell Excel to use the custom list for sort order (For ex. this works for Jan, feb, mar... dec sorting).
Hovering mouse while explaining is distracting from learning... Our focus is being diverted to the movement of the mouse. Just a feedback but not a comment...
Amazing. I learned loads. Greetings from Ireland 🇮🇪
You're the only Indian I've seen so far that teach using English Language so that I can understand, bravo and many thanks!
Hi Chandoo
Thank for this tutorial, it is indeed very deep on how to use pivot tables.
I realy enjoy you tutorials, my skills are getting better and better.
Thank you sir. You are real hero.God bless you
You are welcome Rohit. More power to you 😀
Thank you so much for this tutorial it's easy to follow!
Absolutely helpful! I'll recommend your tutorials over and over again. Thank you!
Nice overview of Pivot tables. People will start liking pivot tables and realize the benefits of a powerful tool.
Wonderful as always
Your explanation is awesome
😀Finally understood pivot table
A lot I have learned from this ❤❤❤thanks.
Thanking You Chandoo Garu
very proud that ur telugu
Thank you for posting! I've been intimidated by pivot tables for a long time, but your explanation was fantastic! You're a natural teacher.
same here
Amazing! Thanks
Thanks Chandoo!!
Thanks for sharing. I find it useful and precise
best teacher ever
Thank you for sharing. This information is very helpful! Awesome Job.
Thank you for creating such good lessons💛
I am blessed to have you.
Hey chandoo! thanks for this wonderful lesson. Love from India
My pleasure!
chandoo you are one of the lovely teacher ♥
Thanks Hazem for your love and support 😍
@@chandoo_ we are learning and from our duties support you ♥
Thank for making this very east to follow! Looking forward to Power Pivot videos :)
Awesome Tutorial bro!!
Glad you liked it!
I am a MBA student, my aim is to be a data analyst. i am following your every videos for my learning. Thanks so much sir.
looking for more interesting corporate related videos
Bhai me bhe data analyst kr na chata hu pr plz tum thora guide kero
awesome vedio sir
Thank you so much
Love from nepal
So nice. Dhanyavad... 🙏
Amazing tutorial
Glad you think so!
You are one of the best teacher i have come across. You are simply awesome! Thank you Chandoo :)
Also, any sources where i could practice more on pivot tables?
Hi Avinash.. thank you. I suggest visiting the below links for everything on Pivot Tables
1. chandoo.org/wp/excel-pivot-tables-tutorial/
2. chandoo.org/wp/pivot-table-time-saving-tricks/
3. chandoo.org/wp/advanced-pivot-tables/
All the best.
@@chandoo_ Thanks man! :)
It's amazing . thanks. Chandoo !!
Great work 👍😎👍👍😎
You are welcome JPR....
Thank you so much sir .LOVE AND BLESSINGS ALL THE WAY FROM CHANDIGARH,INDIA.
I AM ABOUT TO JOIN A BIG 4 AS AN AUDIT ASSISTANT,SO THIS WOULD BE REALLY HELPFUL.
All the best
Thank you
This was so helpful
What if you change the amounts of different cells, or correct names spellings etc Will the refresh button update the pivot tables
What you have shown is just new data addition
I will be grateful if you advise
Thank you
Thanks sir
Hi Sir, I am stuck with a college project. I am using Pivot, but I have a column where each text value is hyperlinked. The hyperlinks are not working in the pivot.
Could you help me here? Or if you have any video on that? I could not find any solution for this on your channel.
Please advise :)
Is there any video available for advanced usage of pivot ?
Please see this play list - th-cam.com/play/PLmejDGrsgFyBH0zkiwAXsDLMMyGEO2hsx.html
What version of excel you are using? I have not seen the "Table Design" on Excel before
You don't need to go to Value field settings, dude.. @12:58 after the right click there's an option for Number format..just use that which can skip an extra step.
Wow, that is new. I have been using the value field settings route for so many years. Thanks for sharing this :)
@@chandoo_ You're welcome and you proved you are not a robot by doiing that. Captcha is success, access approved..hehehe
Chandoo garu pivot tables in custom sorting Chusthuntey avatledhu
If you have a custom list, you need to apply A->Z sorting order on the data to tell Excel to use the custom list for sort order (For ex. this works for Jan, feb, mar... dec sorting).
@@chandoo_ Super Sir, But nenu slicers ni change chesaka malli normal order ki velthundi daniki em cheyali ala avakundha vundali antey.
Sir
Will you make goods stock report
In excel sheet ?
If you already have please tell me.
Interesting idea. I will share a template on this soon.
Why don't you make a video on that
👍
Hovering mouse while explaining is distracting from learning... Our focus is being diverted to the movement of the mouse. Just a feedback but not a comment...
Thanks Venu... This video is before I learned about that.