Really appreciate this video, using common analysis questions and then walking through how you would get the answers. This is teaching method is one of the best ways to learn - thank you!
The claim that knowing these 15 function in excel is enough to get most your analysis work done is true. In fact, It wouldn't be incorrect to say that this one video was enough for me to understand the entire logic on which Excel works. After watching it, I did not have to look any further. Thanks Chandoo bhaiyya for this. You may not be aware of the miracle you created here!
This is one of the best Excel Video have ever seen, so much of details and explanation about each and every formula with example so that its easily understandable. Thanks Very much and hope to have more video in future.
I learn so quickly after watching your videos, especially this one. Your real work examples and explanations make all the difference. Love this video. Look forward to seeing more. Thanks
Thank you so much!!! 🥰 You’re the best. 🌟🌟🌟 I’ve been working on this spreadsheet all night then I found your video and now I was able to use these formulas to make everything work. You’re a blessing 🙏🏾
Thank you sir for sharing this video. It indeed helped me to learn the most important Advanced excel formulas for data analysis !! I am a follower of your You-tube channel & appreciate the lessons you provide.
I love doing homeworks after seeing Chandoo's video. Please give us more homeworks in coming days. BTW I'm your new Subscriber. Thank you for making my Excel journey, a interesting one👍Big fan of your work🤝
Even if you're very familiar with all the functions presented here, there's always the chance of getting a alternative way of doing things that you weren't familiar with. Good content.
This is a great & very informative video, your teaching style is simply amazing. Thank You Sir for keeping us up to date in excel & making our job is simple.
Thank you so much Chandoo for this video . You always try to cover small small things, which help us to understand each and every points. Last but not least your video graphics are too good.💖💖💖
Dear Chandoo, I'm a beginner in data analytics I have watched most of your videos, with pivot table I crossed checked my answer and all were correct, let me know why we should go with formulas. Will formulas help at visualisation?
Wow. That is great exercise Harhoon. I plan to cover Pivot vs. Formulas in an upcoming video, but here are my thoughts. 1) For data analysts, it is important to know both approaches. 2) Depending on the need of the hour, they must choose one of the approaches. 3) When in doubt, start with a pivot.
Hi Chandoo. Great lookup problem and function workout! Very useful to work real examples to learn and reinforce methods and concepts. Many thanks for the sample file and demo / challenge! Thumbs up!!
Patter of this video I liked because we know the formula but using in real applications is sometimes become bit tricky. Please make such video based on this approach.
I talk about the Power BI context and more in my "Data Analysis with Power BI" video. th-cam.com/video/uwe8C7K8fXY/w-d-xo.html I also run a course on Power BI here. If you want structured info, go for the class - chandoo.org/wp/resources/power-bi-play-date/
Hi @Chandoo for Q 14 & 15, I think UNIQUE formula would have been another useful formula that you could have covered. In fact UNIQUE would have helped fetching results a bit faster.
Hi Chandoo, Thanks for sharing such an informative video, Regarding Homework exercise please check if my understanding is correct: H1: =SUMIFS(data[Downloads],data[App],C125) H2:=SUMIFS(data[Downloads],data[App],C125)-SUMIFS(data[Uninstalls],data[App],C139)
"Awesome Chocolates", "Awesome Apps" and "Awesome Chandoo!" Really useful and practical tutorial on most important functions. I had knowledge, but found a lot of value addition and tips to follow and thanks for that! 😊👍
Thanks Chandoo for sharing the valuable excel lessons! I have a question in sumifs which is working well when I reference a cell for criteria but give an answer zero if I input the actual date. Would appreciate it if you clarify.
Thanks for this excellent video!!! Crystal clear explanation of some of the functions that I always find difficult to understand. Thanks Chandoo for all your efforts!!!
Thank you so much, i really appreciate you have been a great teacher. But i have a problem which is, i am using Excel 2013 and it doesn't have the MAXIFS function, which other function can i use?
This is fun! One question I have as I work through these, how would you do the filter questions (12 & 13) if you are in an earlier version and don't have Filter available?
Even i had same question and searching through comments incase anyone asked it out, funny how you did just couple of hours ago on couple of years old video... leaving my comment here just to get notification if incase anyone has any way around! :)
Just found out authors comments on similar question of another user - "Unfortunately, the older versions do not have a ready to use compatible function. You can replicate the behaviour using a complex set of formulas, but I suggest altogether avoiding such needs or using Pivot tables + slicers to build any interactive portions of your reports. While there is no replacement for FILTER() in older versions, You can use INDEX+MATCH to _kind of _ get the result. See this video - th-cam.com/video/kly0uPIM4IU/w-d-xo.html "
You can use ARRAY formulas to solve this in older versions. Try =MAX(IF(data[Month]=D89,data[1 star ratings])) and press CTRL SHIFT ENTER to get the correct answer. Read this for more info - chandoo.org/wp/formula-forensics-no-008/
Very useful video and I love your explanation! I have downloaded a free sample copy of the Excel sheet and have been following your steps through memory, but I keep getting zero as a result.
thank you for this, Chandoo. Amazing work, I mean it had a use case where I would filter data but then I don't want the first returned rows, how would you do that?
Thanks, Chandoo, for sharing this insightful content. I was wondering how can I find the solutions to the homework problems. I have tried them, but struggling with problem H3.
Question number 12. Instead of using a cell as a reference for month. how can we include the month in the filter function ? Also an added question instead of finding out the total download for apps starting with "c". what if we had to find by a criteria such as 2nd alphabet must be c or the 2nd last alphabet must be c. Please answer Very new to excel. would be helpful
Really appreciate this video, using common analysis questions and then walking through how you would get the answers. This is teaching method is one of the best ways to learn - thank you!
Thanks Irene 😀
How did he Reply to all these comment?!?!?!?!??!!?!
The claim that knowing these 15 function in excel is enough to get most your analysis work done is true. In fact, It wouldn't be incorrect to say that this one video was enough for me to understand the entire logic on which Excel works. After watching it, I did not have to look any further. Thanks Chandoo bhaiyya for this. You may not be aware of the miracle you created here!
I hope this comment was not paid
🙏
@@harismehmood12345why u think so
Yeah, Why do you think so?!?
I am so happy I found your channel. You're a great teacher. I no longer feel overwhelmed by the prospect of learning data analysis in Excel!
Welcome aboard!
THANKS A LOT Chandoo you don't know how much you're helping the newbies as well as the experienced.
Many blessings your way
You are welcome Sarika :) My mission is to help a million people every month. I am glad I have your blessings on my journey 🙏
Helped Me lot Sir...I was searchimg for Excel Excersices..I found It
You are GEM of a Person Sir
Thanks Shashank :)
This is one of the best Excel Video have ever seen, so much of details and explanation about each and every formula with example so that its easily understandable. Thanks Very much and hope to have more video in future.
You're very welcome!
I learn so quickly after watching your videos, especially this one. Your real work examples and explanations make all the difference. Love this video. Look forward to seeing more. Thanks
Very good examples and great explanation for each function. I highly appreciate your help and the downloads you provided!
You are the BEST, Chandoo! Thanks from Georgia, USA.
Many thanks Chandoo. You're a brilliant teacher!
The coolest teacher under the stars. Thank you sir!
Man.....!!!! this guy deserves 100M likes & 100M subscribes.
absolute peace of art....💖💖💖
love u brooo.
Great Teacher and Inspiration for Many People Sir👌👌👌
Thank you Chandoo for providing us such resources for our learning. Really appreciate your efforts
The way you explain these topics make it super easy to follow. Subscribed for more videos like these. Thanks bhai!
Thank you so much!!! 🥰 You’re the best. 🌟🌟🌟 I’ve been working on this spreadsheet all night then I found your video and now I was able to use these formulas to make everything work. You’re a blessing 🙏🏾
This channel is the best channel for learn excel, power bi, and all things ❤️
You are helping most of us to transform our career. Thanks for paving our future and helping to knowledge us.. thanks..
Thanks Prakash :)
Excellent exercise - a great way to reinforce the way these formulas work.
Glad you liked it!
Thank you for the very useful tutorials. I'm an advanced Excel user but I learned some new techniques here.
Much appreciated Chandoo!
You're very welcome Amr.. :)
Thank you sir for sharing this video. It indeed helped me to learn the most important Advanced excel formulas for data analysis !! I am a follower of your You-tube channel & appreciate the lessons you provide.
You are most welcome
I love doing homeworks after seeing Chandoo's video. Please give us more homeworks in coming days. BTW I'm your new Subscriber. Thank you for making my Excel journey, a interesting one👍Big fan of your work🤝
Thanks for subbing! You can check more homework problems here - chandoo.org/wp/tag/homework/
Excellent! Judicious selection of 15 most useful functions! Intelligent demonstration!
These kind videos in your youtube is awesome and i am becoming awesome In Excel 😂❤
You are welcome Casmi :)
Thankyou so much Chandoo Sir for all your efforts, You are a brilliant teacher. i learn so easily from your videos. Thanks again !!
Even if you're very familiar with all the functions presented here, there's always the chance of getting a alternative way of doing things that you weren't familiar with. Good content.
These videos are awesome, I love watching your excel post they helped me a lot. Thank you.
Great to hear!
Thank you so much! Your commitment and charisma are second to none.
Thanks chandu help to lot of people who are learners in Excel beginners
Chandoo is the best in the game. Thank you sir.
Thank you for this amazing video. You are a gifted teacher and I appreciate your efforts I have learnt many excel techniques from your videos
It is the best channel for learning data analysis!
Sumifs, countifs, xlookup, averageifs, maxifs, large,index match. Thank you very much.
Once again wonderfully thought out examples, and excellently presented. Thank you
Glad you enjoyed it Adam 😀
Really a top notch video, loved the concept and how beautifully you explained. Thank you so much !!
Thanks!
This is a great & very informative video, your teaching style is simply amazing. Thank You Sir for keeping us up to date in excel & making our job is simple.
You are most welcome Azhar. My mission is "To make YOU Awesome"
One of the best Microsoft exel you tuber
Wowww!!! Superb revision of these formulas and their application . Thanks Chandoo Sir !!
Just loved the video Chandoo. Would love it if you do more of these.
Such a great video , for the interview purpose ...
Thanks lot for such a wonderful content
Thank you so much Chandoo for this video .
You always try to cover small small things, which help us to understand each and every points.
Last but not least your video graphics are too good.💖💖💖
Thanks Shriram :)
Awesome content 👏 Keeping sharing your knowledge and help us grow 😇🤗
Always!
Thank you for such contents, it really helped me brush my concepts and real life application in business use cases.
Professional level training here, good luck with the channel!
Dear Chandoo, I'm a beginner in data analytics I have watched most of your videos, with pivot table I crossed checked my answer and all were correct, let me know why we should go with formulas. Will formulas help at visualisation?
Wow. That is great exercise Harhoon.
I plan to cover Pivot vs. Formulas in an upcoming video, but here are my thoughts.
1) For data analysts, it is important to know both approaches.
2) Depending on the need of the hour, they must choose one of the approaches.
3) When in doubt, start with a pivot.
Hiii bro i am also pursuing data analytics please guide me i am beginner
That is the beauty and power of Excel! There is more than one way to approach the question and get the results.
Hi Chandoo. Great lookup problem and function workout! Very useful to work real examples to learn and reinforce methods and concepts. Many thanks for the sample file and demo / challenge! Thumbs up!!
Glad you enjoyed it Wayne... 😎
Thanks Chandoo for this tutorial.. It is a great learning for me....
Bro You Just Made a New Analyst Love You ❤
great video, thanks @Chandoo for posting it showing some of the most useful functions that are available only in Excel 365 !
Thank you so much Chandoo Sir, for arranging such type of learning video.
Chandoo, you make me a happy learner
I enjoyed following this exercise. Thank you man!
U are legend chandoo ❤️
Respect from Egypt
Thanks 🙏
Great stuff Chandoo, good to see you on TH-cam :)
Excellent Presentation and Examples! Thanks. 😃😃😃
Thank you @Chandoo 🙏🏻
God bless you
Patter of this video I liked because we know the formula but using in real applications is sometimes become bit tricky. Please make such video based on this approach.
Thanks Nirmal :) I will share more on this format in coming months.
This was great, thanks Chandoo!
You are welcome Chris 😀
It was a very good exercise, thank you, Chandoo🙏
Valuable Tips ... Thanks a lot Chandoo ...
What a transformation, excellent work Sir G 🙂Hats Off..
I really appreciate this video, it was very helpful. It requires in daily life. Thanks a lot.
Another great video... 👌👌👌👍👍thank you ..request to make a content on power bi filter context vs row context with similar kind of easy example please
I talk about the Power BI context and more in my "Data Analysis with Power BI" video. th-cam.com/video/uwe8C7K8fXY/w-d-xo.html
I also run a course on Power BI here. If you want structured info, go for the class - chandoo.org/wp/resources/power-bi-play-date/
@@chandoo_ thanks for the reply.. I will go through the links👍
Wow🤗.. Only boundaries and Sixer's 🏏in this video... Full pack of excel knowledge. 🕺🕺👏
Glad you liked it
Truly a great course and teacher!
Really appreciate this video
Excellent Chandoo sir...Very helpful
Hi @Chandoo for Q 14 & 15, I think UNIQUE formula would have been another useful formula that you could have covered. In fact UNIQUE would have helped fetching results a bit faster.
Good points Sanjay. I talk about UNIQUE in few other videos. So decided to skip that bit here. 😀
your free videos are far better than paid videos
Hi Chandoo,
Thanks for sharing such an informative video, Regarding Homework exercise please check if my understanding is correct:
H1: =SUMIFS(data[Downloads],data[App],C125)
H2:=SUMIFS(data[Downloads],data[App],C125)-SUMIFS(data[Uninstalls],data[App],C139)
one of d best video on excel
"Awesome Chocolates", "Awesome Apps" and "Awesome Chandoo!" Really useful and practical tutorial on most important functions. I had knowledge, but found a lot of value addition and tips to follow and thanks for that! 😊👍
AWESOME to hear that Vijay 😀 That was my intention too. Lure people with "15 formulas" and surprise them with so many extra tricks.
Thanks Chandoo for sharing the valuable excel lessons! I have a question in sumifs which is working well when I reference a cell for criteria but give an answer zero if I input the actual date. Would appreciate it if you clarify.
You are amazing, with no excessive bullshit just to the point and useful tricks that are easily understandable.
Superb video, as always
Btw, after hearing what you said about SUMIF and SUMIFS, why does the SUMIF function even exist, I wonder?
Chandoo never disappoints 😊. Thx bro
Great video Chandoo. Love your videos.
Thanks for this excellent video!!! Crystal clear explanation of some of the functions that I always find difficult to understand.
Thanks Chandoo for all your efforts!!!
Thank you @Chandoo🙏🏻
Loved this Chandoo! ❤️😊
Thanks Adwitya...
Thank you so much, i really appreciate you have been a great teacher.
But i have a problem which is, i am using Excel 2013 and it doesn't have the MAXIFS function, which other function can i use?
Great video as usual 🤝🙏
Thank you 🙌
Really amazing informative video Chandu
learned a lot; thank you very much
This is fun! One question I have as I work through these, how would you do the filter questions (12 & 13) if you are in an earlier version and don't have Filter available?
Even i had same question and searching through comments incase anyone asked it out, funny how you did just couple of hours ago on couple of years old video...
leaving my comment here just to get notification if incase anyone has any way around! :)
Just found out authors comments on similar question of another user - "Unfortunately, the older versions do not have a ready to use compatible function. You can replicate the behaviour using a complex set of formulas, but I suggest altogether avoiding such needs or using Pivot tables + slicers to build any interactive portions of your reports.
While there is no replacement for FILTER() in older versions, You can use INDEX+MATCH to _kind of _ get the result. See this video - th-cam.com/video/kly0uPIM4IU/w-d-xo.html "
You can use ARRAY formulas to solve this in older versions.
Try =MAX(IF(data[Month]=D89,data[1 star ratings]))
and press CTRL SHIFT ENTER to get the correct answer.
Read this for more info - chandoo.org/wp/formula-forensics-no-008/
Thank you so much for sharing your great Knowledge
Thank you for the videos! What key combo do you use to select "data[Downloads]" without dragging and dropping?
Very useful video and I love your explanation! I have downloaded a free sample copy of the Excel sheet and have been following your steps through memory, but I keep getting zero as a result.
thank you for this, Chandoo. Amazing work, I mean it
had a use case where I would filter data but then I don't want the first returned rows, how would you do that?
Excellent work sirji, God bless you
So nice of you
Chandoo you are Awesome!!
Excellent 👌👌👌👌👌
Thanks, Chandoo, for sharing this insightful content. I was wondering how can I find the solutions to the homework problems. I have tried them, but struggling with problem H3.
Question number 12. Instead of using a cell as a reference for month. how can we include the month in the filter function ? Also an added question instead of finding out the total download for apps starting with "c". what if we had to find by a criteria such as 2nd alphabet must be c or the 2nd last alphabet must be c. Please answer Very new to excel. would be helpful
Really helpful videos and great explanation.. Thank you🙏
Love you Dada keep going ❤️❤️
Please can you explain why we use ampersand& while selecting date
God bless Baaya 😍
Please chandoo,l will love to download the data for practise. Is the data available?