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. :)
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!
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*
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 ;)
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.
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....
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.
Thank you, Guru for your lessons. I wanted a refresher course to enable me to get an office job and am happy I came across "E-lesson". Unfortunately I'm having trouble downloading, can you help out please?
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.
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
To me, you will always be the best teacher ever.
Vlookup with the drop-down was worth a comment for sure!
Very nice video... simple, punctual, short, no bla-bla-bla BS. Very knowledgeable! I'am subscribing this channel. Thank you for good lesson.
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
sir ur method of teaching is awsome...!!!! u have explained v welll , thank u.........
I like how you listed a table of contents in the beginning. Other people's videos take forever to get to the point
Best ever video , no useless stuff , to the point .
Enjoyed this vid so much.. and yes it deserves a beautiful comment. May God bless u
Thank you for the kind words @Zainab
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
thank you very much.... you are teaching in the way of easy ... i have understood literally than i imagined ..
My good sir, you're incredible! Thank you so much for this super helpful video!
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!
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
Im loving it sir in simplest way you teach formulas lots of respect from pakistan.
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.
mene first time dekha or apny bht acha smjhaya ... great
i love this man wit a passion so genuine
Thanks
Awesome Video... & the way you are explaining is very simple and very easy to understand. Thank you for the video
Best Explanation...These all formullas u explained very clearly...Thanks...well done...
Welcome Dear and thank you for the kind words.
Guruji your way of explaining is excellent.
its 2019 and yes you deserve a thumbs Up ..
Thanks Shayne
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
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 ;)
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 !
Thanks Guru, it was very useful but can you please tell me is there are any videos which you have uploaded for Macros since I want to know about that?
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.
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
Excellent lesson. So helpful and worth it.👍
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.
Sir, I gave a pure thumbs up to this video.
so nice. ....
Thanks! Your presentation makes Excel even easier! Rgds from SD!
nice work
ua-cam.com/video/DRQiXnueD6c/v-deo.html
Your videos are worth watching twice
thankuu sooo much sir...
Welcome Dost
Truly, it gives me insight about basic formulas in excel. This can help me a lot. Thanks a lot. You are a good teacher.
@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??
Sir your all vedioes are very very usefulness. Yuo are very. Intelligent person. Thnks
"I learned that from Hancock"
Very useful for beginners who use excel in office.Keep posting more vedios .Good job
Thankyou Guru, you make it seem so easy, Explained so clearly.
It's perfect... Very smoothly you explained..
Million thanks for your lesson. It is very useful to my daily job.
Nice .. short, simple and in easier u have explained...keep it up😊
Thanks Neha
Relevant & reliable formulas thks e leason for explaining each & evry miner details of excel . Loads of thx to u
SUPERB GURU GEE ... KAMAL KER DIYA AAP NE GOD BLESS YOU HABIBI "THUMBS UP"
Wonderful video.. all these days I struggled learning vlookup and Bam I know how to use it now..
Great Video ....Very Easy to understand....Thanks much
Step by step tutorial. It's nice and easy to follow.
Thanks alot for sharing the content. Its very useful. very nice presentation.
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....
VERY WELL EXPLAINED.THANKS!
I love the way you teach.. very clear thank you so much
Excellent explanation with smart examples.....love it!
KANIGANTI VIJAY KUMAR welcome dear
I like your enthusiasm,thanks for the video.
now am sure.. i got confidence i learnt many things about excel. Thank you sir for this video.. thumbs up for this video.
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.
Hi.. Your vedio is very much helpful...
I want to know the basic difference between sum if and sum ifs formula .. And which one is better?
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!
Very helpful for Excel users covers some good formulas
Thanks alot guru ji for free informative videos, much love and support
thank you, very logical and quick explanation
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.
the presentation is queit inspiring,easily to learn, fantastic..
YOU'RE A GENIUS..THANKS FOR SHARING
Thanks sir for point to point to explain excel formulas
Your's explaination technic is very easy andeffective.
Sharing knowledge in a great way...thanks
Very informative and educational video, in a simple and easy to follow format with a good commentary.
Thanks for your tremendous efforts and time
Thanks mate! Easy and super useful 🤩
Thank you, Guru for your lessons. I wanted a refresher course to enable me to get an office job and am happy I came across "E-lesson". Unfortunately I'm having trouble downloading, can you help out please?
Straight to the point tutorial. 10/10 for me.
Excellently explained !
Great Job buddy, very useful and nice explanation, thanks alot
awesome...keep this spirit on..
so you can help us to add confidence in our life
HI. i wanted to ask you if it is possible to concatenate more than two cells? If you could do a video about that, it'd be great. Thank You
Thank u so much sir .we want more functions like this .your English is very catchy
A very clear explanation!
I am a beginner to excel I need to learn pivots, vlookup, charts and all. What do you suggest me to start with and do you Have a video on pivots?
very knowledge able nd most imp helpful .................. keep it up, gud job
Tanx very much Sir
What an energetic presentation.
sir i am love in it... so in future you give me another special work presentation...........................
I truly understood your video
Thanks for explaining👍👍
thank you so much. This was very helpful... Do you have any one with database and queries in database?
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.
It is more useful for me. thank you for uploading this video....You are welcome to upload more videos....
Thanks for the useful formulas with your good explanation
YOUR-WAY-OF-TEACHING-IS-SO-GOOD.
GREAT WORK!!!! EASY TO UNDERSTAND
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!
You are the best helper i ever seen on yt, big ur self up my g
This video was amazing! thank u so much. ur indeed a very good teacher.
Very nice video, it solved my problem,, THANKS
Very Nice Information Sir, I am reached on correct place where I can learn each and every thing in Excel
Useful video and nice Explanation.