12 Excel FUNCTIONS Made Easy [SUM, SUMIF, COUNT, COUNTIF, MAX, MIN.....] | ExcelJunction.com
HTML-код
- Опубликовано: 24 мар 2017
- Practice file for DOWNLOAD: www.exceljunction.com/12-excel...
The most used functions in Excel are the ones that sum and count. You can sum and count based on a single or multiple criteria. This lesson covers:
SUM, SUMIF, SUMIFS, COUNT, COUNTA, COUNTIF, COUNTIFS, AVERAGE, AVERAGEIF, AVERAGEIFS, MAX, MIN
Am so much grateful, the turtorials are so helpful. It was hard to understand my college tutor in limited time. Now I have found stressfree help.
Thanks a lot , you are one of the best teachers in the world of Excel!
Thank you so much for your kind words. Just trying to do my bit. Such appreciation by viewers is very encouraging. Will try to come up with more useful lessons.
This is explained in such a simple manner, thank you, sir ............
You are good teacher, thank you for this video.
First time i saw the most easiest way to use IF formulas thats awesome
Thanks for appreciating Moeez. Do subscribe the channel and share with your friends too. Best Regards
Incredible. Learned so many functions in just one video. Delivery of the video was simple and informative. Thank you!
Thanks for appreciating
Awesome! The best teacher in Excel ever lived in the planet earth! Thank you so much Teacher. I really understood everything from the beginning of the video til the end of it. Amazing! God Bless you more!!
Thanks for the kind words. Glad, could be of help.
Just going for an interview and had a look over it and now im clear about the functions. Thank you sooo much sir.
Which company you are working?
Best way of teaching
You are by far the best teacher I've come across. I was petrified of excel formulas and you made it look believable. Thank you
Thanks for the kind words.
I actually got this question (the one uploaded as the PDF) as the annual project !! At first, i couldn't do it, but then for god's sake, I found out the source (this video) and so it made my life a hell easier...Easily explained, this was a gr8 vvideo....!!
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
perfect! I did not understand a thing when our teacher taught us. Thanks for video need more of them and subscribing you
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
This is explained in such a simple manner, thankyou so much.
Thanks for appreciating.
I'm in trouble with my table. I can't tell it here. How can i contact you
Please post your query on our WhatsApp group www.exceljunction.com/whatsapp-group/
You are the reason i will get a good grade on my excel test!
Happy if we could be of any help. Wish you all the best for your test 👍
The formulas are a bit tricky but I'm gradually picking up, thanks very much.
Awesome! Easy and most importantly fast and all in one video!
Thanks for the terrific job, it solves almost all of my daunting task.
You did an excellent job explaining how each one works!! Love it!!
+TT Matt Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Thank you so much for this video! You must be a great teacher! 😊
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
You are a good teacher. Your speed in teaching is just perfect for me to follow and understand . You are the best !!! Keep it up Sir.
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
Thank you so much for this video! you must be a great teacher!
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
what if you have the total and you need to subtract others as you enter and the total column will zero at the end. please help
wow !. You really simplified it all for me. Thank You very much
Thank you for this video which taught basic excel calculation in the most easiest way.
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
Really nice to see your video. I have learn more now. Thanks so much. Really hope to get more useful functions from your video.
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
Hi, the method of explaining is very fantastic can understand everyone....thank you for this video... very usefull..Thanks....
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
Explained practically by applying each function . Well done Sir. Thanks.
You are welcome
So effective example, with everything into it.
Thank you for a nice tutorial in heavy used excel functions!
Thanks for your videos in simpler way to understand Excel function..
Please check with avgif and avgifs selection criteria..I didn't understand these two function
Please do not forget to 'subscribe' to our channel for more such useful videos.
Thank you so much for the understanding on the functions.will come back for more on excel..have an assessment to do
Cheers
Very informative and easy to understand
Thank God for the video lectures, I have learnt a lot. I gained confidence in my excel studies.
Thanks for your kind comments. Much appreciated. We'll try to make more such useful videos. Do not forget to subscribe the channel.
Thank you very much , it is kind of you to help us understand excel basics properly
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
very nice way of explaing all necessary formulae in one excel file in a very shrt time..
Plese explain during putting any formula how can I understand where I putt Bracket & comm (," ") as i show on the comment Beause i don't know (where_ when_ what) I think You understand pleas upload detail video
Thanks so much, this is the most easiest way to learn this formula that has being a problem to me. Thanks once again
Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Thank you for the wonderful lesson, I have learnt something
Thank you for this video!Explained very well and easily to understood :)
+Eziz Karliyev thank you for appreciating. Please spread the good word. Do not forget to subscribe the channel for more useful stuff.
you helps me lot,. thank u so much sir.
I know understand better. Thank you very much.
your explanation is very very ultimate. you explained in a very simple language and a lay man can also easily can understand.. became a big fan of you brother.. vamsi from india
Thank you so much for your kind comments 🙏
thanks for your valuable guidance
+Shirish Shelke Thanks for appreciating Shirish. Do subscribe the channel and share with your friends too. Best Regards
Hello Sir, So precise! So clear! And to the point! Thank you for sharing. Bless you!
Thanks for appreciating. Please do like the video and subscribe our channel for more such useful videos.
Formula's make excel a very powerful tool.
+John D Yes, very much
Amazing tutorial love this first tym i seen how to use these functions with more easily...
Thanks for appreciating. Please do subscribe our channel for more updates.
Excellent sir you are great teacher in the worĺd
That was so much helpful for most of us.
Glad you found it helpful. Please spread the good word. "Like" and "Subscribe" for more such useful videos.
preparing for my interview tomorrow :^)
You know i failed in interview bcz i have less knowledge in excel,have u got job
This really helps, Thanks!
Thank you so much
It is very very simple method
Thank you
You did a brilliant job
Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Thanks for teaching me this better that school
Happy to help
Loved it...Thank you for posting...Your video is very helpful and easy to understand as well
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
Whoa,,,, thanks for sharing,,,, GOD bless for your all good works,,,,,
Thanks for appreciating. Do not forget to like and subscribe our channel for more such useful videos.
Very informative! And peaceful voice 👍🙂
It has been a great lesson....Thanks so much
THANK YOU! YOU HELPED ME SOOOOO MUCH!
Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Thank you sir it's help in my practical tomorrow
Glad that it helped you. Do subscribe the channel for more such useful videos.
it nice and regular useful formulas so thnx sir........to bring essy it for us........
Thanks for appreciating. Please "Like" and "Subscribe" for more such useful tutorials.
well explained...…...thank you sir
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
Thanks Sir, the video is simple and clear.
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
I loved this it's awesome and most easy
Great that you liked. Please have a look at other videos too in our channel. You may find them useful too. Do not forget to "subscribe".
Excellent Sir. Thanks a lot.
FANTASTIC SIR THANK YOU, SIR, IT WILL HELP ALL
Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Very knowledgeable. Thank you.
Thanks very much I enjoyed it
Good information for the beginners. very clear.
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
Brilliantly explained. Thanks
Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Very helpful. Thanks a lot
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
Good sharing, my brother👍👍
Very helpful. Thank you!
Student is written wrongly as" sudent" However it is a very helpful video!
absolute lifesaver g, thx
you are vary good teacher thanks so much
Thanks for appreciating. Please subscribe the channel for more such useful videos.
thanks for good explanation
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
Thank you so much. It is simple and excellent.
Thank you for appreciating. It keeps us going. Cheers!!
THANK YOU SO MUCHHHHHH!!!!!!
OK, THANKS.
best teacher
អរគុណអ្នកសម្រាប់មេរៀនដ៏ល្អមួយនេះ
+Seyha Vann please post in English. We could not figure out what you're trying to say.
oh my got. i just wrote in Khmer to say thank you for sharing a very useful lesson on this excel function. Thank you again for caring about this. excellent!
+Seyha Vann Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Very Nice tutorial, I learned something new from you.
Hope you can clarify my doubt
Can we count numof cel by filled colors? "Not by the by alphanumerical data".
Please post your query on our forum. www.exceljunction.com/forum/
Wow. Awesome teaching
Glad you liked it
Amazinggggggggggggggggggggg thanks
very helpful and clear. Thnks a ton!
Thanks for appreciating.
this was super helpful
Thank you. Do not forget to subscribe our channel for more such useful videos.
Excellent ji...thank you so..much....
+arunthejeanious Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.
Welldone sir, its so easy and perfect way to learn Excel sheets
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
Sir, It is so educative. Thanks for sharing. I have a query, How to find the list of student names that scored more than 60marks...
Excellent! Thank you so much.
You're very welcome!
Thanks for the great info
Thank you. Do not forget to subscribe our channel for more such useful videos.
Thanks
You sir are amazing thank you
You are very welcome
VERY GOOD... AND WELL EXPLAINED
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
this is sooooo good thanks
Thanks for appreciating. Please like and subscribe our channel for more useful updates.
Thank you, Very well explained
+Jagath Kumar Many thanks for appreciating. Please "like" and do not forget to "subscribe" the channel.
Thanks it is useful nice sir..keep teaching
I like this way teach. Slow and easy to get in touch.
I just really understand and learned , now.
Those Fast teaching , ... !!!!!! , ?????? .☹️☹️☹️😥😳🤕
Thank you. Do not forget to subscribe our channel for more such useful videos.
Thanks so very much Sir
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
its very use full sir thsnk u very much
Thanks for appreciating. Please do subscribe our channel for more updates.
Thank you for sharing the knowledge. It is really useful, Like,Subscribe & Share as well. I had been using few of them, but this is refreshing kind of video. I had share with some one who really wants to learn and your explain it very well.
Cheers and thanks for appreciating.
Hi mate, could you please tell me, what is the name of the application that you are using to capture screen?