Thanks a lot, basically under rows we have to write (group by features, we can move some features to columns if required) , where condition in filters, which features to aggregate and what to aggregate in the Values box-- for those coming from sql background this will be useful.
College never taught us important things like this. I'm so glad there are people like you who willingly teaches important things for an adult for free. Bless your channel. ❤️
Dear Chandoo, I have watched many other instructional Excel videos, but your videos make learning Excel easy and fun. You are a gifted person and a delightful teacher. I am grateful for your knowledge, kindness and humor. Thank you! 💯💫🍟
Even after you know something about an Excel feature, when Chandoo teaches it, you get to learn something more and often unknown that adds value. Keep up the great work Chandoo! 😊👍
Usually, these online tutorials are soooo dry that I get bored and quit before they finish;, but with Chandoos online tutorials, it's like you've turned around to ask a close colleague for help. That said, the only improvement, at least from my chair, is that often I couldn't see past your head as it was blocking the bottom of the PivotTable Fields, but aside from that...excellent!
this is just like concepts freshen up video for those who r following the entire playlist because all the parts we studied are used in one way or the other
I hope I would have got to know about this earlier. I would not fail at interview saying I dont advanced excel.. Thank you so much. Now I can strongly recommend anyone this channel and hope you reach millions of subscribers soon. Now I am confident enough to face the next interview in Investment Banking...
Thanks a lot, basically under rows we have to write (group by features, we can move some features to columns if required) , where condition in filters, which features to aggregate and what to aggregate in the Values box-- for those coming from sql background this will be useful.
I just love to come to your channel to learn whenever I have a doubt in excel. Even if I know the concept well, if I come to your channel, I am sure that I will always get to know something more. Please keep sharing such interactive videos and I still don't know how to select custom data for a chart or a graph to represent on x and y axis. I would love to see you upload a video on this topic. Thank you
I am the new learner and I see this video is only the best with which I can learn .. Thanks for these types of video and I would request u to make a video on business analyst if u r new comer then how u can become business analyst with another working experience
Chandoo!!! this the nice presentation on Pivot Table and Slicer, also I liked the conciseness of the tutorial. Please continue the same in next video so that we can get maximum in minimum.
Thanks Nirmal. I am learning how to make better, concise and powerful videos. I am glad this one hit the nail on head. I will observe the video performance and make changes to my storytelling as needed.
When he said "this is a classic example of a raw potato" I couldn't help but laugh 😂I LOVE the analogy, thank you so much, this is just what I needed this morning
I can't take the risk of not subscribing to your channel... Thanks for doing such a great job... Please do some data analysis projects on excel for real life experience... Thank you very much...
This was soooo helpful! But Chandoo in the interactive pivots when you kicked it out to its own worksheet and updated the design...I wish you went in further.
Thank you. I do have other videos on the channel that take this concept further. For example, see this video to build a dashboard from pivots - th-cam.com/video/35VnP0Rz71I/w-d-xo.html
Wonderful presentation: easy to understand, informative, entertaining, and effective. Exactly what I was looking for. Thank you! Also, data (raw potatoes) -> information (fries) ->knowledge (hunger satisfied)?
Hi, Feeling blessed after following your tutorials. I searched so much but now feel that going in the right direction. I have been teaching mathematics and statistics till 12 graders. But now in the last year, I am so fascinated with converting data to visuals so want to become a data analyst. Thinking, Certainly you are the right Mentor for me. I will be very grateful to you if you can show me the right path to becoming a data analyst by clearing my doubts, Which is more worthy certification or a degree? Please Please answer.....
Wowwwwwwww aft this 10 min i had a smile in my face ,due to value addition , thanks a lot
Same with me!! 😛
Same here :D
Thanks a lot, basically under rows we have to write (group by features, we can move some features to columns if required) , where condition in filters, which features to aggregate and what to aggregate in the Values box-- for those coming from sql background this will be useful.
He's really good!
Damn..now this is what you call magic.
Thanks for adding value to my arsenal.
College never taught us important things like this. I'm so glad there are people like you who willingly teaches important things for an adult for free. Bless your channel. ❤️
Dear Chandoo, I have watched many other instructional Excel videos, but your videos make learning Excel easy and fun. You are a gifted person and a delightful teacher. I am grateful for your knowledge, kindness and humor. Thank you! 💯💫🍟
Even after you know something about an Excel feature, when Chandoo teaches it, you get to learn something more and often unknown that adds value. Keep up the great work Chandoo! 😊👍
Thank you Vijay...
Ur right
Man this was awesome learning curve for me. I was very new to pivot tables , now I feel like I have been doing this for years! Loving it!
So happy to see this. I am glad you are now confident of using Pivot Tables.
Apart from the quality of the content, your style and humor factor makes it worthwhile to watch😊
Thanks Priti... :)
I love the logical thought flow and no-nonsense style. Thank you for sharing!
Very well explained. Haven't found a better explanation video since long. My interest in Excel has resurfaced because of this one. Thanks a lot.
Liked before starting as I know this will be awesome.
Usually, these online tutorials are soooo dry that I get bored and quit before they finish;, but with Chandoos online tutorials, it's like you've turned around to ask a close colleague for help. That said, the only improvement, at least from my chair, is that often I couldn't see past your head as it was blocking the bottom of the PivotTable Fields, but aside from that...excellent!
this is just like concepts freshen up video for those who r following the entire playlist because all the parts we studied are used in one way or the other
You explained way much better than the other videos in TH-cam, thank you 👍
One of the best Guru in the excel world.👏👏👏👏
Thank you for these simple steps, Chandoo!
Genius, lot of respect for you my dearest sir Chandoo.
Mann....😥 No words to say ...nailed it... Thanks a lot.🙏🙏🙏🙏
Most welcome 😊
Your video is exactly what I was looking for, no fuss, no muss, just a perfect 10 min tutorial about pivot table basics. THANK YOU kind sir :)
You're welcome!
You are amazing Chandoo!
I am new to excel, this video helped me out a lot. Thank you sir 😇😇
All the best
I hope I would have got to know about this earlier. I would not fail at interview saying I dont advanced excel.. Thank you so much. Now I can strongly recommend anyone this channel and hope you reach millions of subscribers soon. Now I am confident enough to face the next interview in Investment Banking...
You have no idea how much this helps.. Thanks bro!
Happy to help!
Thanks Chandu bhai. As a fresher it was very useful to me!
Always welcome
Only knowledge is what you get here!!🤘
😀😍
Learned A lot . Thanks Chandoo
You are welcome Nikhil 😀
Hi Chandoo. Awesome Pivot Table starter video! Thanks for sharing :)) Thumbs up!!
Thanks a lot, basically under rows we have to write (group by features, we can move some features to columns if required) , where condition in filters, which features to aggregate and what to aggregate in the Values box-- for those coming from sql background this will be useful.
MasyaAllah keren banget....and terima kasih banget ya.. absolutely brilliant tutorial... ❤
This was brilliant Chandoo. I learnt how to employ PivotTables for varied datasets with this one video. Thank you.
Dear your knowldege of excel is marvlous. I learned a lot from tutorials/lectures. all the best
Chandu You have got such a sweet voice.. I must say it's devine and addictive.
How you teach brother it's just amazing
Thanks Akshay. :)
Thanks Chandoo. Very Useful indeed thank you!
love your style, especially the finger clicking (a hidden excel feature) - have subscribed
The best one really... Thank you and welcome :)
this is a really clear tutorial on pivot tables. Thanks!
Glad it was helpful!
Thank you, Chandoo.
You always add value to my knowledge Bank. Really glad that i found your page.
Waaw so helpful thank you so much sir!!!!!
Dear Chandoo, Awesome , thank you for very much , nice explanation. Liked the potato analogy 👏👏
my beloved “Guru”
Sir you are best teacher when it comes to excel, power bi and data visualization. Sir just a request kindly share the secret to your calmness sir
Thank god I found your channel admist of my struggle with data love to you
Such a clarity on everything..I just lovved it
You are the best. I am learning a lot from you anytime I watch your videos
Very helpful video on Pivot tables. Thank u
I just love to come to your channel to learn whenever I have a doubt in excel. Even if I know the concept well, if I come to your channel, I am sure that I will always get to know something more. Please keep sharing such interactive videos and I still don't know how to select custom data for a chart or a graph to represent on x and y axis. I would love to see you upload a video on this topic. Thank you
Another awesome video, Chandoo. Though I was familiar with many of these things, some ideas were new to me. Thanks. Well presented, too!
Thank you senpai....
Your presentation is something else......
🥔 for the win...
Thanks a LOT ! lotlotlot ! it's clear, it's didactic, perfect for what I'm planning.
watching from the Philippines
Thanks chandooo Brother for teaching us ❤️
Thanks for the quick yet comprehensive tutorial sir!
Also, love that background music that you've added, one of my personal favourites!
Thanks Utkarsh for enjoying the video :)
I am the new learner and I see this video is only the best with which I can learn ..
Thanks for these types of video and I would request u to make a video on business analyst if u r new comer then how u can become business analyst with another working experience
Glad it was helpful! I will add such a video. Meanwhile watch my recent video on data analyst skills here - th-cam.com/video/gVr9f1GJdZc/w-d-xo.html
I found my real hero in the field of on line teaching , that its you. 👆
Wonder full example given to explain the use of raw data by using a similes with the taste of raw potato. This is what dear chandoo can do only.
Thank you Jagadish...
Nice collection of Lego on the stairs :)
Love you bro ❤️ finally a proper channel to improve myself!
Thank you very much Sir... Love and Respect from Nepal.
You are welcome Anish :)
Very very very helpful, thank you so much. You earned my like and subscription.
Amazing, easy understanding, thanks for sharing 😊
Glad it was helpful!
Chandoo!!!
this the nice presentation on Pivot Table and Slicer, also I liked the conciseness of the tutorial. Please continue the same in next video so that we can get maximum in minimum.
Thanks Nirmal. I am learning how to make better, concise and powerful videos. I am glad this one hit the nail on head. I will observe the video performance and make changes to my storytelling as needed.
I freaking LOVE your videos. Teaching me something important while making me laugh a bit. Thanks, sir!
Your way of presentation is awesome man❤️
Thank you so much 😀
Thank you, very helpful
Awesome video, It helped me to understand pivot table concept, Thanks a Ton
Thank you Vijay... Be sure to practice too.
This was amazing, good job!
Glad you liked it!
When he said "this is a classic example of a raw potato" I couldn't help but laugh 😂I LOVE the analogy, thank you so much, this is just what I needed this morning
Awesome Anna
Thank you for this awesome video 🙌
You're so welcome!
Awesome presentation 👏 👌 👍 🙌.
Awesome Chandoo...@DFTBA!
I love your content so much!❤️
Excellent way of teaching ....
Thanks and welcome
Bro you are the best
You have created a great channel!Thank you for all your efforts!!!!
You are welcome Ertugrul.
Thank you for making understanding the pivot table/chart concept so easy with an analogy.
Sir your the GOD OF data🥰🥰🥰
I enjoy watching how you teach! Thanks Chandoooooooooo :)
My pleasure!
Woow! I am very happy with this video!
Thank you! 😃
Thank you so much, this information has helped me. I was completely lost before.
Thanks Nicholas. I call this the Potato Pathfinder 🥔🥔🥔
Thank you soooo much for making it so easy to learn and understand ✨
I can't take the risk of not subscribing to your channel... Thanks for doing such a great job... Please do some data analysis projects on excel for real life experience... Thank you very much...
Very nicely explained.
Lego Technic, nice! Excellent pacing too, well done! I learned a lot more than I expected.
EVERYTHING IS AWESOME!!!
Wow such a amazing video thank you so much I learnt so many thinks 10mins
You are welcome Madan.. :)
Thanks Dada for sharing the valuable tricks on Pivot Table
omg this blew my mind !!!
Super👍 Thank god i found ur channel
thank for this video sir!!
Most welcome!
Thank chandoo, your share video i put for my main excel learning reference. Hope you always doing well..
Just love your teaching style. Awesome work brother 👍
Thank you .... Your teaching methods are so good ... It really fun learning
Thanks for this and grateful
Love the potato fries analogy
This was soooo helpful! But Chandoo in the interactive pivots when you kicked it out to its own worksheet and updated the design...I wish you went in further.
Thank you. I do have other videos on the channel that take this concept further. For example, see this video to build a dashboard from pivots - th-cam.com/video/35VnP0Rz71I/w-d-xo.html
Just brilliant!
Wonderful presentation: easy to understand, informative, entertaining, and effective. Exactly what I was looking for. Thank you!
Also, data (raw potatoes) -> information (fries) ->knowledge (hunger satisfied)?
Excellent sir, thank you
Hi, Feeling blessed after following your tutorials. I searched so much but now feel that going in the right direction. I have been teaching mathematics and statistics till 12 graders. But now in the last year, I am so fascinated with converting data to visuals so want to become a data analyst. Thinking, Certainly you are the right Mentor for me. I will be very grateful to you if you can show me the right path to becoming a data analyst by clearing my doubts,
Which is more worthy certification or a degree?
Please Please answer.....
It’s all most useful skill you are sharing to us! Thank you!
My pleasure!
so much value, might take couple of minutes more to adjust and learn the basics taught..
Thank you Samrat.
Chandoo you are amazing and inspiration for me❤️❤️