These are the ONLY 15 functions you need to know in Excel (to get most things done)

  Рет қаралды 303,039

Chandoo

Chandoo

Күн бұрын

Пікірлер
@utubeAgape
@utubeAgape 2 жыл бұрын
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!
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Irene 😀
@selvaramraj
@selvaramraj Ай бұрын
How did he Reply to all these comment?!?!?!?!??!!?!
@shujashakir9952
@shujashakir9952 2 жыл бұрын
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!
@harismehmood12345
@harismehmood12345 Жыл бұрын
I hope this comment was not paid
@Vikas.Verma06
@Vikas.Verma06 Жыл бұрын
🙏
@nitanjyotiradityamishranit6415
@nitanjyotiradityamishranit6415 Жыл бұрын
​@@harismehmood12345why u think so
@selvaramraj
@selvaramraj Ай бұрын
Yeah, Why do you think so?!?
@hstppt
@hstppt 2 жыл бұрын
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!
@chandoo_
@chandoo_ 2 жыл бұрын
Welcome aboard!
@sarikadatta3706
@sarikadatta3706 2 жыл бұрын
THANKS A LOT Chandoo you don't know how much you're helping the newbies as well as the experienced. Many blessings your way
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome Sarika :) My mission is to help a million people every month. I am glad I have your blessings on my journey 🙏
@shashankks2454
@shashankks2454 2 жыл бұрын
Helped Me lot Sir...I was searchimg for Excel Excersices..I found It You are GEM of a Person Sir
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Shashank :)
@michelemontano8923
@michelemontano8923 Жыл бұрын
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
@RajeshAcharya-em7qk
@RajeshAcharya-em7qk 5 ай бұрын
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.
@chandoo_
@chandoo_ 5 ай бұрын
You're very welcome!
@snowwhite2146
@snowwhite2146 2 жыл бұрын
Many thanks Chandoo. You're a brilliant teacher!
@kennethgray5447
@kennethgray5447 Жыл бұрын
You are the BEST, Chandoo! Thanks from Georgia, USA.
@largeroomnolight
@largeroomnolight 2 жыл бұрын
Thanks!
@reneearch448
@reneearch448 24 күн бұрын
Very good examples and great explanation for each function. I highly appreciate your help and the downloads you provided!
@HagaagAccounting
@HagaagAccounting 2 жыл бұрын
These kind videos in your youtube is awesome and i am becoming awesome In Excel 😂❤
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome Casmi :)
@chunksssstv
@chunksssstv 2 жыл бұрын
Thank you Chandoo for providing us such resources for our learning. Really appreciate your efforts
@BRUNOABG
@BRUNOABG Жыл бұрын
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.
@largeroomnolight
@largeroomnolight 2 жыл бұрын
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 🙏🏾
@nipunshetty9640
@nipunshetty9640 2 жыл бұрын
Great Teacher and Inspiration for Many People Sir👌👌👌
@jimberglund6838
@jimberglund6838 2 жыл бұрын
Excellent exercise - a great way to reinforce the way these formulas work.
@chandoo_
@chandoo_ 2 жыл бұрын
Glad you liked it!
@edidiongbassey919
@edidiongbassey919 Ай бұрын
Chandoo is the best in the game. Thank you sir.
@legacygk2811
@legacygk2811 2 жыл бұрын
Thank you so much! Your commitment and charisma are second to none.
@H99x2
@H99x2 2 жыл бұрын
The way you explain these topics make it super easy to follow. Subscribed for more videos like these. Thanks bhai!
@Amr-Ibrahim-AI
@Amr-Ibrahim-AI 2 жыл бұрын
Thank you for the very useful tutorials. I'm an advanced Excel user but I learned some new techniques here. Much appreciated Chandoo!
@chandoo_
@chandoo_ 2 жыл бұрын
You're very welcome Amr.. :)
@yashmittal4744
@yashmittal4744 2 жыл бұрын
Just loved the video Chandoo. Would love it if you do more of these.
@espoirk.kouevi6212
@espoirk.kouevi6212 Жыл бұрын
Sumifs, countifs, xlookup, averageifs, maxifs, large,index match. Thank you very much.
@ltatavarty
@ltatavarty 6 ай бұрын
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.
@roadsailor79
@roadsailor79 7 ай бұрын
The coolest teacher under the stars. Thank you sir!
@PrakashNagaraj1993
@PrakashNagaraj1993 2 жыл бұрын
You are helping most of us to transform our career. Thanks for paving our future and helping to knowledge us.. thanks..
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Prakash :)
@kavitanagpal8863
@kavitanagpal8863 2 жыл бұрын
These videos are awesome, I love watching your excel post they helped me a lot. Thank you.
@chandoo_
@chandoo_ 2 жыл бұрын
Great to hear!
@sujitsengupta8398
@sujitsengupta8398 6 ай бұрын
Excellent! Judicious selection of 15 most useful functions! Intelligent demonstration!
@richardplester
@richardplester 2 жыл бұрын
Professional level training here, good luck with the channel!
@p_anjali_codes
@p_anjali_codes 2 жыл бұрын
Thank you for such contents, it really helped me brush my concepts and real life application in business use cases.
@kavalimahesh4230
@kavalimahesh4230 5 ай бұрын
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
@richagupta7642
@richagupta7642 Ай бұрын
Thankyou so much Chandoo Sir for all your efforts, You are a brilliant teacher. i learn so easily from your videos. Thanks again !!
@Malli-y7h
@Malli-y7h 3 ай бұрын
Thanks chandu help to lot of people who are learners in Excel beginners
@theh1ve
@theh1ve 2 жыл бұрын
Once again wonderfully thought out examples, and excellently presented. Thank you
@chandoo_
@chandoo_ 2 жыл бұрын
Glad you enjoyed it Adam 😀
@songexplain
@songexplain 2 жыл бұрын
This channel is the best channel for learn excel, power bi, and all things ❤️
@chandrimachoudhury1057
@chandrimachoudhury1057 Жыл бұрын
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.
@chandoo_
@chandoo_ Жыл бұрын
You are most welcome
@arun.kumar.s
@arun.kumar.s 2 жыл бұрын
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?
@chandoo_
@chandoo_ 2 жыл бұрын
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.
@Vampire442-y7s
@Vampire442-y7s 2 жыл бұрын
Hiii bro i am also pursuing data analytics please guide me i am beginner
@afonsoosorio2099
@afonsoosorio2099 Жыл бұрын
That is the beauty and power of Excel! There is more than one way to approach the question and get the results.
@nweisi
@nweisi Жыл бұрын
One of the best Microsoft exel you tuber
@sportshungers
@sportshungers Жыл бұрын
It is the best channel for learning data analysis!
@wayneedmondson1065
@wayneedmondson1065 2 жыл бұрын
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!!
@chandoo_
@chandoo_ 2 жыл бұрын
Glad you enjoyed it Wayne... 😎
@rajivramki
@rajivramki 2 жыл бұрын
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🤝
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks for subbing! You can check more homework problems here - chandoo.org/wp/tag/homework/
@Azhar_Khan383
@Azhar_Khan383 2 жыл бұрын
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.
@chandoo_
@chandoo_ 2 жыл бұрын
You are most welcome Azhar. My mission is "To make YOU Awesome"
@rafiabdullah2890
@rafiabdullah2890 2 жыл бұрын
Man.....!!!! this guy deserves 100M likes & 100M subscribes. absolute peace of art....💖💖💖 love u brooo.
@nenavathnagaraj5580
@nenavathnagaraj5580 2 жыл бұрын
Awesome content 👏 Keeping sharing your knowledge and help us grow 😇🤗
@chandoo_
@chandoo_ 2 жыл бұрын
Always!
@jeffreymethusala30
@jeffreymethusala30 Жыл бұрын
Chandoo, you make me a happy learner
@arushiarora8867
@arushiarora8867 Ай бұрын
Really a top notch video, loved the concept and how beautifully you explained. Thank you so much !!
@harshshah9006
@harshshah9006 Жыл бұрын
Wowww!!! Superb revision of these formulas and their application . Thanks Chandoo Sir !!
@vijayarjunwadkar
@vijayarjunwadkar 2 жыл бұрын
"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! 😊👍
@chandoo_
@chandoo_ 2 жыл бұрын
AWESOME to hear that Vijay 😀 That was my intention too. Lure people with "15 formulas" and surprise them with so many extra tricks.
@MonAlde
@MonAlde 9 ай бұрын
I enjoyed following this exercise. Thank you man!
@ahmed007Jaber
@ahmed007Jaber 10 ай бұрын
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?
@osmonddsilva1577
@osmonddsilva1577 Жыл бұрын
Excellent Presentation and Examples! Thanks. 😃😃😃
@shriram8088
@shriram8088 2 жыл бұрын
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.💖💖💖
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Shriram :)
@21drip
@21drip 6 ай бұрын
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?
@allaboutpriya1996
@allaboutpriya1996 4 ай бұрын
Thank you @Chandoo 🙏🏻 God bless you
@ajwanta9253
@ajwanta9253 Жыл бұрын
Thank you for the videos! What key combo do you use to select "data[Downloads]" without dragging and dropping?
@kashifbacha4679
@kashifbacha4679 Жыл бұрын
Thank you so much Chandoo Sir, for arranging such type of learning video.
@chrism9037
@chrism9037 2 жыл бұрын
This was great, thanks Chandoo!
@chandoo_
@chandoo_ 2 жыл бұрын
You are welcome Chris 😀
@kareemahmed5839
@kareemahmed5839 Жыл бұрын
U are legend chandoo ❤️ Respect from Egypt Thanks 🙏
@peternolder8145
@peternolder8145 2 жыл бұрын
Great stuff Chandoo, good to see you on KZbin :)
@roberttaylor3594
@roberttaylor3594 2 жыл бұрын
15:45 with the lookup... can you embed the 'highest value' formula into the Lookup function? and using dropdown lists in the previous questions to enter the chocolate you want the data on?
@chandoo_
@chandoo_ 2 жыл бұрын
You certainly can. Give it a try.
@ahmadhasnain6381
@ahmadhasnain6381 Жыл бұрын
You are amazing, with no excessive bullshit just to the point and useful tricks that are easily understandable.
@nidhumanoj1552
@nidhumanoj1552 Жыл бұрын
Thanks Chandoo for this tutorial.. It is a great learning for me....
@hairavyadav6579
@hairavyadav6579 19 күн бұрын
Such a great video , for the interview purpose ... Thanks lot for such a wonderful content
@nemoyatpeace
@nemoyatpeace Жыл бұрын
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?
@kasshyap_p
@kasshyap_p Жыл бұрын
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! :)
@kasshyap_p
@kasshyap_p Жыл бұрын
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 - kzbin.info/www/bejne/oZ3cYaiGfrJnf7c "
@chandoo_
@chandoo_ Жыл бұрын
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/
@mukhtarabdi824
@mukhtarabdi824 Жыл бұрын
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.
@canirmalchoudhary8173
@canirmalchoudhary8173 2 жыл бұрын
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.
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Nirmal :) I will share more on this format in coming months.
@surajbhardwaj428
@surajbhardwaj428 2 жыл бұрын
Wow🤗.. Only boundaries and Sixer's 🏏in this video... Full pack of excel knowledge. 🕺🕺👏
@chandoo_
@chandoo_ 2 жыл бұрын
Glad you liked it
@SanjayGulatiMusafir
@SanjayGulatiMusafir 2 жыл бұрын
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.
@chandoo_
@chandoo_ 2 жыл бұрын
Good points Sanjay. I talk about UNIQUE in few other videos. So decided to skip that bit here. 😀
@gustavoruiz6625
@gustavoruiz6625 6 ай бұрын
Thanks for the video, do you nave examples to use the formula « sumproduct"?
@leoxaj412
@leoxaj412 4 ай бұрын
Bro You Just Made a New Analyst Love You ❤
@classicurdutales9055
@classicurdutales9055 Жыл бұрын
I use excel 2019 and in that I cant find the xlookup and index match formulas. Kindly suggest which formulas I can use to get the same result. Thank you.
@mohitpareek3305
@mohitpareek3305 Жыл бұрын
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)
@jeanlambert3875
@jeanlambert3875 2 жыл бұрын
great video, thanks @Chandoo for posting it showing some of the most useful functions that are available only in Excel 365 !
@behzadghah
@behzadghah Жыл бұрын
It was a very good exercise, thank you, Chandoo🙏
@ashutoshbafna6617
@ashutoshbafna6617 2 жыл бұрын
I really appreciate this video, it was very helpful. It requires in daily life. Thanks a lot.
@wgalloPT
@wgalloPT 11 ай бұрын
Is there a video on how you do to make that table and refer those cells to where is the "download the answers workbook"? In following your video i was clueless on (if I was to do this in real life) how to do that...
@diduguchu8500
@diduguchu8500 Жыл бұрын
Please can you explain why we use ampersand& while selecting date
@ramakumarguntamadugu1299
@ramakumarguntamadugu1299 2 жыл бұрын
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
@chandoo_
@chandoo_ 2 жыл бұрын
I talk about the Power BI context and more in my "Data Analysis with Power BI" video. kzbin.info/www/bejne/q6jIaXZtgJ2Zjrs 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/
@ramakumarguntamadugu1299
@ramakumarguntamadugu1299 2 жыл бұрын
@@chandoo_ thanks for the reply.. I will go through the links👍
@alperkins66
@alperkins66 Жыл бұрын
Truly a great course and teacher!
@rahulagarwal7182
@rahulagarwal7182 2 ай бұрын
Really appreciate this video
@sukhomoyb
@sukhomoyb 2 жыл бұрын
Valuable Tips ... Thanks a lot Chandoo ...
@parusharamudugunaganti2658
@parusharamudugunaganti2658 2 жыл бұрын
Excellent Chandoo sir...Very helpful
@fitnessconnection4726
@fitnessconnection4726 7 ай бұрын
your free videos are far better than paid videos
@AdwityaMehra
@AdwityaMehra 2 жыл бұрын
Loved this Chandoo! ❤️😊
@chandoo_
@chandoo_ 2 жыл бұрын
Thanks Adwitya...
@anandl2003
@anandl2003 Жыл бұрын
Thank you Chandoo, As always You are awesome👍 I wish to join your PQ course. Is it ok? please send link
@m.e.chishti786
@m.e.chishti786 2 жыл бұрын
What a transformation, excellent work Sir G 🙂Hats Off..
@flickhunter8900
@flickhunter8900 10 ай бұрын
Chandoo never disappoints 😊. Thx bro
@daviddiazsanchez7292
@daviddiazsanchez7292 Жыл бұрын
Chandoo you are Awesome!!
@poojahakke5462
@poojahakke5462 Жыл бұрын
Thankyou so much for this amazing video and for the sample file ❤For the 12th and 13th questions, what is the alternative to filter function? (if it is not working on the current excel version)
@adejuyigbeadetutu2156
@adejuyigbeadetutu2156 2 жыл бұрын
Thank you so much Chandoo!! I tried the alternative formula on excel 2021 for number 8. It still didn't work. Please advise. Thanks
@saurabhbanerjee6368
@saurabhbanerjee6368 2 жыл бұрын
Hi Chandoo, thank you so much for another amazing video, could you please suggest any alternative to filter function for people with older versions
@chandoo_
@chandoo_ 2 жыл бұрын
Hi Saurabh... While there is no replacement for FILTER() in older versions, You can use INDEX+MATCH to _kind of _ get the result. See this video - kzbin.info/www/bejne/oZ3cYaiGfrJnf7c
@saurabhbanerjee6368
@saurabhbanerjee6368 2 жыл бұрын
@@chandoo_ thankyou so much for the reply and just wanted to tell you that your videos help a lot, if possible please make a roadmap for beginners with resources to analytics
@erikkappelle4519
@erikkappelle4519 2 жыл бұрын
Hi @Chandoo, you are indeed awesome... I watched several video's from different producers, but somehow I like your video's best, You have a great way of expaining things!! My question: what alternative is there to filter function for non 365 users? (I have excel 2019 pro etc..) In Q 13 there are 2 solutions and filter-function shows them both. Since I do not have this function I First filtered the table for october (created a new table) and then did an XLOOKUP. But this only shows the first option. Is there an alternative method that shows all applicable solutions???... I mean this is an issue that occurs regularly in real life so there are solutions, not???
@chandoo_
@chandoo_ 2 жыл бұрын
Hi Erik... Thanks for your comment and appreciation of my work. 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. If you want to use formulas, please read this - chandoo.org/wp/formula-forensics-no-037-how-to-count-and-sum-filtered-tables/
@basavarajpg18
@basavarajpg18 6 ай бұрын
one of d best video on excel
@natarajang6125
@natarajang6125 2 жыл бұрын
Great video as usual 🤝🙏
@chandoo_
@chandoo_ 2 жыл бұрын
Thank you 🙌
@detectivethinker3637
@detectivethinker3637 Жыл бұрын
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.
@edidiongbassey919
@edidiongbassey919 Ай бұрын
Please chandoo,l will love to download the data for practise. Is the data available?
@allaboutpriya1996
@allaboutpriya1996 4 ай бұрын
Thank you @Chandoo🙏🏻
@saaneroa5024
@saaneroa5024 9 ай бұрын
Great video Chandoo. Love your videos.
@Vian19821
@Vian19821 7 ай бұрын
Hi Chandoo, i am not able to select the data columns after selecting the table for sum range, please help to resolve this.
@lj6203
@lj6203 Жыл бұрын
Excellent 👌👌👌👌👌
XLOOKUP but wrong results?!?
5:58
Chandoo
Рет қаралды 26 М.
10 Advanced IF formulas every analyst should know
21:55
Chandoo
Рет қаралды 206 М.
Правильный подход к детям
00:18
Beatrise
Рет қаралды 11 МЛН
Chain Game Strong ⛓️
00:21
Anwar Jibawi
Рет қаралды 41 МЛН
Каха и дочка
00:28
К-Media
Рет қаралды 3,4 МЛН
Data cleaning in Excel - 10 tricks *PROs* use all the time
17:02
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 8 МЛН
Learn 80% of DAX in an Hour (with FREE sample file)
1:02:21
Chandoo
Рет қаралды 77 М.
Top 10 Essential Excel Formulas for Analysts in 2024
13:39
Kenji Explains
Рет қаралды 937 М.
Power Query - Beginner to PRO Masterclass in 30 minutes
35:17
The Excel Functions Almost Everyone Overlooks (Better Than SUMIFS)
10:29
MyOnlineTrainingHub
Рет қаралды 114 М.
Top 10 Excel Functions you should learn in 2024
12:26
Chandoo
Рет қаралды 142 М.
Top 30 *Advanced* Excel Tips to make you awesome ⚡💡
22:25
Learn Power Query & Automate Boring Data Tasks in 15 Minutes!
18:45
Правильный подход к детям
00:18
Beatrise
Рет қаралды 11 МЛН