As a 46 year old novice who has been avoiding excel for over 20 years due to lack of confidence and anxiety, I love when you say “that’s all it is”. It puts me at ease. Thanks.
I have my 2nd interview next week for executive position you saved me - I havent really explored vlookup yet as I have used excel for 7 years now THANK YOU for making this lesson fun and giving us confidence, I am just going to replay this a few times for memory and practice at home on excel! THANKS
@@GuruJii hii sir campus placement k time interview me jan excel k question poochte hai to kya mouse milta hai?? Kyuki m bina mouse k krti hu to mujhse gltiya ho jaati h bhot
I have an interview for a really good job, but I will need to know Excel as I am going to use it a lot. I was so scared before saying this being presented as being so simple! Thank you a lot! ❤ i wish you success in everything you want to achive!
hi, sir, this video really took me high I'm done with my computer secretarial course passed out with 99% now I don't remember them much but now the way you thought me I will never ever forget in my life. this is really useful to me I can now easily face the interviews thank you, sir, for motivating me... This the first youtube video I'm commenting. Now I will follow all ur videos THANK YOU MAY GOD BLESS
I'm very grateful that I found this channel, because in a few days I will have an interview on skype about excel multiple filters will take 5 minuts, so I was affraid I will not be enough good but this lesson was so useful.
I was so worried as there is alot of gap to access Excel skills ....you make me confident and clear my all doubts ....now I am ready to go for interview.... thank you
Oh My God, Excel Guru!! I could recognise you from your voice, brings me back my childhood days with you and our rides back home together riding away our bicycles, im sure you would have recognised me by now? Very Happy to learn from you, Great Video! Thanks, HJ!
thank you so much :) Have an interview soon and I've forgot finer points of excel. This was very informative and motivating. catch me in the interview saying YES, SIR. I CAN.
I never really get to comment on RUclips Videos! But this video took my hand to the keyboard and get me to type" YOU ARE A PRO"SIR! This is super easy and straight to thepoint! Thank you sharing such knowledge with us !
Thank you soooo much!! I have an interview with using excel in a few hours and I was so nervous I wouldn't be able to find any helpful material. Hopefully this covers everything they need! So easy to understand :) Thank you again!
A very well explained video. Thank you. Excel Guru ji: will you be able to prepare a video where you show how to create a drop down (if menu bar is at top) or a pop up menu (if menu bar is at bottom) like how we have on web sites? Clicking on those menu items, user can navigate to different sections of the workbook. You help is greatly appreciated.
Just wanted to let you know I enjoyed video on excel interview questions. I learned Excel years and years ago, but learned a few things today that I never had to us when employed...
Watched a lot of RUclips videos for excel. This is the perfect, to the point - teacher! Thank you so much for taking the time to do this for us (people job searching).
Thanks! I have a question about the remove duplicates portion. Are the rows associated with the duplicates deleted too? Or would only the duplicates in the column be deleted and shifted upward (which mixes up the rows)?
Bhai... Can u please help me out with a this question.... Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data sepetately. Please bro, it's really important.
You are an amazing teacher omg 😭♥️ thank you!!! Even though I found this video late but I'm glad I did since I have third round interview with a Bank which is going to be technical. It's helpful. Thank youuu
Really useful, i wanted a short and accurate video which explained the basics on excel from an interview POV and i found it. Thank you for uploading this!
Hi sir I have a question, in one cell a value entered and I want to sum of this number E.g cell1-123 Cell2-9876 Cell3-3458 If I sum the value it should be in order 6 30 20 But I am unable do this through function Please help me out
My E-Lesson Hi My question was related to add value of single cell As I told previous comment Again I am reiterating I have cell, in this cell a number put e.g. 345 if I sum this number like 3+4+5 it should be come 12 I want to add single cell sum Hope you understand my question Pls reply me on below id Mohit@optum.com
Hi, now i understand it. Yes, it can be done, you would have 1st extract the content from teh cell using LEFT or RIGHT formula in combination with FIND formula an then you can add them. Its tough to do though. You learn about these formulas on my website HTTP://WWW.MYELESSON.ORG
My E-Lesson Thanks for the response So I can get my question's answered through myelession.org K if I found any difficulty then I let you know It will be more better for me if you send this my email id Thanks Mohit
As a 46 year old novice who has been avoiding excel for over 20 years due to lack of confidence and anxiety, I love when you say “that’s all it is”. It puts me at ease. Thanks.
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
@@GuruJii , what queston? Should I Vlookup it?
i like it when you say;tell them yes i can do it, you are the best
hahaha - me too! :)
also on password protection: "if you give this answer, they will be just amazed" hahah great video!
Me too hahaha
Yes
same here hhhhhh
Your tutorial was so good. I literally almost fell out of my chair when you showed me how to make a chart from F11. Thank you. Most Grateful.
I have my 2nd interview next week for executive position you saved me - I havent really explored vlookup yet as I have used excel for 7 years now THANK YOU for making this lesson fun and giving us confidence, I am just going to replay this a few times for memory and practice at home on excel! THANKS
Thanks and i wish you best of luck.
@@GuruJii hii sir campus placement k time interview me jan excel k question poochte hai to kya mouse milta hai?? Kyuki m bina mouse k krti hu to mujhse gltiya ho jaati h bhot
Love how you explain in a way simple enough to be understood by practically everyone
Amazing. I came back to inform you I just rocked the interview. Thank you so much.
Welcome Dexter. Best of luck for the new job
Congratulations
In which company you got job bro please reply me bro .iam also a aspirant to get excel related job
I like his Optimism. 'Yes, I can" [.. if I have the video in front of me at the interview, my thoughts]. Very good. Thanks.
Taught me more useful information in 10 minutes than 3 years of university. Thanks!
That’s ridiculous
You save my life. Thank you for this.
Welcome
I have an interview for a really good job, but I will need to know Excel as I am going to use it a lot. I was so scared before saying this being presented as being so simple! Thank you a lot! ❤ i wish you success in everything you want to achive!
THANK YOU SO MUCH FOR YOUR VIDEO!!!! You are the only one that explained it very well and so easy to follow!
Your teaching style is simple and effective
Your teaching style is very simple and this lesson is very important me...thank you verymuch sir.God bless you..!
(from Sri Lanka 🇱🇰 )
hi, sir, this video really took me high I'm done with my computer secretarial course passed out with 99% now I don't remember them much but now the way you thought me I will never ever forget in my life. this is really useful to me I can now easily face the interviews thank you, sir, for motivating me... This the first youtube video I'm commenting. Now I will follow all ur videos
THANK YOU
MAY GOD BLESS
Thank You so much! You just saved a college student applying for a job!
Congratulations however it shows the sad state of our colleges that you had to seek education elsewhere to get a job...
I'm very grateful that I found this channel, because in a few days I will have an interview on skype about excel multiple filters will take 5 minuts, so I was affraid I will not be enough good but this lesson was so useful.
I'm damm sure nobody can fali in the interview after watching this video. Thanks a lot for this video sir..! You are a genius 👍😇
Thank you so much Priyanka
I haven't used Excel in a while and this was the perfect tool for me... You make this look too easy!!! Thank you!
Thank you. It’s a big help for someone returning to the work force.
Welcome and best of luck for your future
I am also reviewing for returning to a new job soon. Thank you
I don't usually comment on videos but this is a life saver. Well explained and to the point. Thank you!
I am going to use this video to help me in a job interview tomorrow. Wish me luck! I need a job!!
Did you get the job?
@@najlafaizus6845 I did! :)
@@Pandidolod great 👍🏻
@@Pandidolodpls what job can I use for excel only
I love you so much!!! I have been picked over for so many jobs because my Excel skills are limited... Not any more!!! Thanks to you!!!
You can watch Excel Interview question and answer by clicking below link ruclips.net/video/RMcEn2pYgO8/видео.html
You are such a technical teacher ...easy techniques ...easy to learn..Thanks a lot..love u man..
from Bangladesh
Thanks Dost
I was so worried as there is alot of gap to access Excel skills ....you make me confident and clear my all doubts ....now I am ready to go for interview.... thank you
Thank you. To see our latest videos please visit www.myelesson.org/
Fantastic tutorial! I will have an interview working with Excel. I feel ready now! Thank you!!!
Hi friend in which company you have interview please reply me
Oh My God, Excel Guru!! I could recognise you from your voice, brings me back my childhood days with you and our rides back home together riding away our bicycles, im sure you would have recognised me by now? Very Happy to learn from you, Great Video! Thanks, HJ!
You certainly are a guru! Thank you for the easy to follow instructions!
thats a simplest form of making everyone understand excel. Thanx alot
thank you so much :) Have an interview soon and I've forgot finer points of excel. This was very informative and motivating. catch me in the interview saying YES, SIR. I CAN.
Thank you so much. You saved my life for a once in a lifetime promotion. God bless!
Love your teaching style! You are clear and quick, thank you so much.
Am going for an excel Interview on Tuesday for the first time . I think I will make it after watching this video.... thank you
I never really get to comment on RUclips Videos! But this video took my hand to the keyboard and get me to type" YOU ARE A PRO"SIR! This is super easy and straight to thepoint! Thank you sharing such knowledge with us !
Thank you so much for the kind words Ms Moruti
I totally agree.
I love the way he has given so much information in a short video.
Kudos to you sir!!!!!
Respect...
You are super talented you made it so easy to work wkth excel. Very helpful sir thanks.
@@GuruJii I also do not comment on videos but you have made this soooo simple. Thank you!!!
Thank you soooo much!! I have an interview with using excel in a few hours and I was so nervous I wouldn't be able to find any helpful material. Hopefully this covers everything they need! So easy to understand :)
Thank you again!
Hey, were you able to see the figures clearly in the video? Also good luck!
This was an awesome tutorial, sir! Thank very much for your time and information it was greatly appreciated! “Yes, I can do it,” lol👍
This is the first video of yours that I watched, and quickly follow your channel so that I can learn more n more about excel....thankyou very much
Blessed voice 😍
Thank you soo much
Wishes From Kerala
I am going to join my job tomorrow .and I am learning how to use excel.thank you,my job saver.lots of blessings for you :)
Easiest explanation ever, thank you!
You make it sound simple, and simple it is, YES I CAN DO IT!!
Very impressive and friendly way of spreading education. Wish you all the best.
Thank you dear.
Love this video and the way this bloke is commenting. You're soooo good.
A very well explained video. Thank you.
Excel Guru ji: will you be able to prepare a video where you show how to create a drop down (if menu bar is at top) or a pop up menu (if menu bar is at bottom) like how we have on web sites? Clicking on those menu items, user can navigate to different sections of the workbook. You help is greatly appreciated.
I finally understand vlookup! Thank you!!!
Just learned Excel in 11 minutes..😍🙌🙏
Just wanted to let you know I enjoyed video on excel interview questions. I learned Excel years and years ago, but learned a few things today that I never had to us when employed...
Love this guy!! so positive and such simple/clear explanations :)
YOU ARE A LIFE SAVIOR MAN !
Great job. ..tone of voice is plausible...,..
Manner too is good
Kumauni Boy Thank you sooo much dear.
My E-Lesson
sir I want all stuff related to computer skill test..
Means exercises and practice tests....
Mainly ..
Ms word,Ms Excel,Ms PowerPoint....
F11.. then the magic!!! Great shortcut! Excel is all about knowledge, indeed! Thanks for sharing!
You are wonderful
Thank you herbert mandicheta
Watched a lot of RUclips videos for excel. This is the perfect, to the point - teacher! Thank you so much for taking the time to do this for us (people job searching).
The video was so helpful and give the actual gist about the main points of excel.
Thank you for the kind words, you can see more of my videos and get free files from my website www.myelesson.org
These are a good indication of Excel skills. Especially VLOOKUP and Pivots, you can learn a lot form your candidate questioning these skills.
Thanks! I have a question about the remove duplicates portion. Are the rows associated with the duplicates deleted too? Or would only the duplicates in the column be deleted and shifted upward (which mixes up the rows)?
Thanks for the information
Thank you! Excellent video and I'm heading to your website.
😀
I already know that you are a good human being ❤️
Thank you sir :)
thank you my friend for this video, it helps a lot. God Bless you my friend.
Awesome sir. This is the video that i found where i have learnt the new things regarding MS Excel. Thank you sooo much sir.
Its really helpful to make me knowledgeable.
Thank you for the kind words, you can see more of my videos and get free files from my website www.myelesson.org
Hi sir
I am MARKET RESEARCH analyst so I mainly use excel and spss.
your videos are helpful and please share knowledge for spss also.
Using this as a refresher for an upcoming job interview. Thanks man, love it!
Bhai... Can u please help me out with a this question....
Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data sepetately.
Please bro, it's really important.
@@srinagarmagazine9250
You can use pivot tables in excel.
@@srinagarmagazine9250 unfortunately I don't know in steps, if you have a computer in front of you, you can try to play it out. Hope that helps!
@@indianspartan76 Thanks anyway brother!
You earned one more subscriber!! This was short, simple and the most easiest way to learn these difficult topics. Thank you so much.😇
thank you, this was very informative.
Thanks dear
you are the ultimate sir 🙏🙏🙏tq...no course is needed in front of ur teaching ..amazing
thank you so much God bless you
Thank you for the kind words Niguse
You are an amazing teacher omg 😭♥️ thank you!!! Even though I found this video late but I'm glad I did since I have third round interview with a Bank which is going to be technical. It's helpful. Thank youuu
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
@@GuruJii I've got the job😭😭😭♥️♥️♥️
really sir your videos are most effective we are learning a lot from videos THANKS for such video
Thank you dear, you might find this video also helpful ruclips.net/video/KyMj8HEBNAk/видео.html
A wonderful teacher you are... thank you so much
Excellent video. You explained the functions clear and effective. 👍🏻
Thanks dear
Thank you for sharing the video. Today I have learn what is Pivot tablet. Thank you once again
you are amazing thank you 🤗
Welcome Dear :) you may find this video useful ruclips.net/video/KyMj8HEBNAk/видео.html
My E-Lesson sir plz can you prepare one video on ms access
ruclips.net/video/_zxRuLJftac/видео.html
Hi
Once
I think you did very well explaining these terms in excel wonderfully and you made it so simple to understand and practice.
I'll be in my interview tomorrow like "yes sir, absolutely I know how" 👍💪
You can watch Excel Interview question and answer by clicking below link ruclips.net/video/RMcEn2pYgO8/видео.html
Best video on excel topics I have seen, Amazing work keep posting valuable videos like this, thank you
u r a lifesaver ... keep up the great work :)
your are gorgeous
Good
Marvelous.. I must say.. i never thought I could learn excel in few minutes.. simply amazing and effortless learning. Thanks!
sir, you are fantabulous. so talented you are. love your videos!
And do you have any video on SAP ??
Thank you Tanya. i dont have courses on SAP :(
gup[ta jee mail send kariy i will send u soon about sap softwere oky...my mail id is pandayrajneesh1994@gmail.com
hie Tanya ,, which module u r searching for
Please send me SAP software. My email ID is fhaque017@gmai.com
Tanya Gupta hi do you need complete set of SAP video please reply
GREAT! THE WAY OF YOUR EXPLANATION IS EXCELLENT....
Liked your video...very helpful
Thank you Prabhat
दिल खुश हो गया सर आपकी विडियो सीखने के लिए बहुत लाभदायक है
Watching this on my way to my important job interview. I lied and said I knew what a pivot was 😆😂
Did they select you?
@@ashishbairisetty984 no but I was in the top 3 at least and this video still helped lol.
You explainn much better and easier than my lecturer.
I'm going to give a interview on Excel basis if I'm selected then I let u know guys pl.pray for me it's really important for me
Best of luck.
@@GuruJii thank you so much sir it means a lot for me u gave reply
R u selected?
Really useful, i wanted a short and accurate video which explained the basics on excel from an interview POV and i found it. Thank you for uploading this!
Excellent
Brian Carpenter Thank you
Awesome! Many thanks from Stockholm, Sweden.
Are you a Telugu speaker? You sound like my favorite actor, Rana Daggubati.
Thank you.i love him too
Thanks I love the way you explain things very clear
Thank you. To see our latest videos please visit www.myelesson.org/
u should be radio DJ . mellow voice..
Thanks Ruchi
I thoroughly enjoyed the confidence you were extending at all times... really motivating...
The .XLS file is password protected.
Password is 123
I meant that the password is 123
@@soumyanayak2898 You are a legend among us humans
@@MuhammadBilal-wt2ne Touche!!!
@@MuhammadBilal-wt2ne video thik se dekho vai
Your teaching is very good. Thanks a lot
hello sir. can u help me to sap accounting online free course searching and which is best for this course. plz sir
Hello. i am not aware about SAP accounting, sorry, try searching youtube or google for it.
Ok any other computer courses can u suggest me?
i also want online course for sap fico, bsz I completed m.b.a finance
Thank you for making this video! It was very easy to understand and I like the way you teach!
Thank you. To see our latest videos please visit www.myelesson.org/
Hi sir
I have a question, in one cell a value entered and I want to sum of this number
E.g cell1-123
Cell2-9876
Cell3-3458
If I sum the value it should be in order 6
30
20
But I am unable do this through function
Please help me out
Mohit Thakur I did not understand the question
My E-Lesson
Hi
My question was related to add value of single cell
As I told previous comment
Again I am reiterating
I have cell, in this cell a number put e.g. 345 if I sum this number like 3+4+5 it should be come 12
I want to add single cell sum
Hope you understand my question
Pls reply me on below id
Mohit@optum.com
Hi, now i understand it. Yes, it can be done, you would have 1st extract the content from teh cell using LEFT or RIGHT formula in combination with FIND formula an then you can add them. Its tough to do though. You learn about these formulas on my website HTTP://WWW.MYELESSON.ORG
My E-Lesson
Thanks for the response
So I can get my question's answered through myelession.org
K if I found any difficulty then I let you know
It will be more better for me if you send this my email id
Thanks
Mohit
You gave me so much confidence after watching your video❤..thank you so much
I was panicking about an Excel interview test but after watching your video I am quite calm and confident! Thank you :)