Watched this video 30 minutes before an interview which is a good thing because they tested me on Excel. I aced the test and got the job. Definitely recommend as a quick starter or to refresh your memory on some of the basic formulas. Thanks for the vid!
These are great tools and appreciated very much. I love the list one and didn't know what Vlookup was, so thank you for taking the time to make this video. :)
It's is a very awesome videos... People who want to learn if see this videos they will eager to learn more.... Thanks you soo... It's so easy to understand and the way u taught it's nice.... Keep making
It’s a really great video, this will make people more eager to learn. Thank you so much. You make it a lot more easy to understand, keep up the great work*
I came upon this video yesterday and I must say that's such a good explanatory video. I know how to use basic excel but never came across these formulas. This video helped me a lot and I was even able to take notes. Thank you very much.
Super Teacher, Anybody can learn even online if you will be the teacher, I have excellent command on all these 10 formula, I can now say that I know some of excel which I couldn't say before. I used to stand silent in Job when asked for Excel knowledge. Great job done by You. Your Voice is also DamDar ;)
Thank you, so much! I used to be intimidated by Excel, but the way you went over these formulas, made it so easy to understand and apply. I'm updating my spreadsheets, right now and they look so professional!
Excellent explanations. I knew everything up to VLookup but didn't know drop down and sum if and love the idea of making things easier for my workers by giving them dropdowns to select instead of putting in values. Thank you for the help.
i was have a excel exam i was thinking how do i stared riding so i think about it and i was opend the you tube and wached your videos and now I passed thank you:)
Nice video! I'm posting in a discussion for my computer essentials class and linking this video. Thanks for the help! I haven't learned anything about topics 8-10 in the class but I can see the benefits of them.
hi Sir myself khan hasnain from India Mumbai iam currently studying finance diploma from NIIT and i find your video Awesome. Iam sure that your this video will Help me a Big time in future interview with MNC thanks very much
I'm between newbie and beginner in excel, so thanks so much for this!! I'm starting a job on the 16th, and it's going to require more in-depth knowledge of excel than I currently have. Thank you!!!
Very helpful video. I followed the steps in using the formulas so that I can also try it for myself while watching this vid. The instructions are easy to follow. Thank you very much.
I have to tell very nice presentation and you helped me a lot with my excel formulas I don't know how you just made the formulas soo easy to use and understand thanks a lot May Allah guide you on the right path if you are not already and may Allah have mercy on you and your family 👍
Very very thanx to u dear.....this video helped a lot to me......and i have also found some new formulas to teach my students.... Once again thanku u very much sir....
Hi! Thank you for making these videos. I'm one of those really having a hard time passing job interviews because I'm not proficient in excel. I have watched just up to counta and I must say you have a way with making it easy to follow and learn.
Sir I am a big fan of your videos and they way you explain. Tomorrow I going for an interview. That is totally based on excel. I hope I will get chance after watching this video. Thank you so much sir.
1. Sum 0:25
2. Average 2:05
3. Count 3:37
4. Counta 4:25
5. Concatenate 5:08
6. IF 6:58
7. Countif 9:46
8. VLookup 11:36
9. DropDown 13:52
10. Sumif 14:50
thanks for supplying this list so i can go on to other videos with more depth.
d. veritas saved my life
Thank you sooooo much @d. veritas
Data validation ??
yes
Watched this video 30 minutes before an interview which is a good thing because they tested me on Excel. I aced the test and got the job. Definitely recommend as a quick starter or to refresh your memory on some of the basic formulas. Thanks for the vid!
Vlookup with the drop-down was worth a comment for sure!
Best ever video , no useless stuff , to the point .
I didn't have any idea about the formulas in excel but I needed this for my job. This video was very helpful. Thank you sir.
Welcome Srimoyee
Very Nice
Explained such a nice way..
i will learn you this formula give me your no
aye mai sekha do apko sb kch
To me, you will always be the best teacher ever.
Enjoyed this vid so much.. and yes it deserves a beautiful comment. May God bless u
Thank you for the kind words @Zainab
Very nice video... simple, punctual, short, no bla-bla-bla BS. Very knowledgeable! I'am subscribing this channel. Thank you for good lesson.
I like how you listed a table of contents in the beginning. Other people's videos take forever to get to the point
Beautiful explanation not everyone can explain the way that everyone can understand, ur awesome 👏👏👏👏👏
These are great tools and appreciated very much. I love the list one and didn't know what Vlookup was, so thank you for taking the time to make this video. :)
You are welcome
mene first time dekha or apny bht acha smjhaya ... great
Sir, bcuz of u, I think I have become an expert in no time in a day!
Thanks Waqas.
ua-cam.com/video/DRQiXnueD6c/v-deo.html
Sir, I gave a pure thumbs up to this video.
My good sir, you're incredible! Thank you so much for this super helpful video!
sir ur method of teaching is awsome...!!!! u have explained v welll , thank u.........
It's is a very awesome videos... People who want to learn if see this videos they will eager to learn more.... Thanks you soo... It's so easy to understand and the way u taught it's nice.... Keep making
Welcome Dear and thank you for the kind words.
Mmm
Dilip Gupta stuhdeuijcdeio
It’s a really great video, this will make people more eager to learn. Thank you so much. You make it a lot more easy to understand, keep up the great work*
True, I'm Malaysian but this was brilliant by our superb teacher.
Your videos are worth watching twice
I am about to appear in CBE where spreadsheet topic is mandatory to have command over and to be honest your video helped me a lot. 👍
Best of luck dear !
Im loving it sir in simplest way you teach formulas lots of respect from pakistan.
i love this man wit a passion so genuine
Thanks
Thanks! Your presentation makes Excel even easier! Rgds from SD!
its 2019 and yes you deserve a thumbs Up ..
Thanks Shayne
I came upon this video yesterday and I must say that's such a good explanatory video. I know how to use basic excel but never came across these formulas. This video helped me a lot and I was even able to take notes. Thank you very much.
Best Explanation...These all formullas u explained very clearly...Thanks...well done...
Welcome Dear and thank you for the kind words.
Super Teacher, Anybody can learn even online if you will be the teacher, I have excellent command on all these 10 formula, I can now say that I know some of excel which I couldn't say before. I used to stand silent in Job when asked for Excel knowledge. Great job done by You. Your Voice is also DamDar ;)
now am sure.. i got confidence i learnt many things about excel. Thank you sir for this video.. thumbs up for this video.
i have to sheets 1, production and 2, sales of 20 products with different quantity, how i can prepare stock details with quantity.
This video should help you ua-cam.com/video/D7rnlaR8Arc/v-deo.html
can i help you
you made excel so easy...awesome video
Always a fan of your video. very nice presentation
Welcome Hassa, Which formula do you like the most ?
My E-Lesson i love Concatenate and regularly use SUM but i wasnt familiar with the trick of Alt =
thanks to u
Yes, That ALT= trick i awesome. There is another trick to create instant chart . Select data and press f11 !
thanks for making our life easier
thank you very much.... you are teaching in the way of easy ... i have understood literally than i imagined ..
so nice. ....
Had an excel interview before and ending up badly, now looking back to that test, i finally realised what I should have done. Many thanks!
sir, can u please teach us analytical tools also like tableau, SAS, R and phython
i will try to do so in the future
If you know any basic SQL as well I'd appreciate it. Thanks for your videos.
Truly, it gives me insight about basic formulas in excel. This can help me a lot. Thanks a lot. You are a good teacher.
nice work
ua-cam.com/video/DRQiXnueD6c/v-deo.html
Wonderful video.. all these days I struggled learning vlookup and Bam I know how to use it now..
thankuu sooo much sir...
Welcome Dost
YOUR-WAY-OF-TEACHING-IS-SO-GOOD.
"I learned that from Hancock"
Straight to the point tutorial. 10/10 for me.
@7:47 hindi is not "the" language of the country.There are 22 other official languages my friend. Stop hindi imposition. Have a nice day :)
wow u look scared dude are the beating u to learn hindi??
6/ if 7/ Coutif Formula 8/Vlookup 9/ Dropdown List 10/ Sumif all are great Formaula
Have a business management exam on excel tomorrow! Cramming as much of these videos as I can haha, thank you Sir for these informative videos!
It's perfect... Very smoothly you explained..
Thank you, so much! I used to be intimidated by Excel, but the way you went over these formulas, made it so easy to understand and apply. I'm updating my spreadsheets, right now and they look so professional!
A very clear explanation!
Hi there, I just learned so much, thank you. I could listen to you all day!
Very useful for beginners who use excel in office.Keep posting more vedios .Good job
Awesome Video... & the way you are explaining is very simple and very easy to understand. Thank you for the video
Step by step tutorial. It's nice and easy to follow.
Excellent lesson. So helpful and worth it.👍
Excellent explanation with smart examples.....love it!
KANIGANTI VIJAY KUMAR welcome dear
Nice .. short, simple and in easier u have explained...keep it up😊
Thanks Neha
Million thanks for your lesson. It is very useful to my daily job.
GREAT WORK!!!! EASY TO UNDERSTAND
Relevant & reliable formulas thks e leason for explaining each & evry miner details of excel . Loads of thx to u
Very helpful and I like the positive and fun personality you show while teaching us the formulas. Thank you!
Excellent explanations. I knew everything up to VLookup but didn't know drop down and sum if and love the idea of making things easier for my workers by giving them dropdowns to select instead of putting in values. Thank you for the help.
Great Video ....Very Easy to understand....Thanks much
Good video with some useful formulas
SUPERB GURU GEE ... KAMAL KER DIYA AAP NE GOD BLESS YOU HABIBI "THUMBS UP"
I like the way you teach, it sound simple and easy. Thank you.
You are the best helper i ever seen on yt, big ur self up my g
VERY WELL EXPLAINED.THANKS!
I love the way you teach.. very clear thank you so much
i was have a excel exam i was thinking how do i stared riding so i think about it and i was opend the you tube and wached your videos and now I passed thank you:)
Nice video! I'm posting in a discussion for my computer essentials class and linking this video. Thanks for the help! I haven't learned anything about topics 8-10 in the class but I can see the benefits of them.
Guruji your way of explaining is excellent.
Thankyou Guru, you make it seem so easy, Explained so clearly.
You are the best teacher!!! on this!!!!
hi Sir myself khan hasnain from India Mumbai iam currently studying finance diploma from NIIT and i find your video Awesome. Iam sure that your this video will Help me a Big time in future interview with MNC
thanks very much
dragon ball z fan
vaibhav wasnik
Imma saiyan
your cosider ownself saiyen ....nice kept it up haaaa
Very informative and educational video, in a simple and easy to follow format with a good commentary.
I'm between newbie and beginner in excel, so thanks so much for this!! I'm starting a job on the 16th, and it's going to require more in-depth knowledge of excel than I currently have. Thank you!!!
Thanks alot guru ji for free informative videos, much love and support
Very helpful for Excel users covers some good formulas
Yes you definitely deserve a thumbs up
I have a final exam in excel in a few hours, this is the best review!!! Thank you for posting this!
Excellently explained !
Good one. I didn't think about Vlookup with Dropdwon list . That's excellent
Sharing knowledge in a great way...thanks
Very helpful video. I followed the steps in using the formulas so that I can also try it for myself while watching this vid. The instructions are easy to follow. Thank you very much.
I have to tell very nice presentation and you helped me a lot with my excel formulas I don't know how you just made the formulas soo easy to use and understand thanks a lot May Allah guide you on the right path if you are not already and may Allah have mercy on you and your family 👍
Thanks Ameer
YOU'RE A GENIUS..THANKS FOR SHARING
Beautiful. You made it so easy to understand, that's really an art of presenting science. Thanks a lot
well good job Mr.excel...u were asking for give u thumbs up...seriously u deserve it...👍thanks for it...keep it up ☺
This video was amazing! thank u so much. ur indeed a very good teacher.
Very very thanx to u dear.....this video helped a lot to me......and i have also found some new formulas to teach my students.... Once again thanku u very much sir....
Sir your all vedioes are very very usefulness. Yuo are very. Intelligent person. Thnks
Very easy to explain, all in one lesson. So grateful for this video, great tools for my job. :D
Thanks for the useful formulas with your good explanation
I like your enthusiasm,thanks for the video.
Thanks mate! Easy and super useful 🤩
The way explained is too good & understandable...
Thank you
Hi! Thank you for making these videos. I'm one of those really having a hard time passing job interviews because I'm not proficient in excel. I have watched just up to counta and I must say you have a way with making it easy to follow and learn.
Thanks for your tremendous efforts and time
I am your biggest fan my son😍 it's awesome and best video as before
Very helpful and easily explained. Cheers to you, teacher!
wonderful!! learning excel has never been so easy and joyful. Thanks alott!
Sir I am a big fan of your videos and they way you explain. Tomorrow I going for an interview. That is totally based on excel. I hope I will get chance after watching this video. Thank you so much sir.