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*
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!
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.
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!
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 👍
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.
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 ;)
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.
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.
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.
This is incredibly helpful, and your teaching style is super friendly and encouraging. I'll be recommending this to everyone I know, and definitely intend to use your website from now on!
You can also create drop down list by using Developer>Insert and pickup drop down tool and directly link to cell range. Incase data validation is not avaliable.
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!!!
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
Vlookup with the drop-down was worth a comment for sure!
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
I like how you listed a table of contents in the beginning. Other people's videos take forever to get 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
Best ever video , no useless stuff , to the point .
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
My good sir, you're incredible! Thank you so much for this super helpful video!
Very nice video... simple, punctual, short, no bla-bla-bla BS. Very knowledgeable! I'am subscribing this channel. Thank you for good lesson.
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.
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
To me, you will always be the best teacher ever.
i love this man wit a passion so genuine
Thanks
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.
Beautiful explanation not everyone can explain the way that everyone can understand, ur awesome 👏👏👏👏👏
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.
thank you very much.... you are teaching in the way of easy ... i have understood literally than i imagined ..
its 2019 and yes you deserve a thumbs Up ..
Thanks Shayne
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!
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
Truly, it gives me insight about basic formulas in excel. This can help me a lot. Thanks a lot. You are a good teacher.
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
Good video with some useful formulas
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.
Very helpful and I like the positive and fun personality you show while teaching us the formulas. Thank you!
so nice. ....
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!
thankuu sooo much sir...
Welcome Dost
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
@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??
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.
nice work
ua-cam.com/video/DRQiXnueD6c/v-deo.html
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 learned that from Hancock"
Nice .. short, simple and in easier u have explained...keep it up😊
Thanks Neha
6/ if 7/ Coutif Formula 8/Vlookup 9/ Dropdown List 10/ Sumif all are great Formaula
Relevant & reliable formulas thks e leason for explaining each & evry miner details of excel . Loads of thx to u
Wonderful video.. all these days I struggled learning vlookup and Bam I know how to use it now..
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!
Thanks! Your presentation makes Excel even easier! Rgds from SD!
its very useful ,and easy to understand.
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.
Awesome Video... & the way you are explaining is very simple and very easy to understand. Thank you for the video
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.
Million thanks for your lesson. It is very useful to my daily job.
Step by step tutorial. It's nice and easy to follow.
sir ur method of teaching is awsome...!!!! u have explained v welll , thank u.........
Very helpful for Excel users covers some good formulas
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.
Hi there, I just learned so much, thank you. I could listen to you all day!
You are osm . Dnt know why m getting so much of positive vibes from u. Love you sir❤️
now am sure.. i got confidence i learnt many things about excel. Thank you sir for this video.. thumbs up for this video.
I like the way you teach, it sound simple and easy. Thank you.
Sir, you're a great teacher ❤️ little humour and giving every tiny knowledge.
This is incredibly helpful, and your teaching style is super friendly and encouraging. I'll be recommending this to everyone I know, and definitely intend to use your website from now on!
Sir, I gave a pure thumbs up to this video.
I have a final exam in excel in a few hours, this is the best review!!! Thank you for posting this!
Beautiful. You made it so easy to understand, that's really an art of presenting science. Thanks a lot
Very useful for beginners who use excel in office.Keep posting more vedios .Good job
I love the way you teach.. very clear thank you so much
Very informative and educational video, in a simple and easy to follow format with a good commentary.
Sir your all vedioes are very very usefulness. Yuo are very. Intelligent person. Thnks
nice way of teaching and the way u present makes it unique ...all the best mr.guru
Thanks Sam
Thank you so much. This helped me grasp the most basic and fundamental formulas of Excel. I really appreciate it. God bless.
Thankyou Guru, you make it seem so easy, Explained so clearly.
Your videos are worth watching twice
Thanks alot guru ji for free informative videos, much love and support
the presentation is queit inspiring,easily to learn, fantastic..
I just love all of your videos sir. Thank you so much for giving this much information... It helps a lot... keep it up sir. 👍 God bless you!
Thanks Priyanka for the kind words.
My E-Lesson
Thank u for the putting light on my excel knowledge, u r doing wonderful job man again thank u n keep helping people like us cheers!!
Guruji your way of explaining is excellent.
Very useful. If you could highlight or show the short cut keys you use time to time in the screen, it would be even more helpful 👍
very effective video for beginners like me, thank you so much, May Allah bless you 👍
I like your enthusiasm,thanks for the video.
You can also create drop down list by using Developer>Insert and pickup drop down tool and directly link to cell range. Incase data validation is not avaliable.
Very easy to explain, all in one lesson. So grateful for this video, great tools for my job. :D
Your's explaination technic is very easy andeffective.
Thanks a lot sir for the amazing Excel training your providing. Your really an Excel expert. Keep it up. Your student from Pakistan. Regards.
Actually a good video. It was the only video that actually helped me with Vlookup.
Welcome dear.
zeest mahmud ل
It's perfect... Very smoothly you explained..
Thank you sir it's very help full video for me and i am learning very easy because you has create very easy and good PPT. thanks again
Really great explanations and easy to follow. Thank you
Welcome Jeanne
Excellent lesson. So helpful and worth it.👍
Straight to the point tutorial. 10/10 for me.
Thanks sir for point to point to explain excel formulas
This video was amazing! thank u so much. ur indeed a very good teacher.
Thank you so much sir may Allah Bless you.
My pleasure sir.
Thank you. To see our latest videos please visit www.myelesson.org/
its the best learning lecture regarding excel i ever had. thank u so much sir.
thank you, very logical and quick explanation
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!!!
Thank u so much sir .we want more functions like this .your English is very catchy
You are the best helper i ever seen on yt, big ur self up my g
Thanks alot for sharing the content. Its very useful. very nice presentation.
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.
Good one. I didn't think about Vlookup with Dropdwon list . That's excellent
Ahh, finally such simplified clear explanation! Thank you!