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.
@GuruJii2 жыл бұрын
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
@DanAlexandruGeorge2 жыл бұрын
@@GuruJii , what queston? Should I Vlookup it?
@ms.will-i-ams17116 жыл бұрын
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.
@dimaomar94276 жыл бұрын
i like it when you say;tell them yes i can do it, you are the best
@ia22916 жыл бұрын
hahaha - me too! :)
@Zonex1235 жыл бұрын
also on password protection: "if you give this answer, they will be just amazed" hahah great video!
@walterlizama13595 жыл бұрын
Me too hahaha
@snarayanak29344 жыл бұрын
Yes
@nhevkurd19583 жыл бұрын
same here hhhhhh
@bknightify6 жыл бұрын
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
@GuruJii6 жыл бұрын
Thanks and i wish you best of luck.
@rashmigupta2889 Жыл бұрын
@@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
@davidomondi80366 жыл бұрын
Love how you explain in a way simple enough to be understood by practically everyone
@xotweetypiexo6 жыл бұрын
Taught me more useful information in 10 minutes than 3 years of university. Thanks!
@mohamedalhusni62552 жыл бұрын
That’s ridiculous
@pmb56435 жыл бұрын
I like his Optimism. 'Yes, I can" [.. if I have the video in front of me at the interview, my thoughts]. Very good. Thanks.
@Damsharas5 жыл бұрын
Amazing. I came back to inform you I just rocked the interview. Thank you so much.
@GuruJii5 жыл бұрын
Welcome Dexter. Best of luck for the new job
@funkeokeniyi65564 жыл бұрын
Congratulations
@reddymekala85493 жыл бұрын
In which company you got job bro please reply me bro .iam also a aspirant to get excel related job
@fatinnnnnnn6 жыл бұрын
You save my life. Thank you for this.
@GuruJii6 жыл бұрын
Welcome
@emmamocanuu Жыл бұрын
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!
@aubshkabobcabanna70976 жыл бұрын
THANK YOU SO MUCH FOR YOUR VIDEO!!!! You are the only one that explained it very well and so easy to follow!
@sakil066 жыл бұрын
Your teaching style is simple and effective
@DeathNachos000175 жыл бұрын
Thank You so much! You just saved a college student applying for a job!
@paeden54313 жыл бұрын
Congratulations however it shows the sad state of our colleges that you had to seek education elsewhere to get a job...
@nehakamble42932 жыл бұрын
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
@GuruJii2 жыл бұрын
Thank you. To see our latest videos please visit www.myelesson.org/
@bernadineschacht81755 жыл бұрын
Thank you. It’s a big help for someone returning to the work force.
@GuruJii5 жыл бұрын
Welcome and best of luck for your future
@clarelee39875 жыл бұрын
I am also reviewing for returning to a new job soon. Thank you
@dianagrace79546 жыл бұрын
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
@piatale77736 жыл бұрын
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 👍😇
@GuruJii6 жыл бұрын
Thank you so much Priyanka
@westdallasboy44545 жыл бұрын
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!!!
@drm95144 жыл бұрын
You can watch Excel Interview question and answer by clicking below link kzbin.info/www/bejne/iH7GdqFopb6ahZo
@Pandidolod7 жыл бұрын
I am going to use this video to help me in a job interview tomorrow. Wish me luck! I need a job!!
@najlafaizus68452 жыл бұрын
Did you get the job?
@Pandidolod2 жыл бұрын
@@najlafaizus6845 I did! :)
@najlafaizus68452 жыл бұрын
@@Pandidolod great 👍🏻
@uchihaid4842Ай бұрын
@@Pandidolodpls what job can I use for excel only
@luisheran6686 Жыл бұрын
I haven't used Excel in a while and this was the perfect tool for me... You make this look too easy!!! Thank you!
@isharamadhushani70065 жыл бұрын
Your teaching style is very simple and this lesson is very important me...thank you verymuch sir.God bless you..! (from Sri Lanka 🇱🇰 )
@gladysmoruti6 жыл бұрын
I never really get to comment on KZbin 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 !
@GuruJii6 жыл бұрын
Thank you so much for the kind words Ms Moruti
@vikrantrajput82116 жыл бұрын
I totally agree. I love the way he has given so much information in a short video. Kudos to you sir!!!!! Respect...
@sadiabanu27266 жыл бұрын
You are super talented you made it so easy to work wkth excel. Very helpful sir thanks.
@genevievemartinez7695 жыл бұрын
@@GuruJii I also do not comment on videos but you have made this soooo simple. Thank you!!!
@mjbarron515 жыл бұрын
Fantastic tutorial! I will have an interview working with Excel. I feel ready now! Thank you!!!
@reddymekala85493 жыл бұрын
Hi friend in which company you have interview please reply me
@AlinaNegoescuqi6 жыл бұрын
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.
@tamjidarefin66815 жыл бұрын
You are such a technical teacher ...easy techniques ...easy to learn..Thanks a lot..love u man.. from Bangladesh
@GuruJii5 жыл бұрын
Thanks Dost
@noelgonzalez95496 жыл бұрын
I don't usually comment on videos but this is a life saver. Well explained and to the point. Thank you!
@IAmGarimon6 жыл бұрын
You certainly are a guru! Thank you for the easy to follow instructions!
@nehabachuwarful6 жыл бұрын
thats a simplest form of making everyone understand excel. Thanx alot
@athanvi1117 жыл бұрын
Easiest explanation ever, thank you!
@briannahall26145 жыл бұрын
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!
@shubhangisrivastava28505 жыл бұрын
Hey, were you able to see the figures clearly in the video? Also good luck!
@gdragon12686 жыл бұрын
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.
@msprits15 жыл бұрын
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!
@105mteso7 жыл бұрын
Love your teaching style! You are clear and quick, thank you so much.
@marciamuthakhi76323 жыл бұрын
Am going for an excel Interview on Tuesday for the first time . I think I will make it after watching this video.... thank you
@Kakarbatoo2 жыл бұрын
This was an awesome tutorial, sir! Thank very much for your time and information it was greatly appreciated! “Yes, I can do it,” lol👍
@Howtoexcelatexcel6 жыл бұрын
These are a good indication of Excel skills. Especially VLOOKUP and Pivots, you can learn a lot form your candidate questioning these skills.
@syedali85697 жыл бұрын
Very impressive and friendly way of spreading education. Wish you all the best.
@GuruJii7 жыл бұрын
Thank you dear.
@madalitsochilalire52192 жыл бұрын
You make it sound simple, and simple it is, YES I CAN DO IT!!
@PahariTrader6 жыл бұрын
Just learned Excel in 11 minutes..😍🙌🙏
@gemgem35705 жыл бұрын
Thank you so much. You saved my life for a once in a lifetime promotion. God bless!
@fabinaameer22555 жыл бұрын
Blessed voice 😍 Thank you soo much Wishes From Kerala
@mahnazbristy21306 жыл бұрын
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 :)
@originalsweetz6 жыл бұрын
Love this guy!! so positive and such simple/clear explanations :)
@laurynmanu55256 жыл бұрын
Love this video and the way this bloke is commenting. You're soooo good.
@soundfeetmarketing93287 жыл бұрын
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)?
@francescomanier12467 жыл бұрын
F11.. then the magic!!! Great shortcut! Excel is all about knowledge, indeed! Thanks for sharing!
@saurabhm197826 жыл бұрын
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.
@cheryljjohnson80447 жыл бұрын
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...
@paraprakash_94116 жыл бұрын
Great job. ..tone of voice is plausible...,.. Manner too is good
@GuruJii6 жыл бұрын
Kumauni Boy Thank you sooo much dear.
@paraprakash_94116 жыл бұрын
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....
@ayeshashrivastava44282 жыл бұрын
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
@karishmasoni50766 жыл бұрын
The video was so helpful and give the actual gist about the main points of excel.
@GuruJii6 жыл бұрын
Thank you for the kind words, you can see more of my videos and get free files from my website www.myelesson.org
@VinodKumar-fv6bu6 жыл бұрын
दिल खुश हो गया सर आपकी विडियो सीखने के लिए बहुत लाभदायक है
@indianspartan766 жыл бұрын
Using this as a refresher for an upcoming job interview. Thanks man, love it!
@srinagarmagazine92502 жыл бұрын
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.
@indianspartan762 жыл бұрын
@@srinagarmagazine9250 You can use pivot tables in excel.
@indianspartan762 жыл бұрын
@@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!
@srinagarmagazine92502 жыл бұрын
@@indianspartan76 Thanks anyway brother!
@sirat.e.mustaqeem13316 жыл бұрын
I was panicking about an Excel interview test but after watching your video I am quite calm and confident! Thank you :)
@xerge145 жыл бұрын
thank you my friend for this video, it helps a lot. God Bless you my friend.
@chapettewhat51587 жыл бұрын
I finally understand vlookup! Thank you!!!
@jesusfollower38356 жыл бұрын
Thank you! Excellent video and I'm heading to your website.
@GuruJii6 жыл бұрын
😀
@acoolbeebaugh42935 жыл бұрын
Watched a lot of KZbin 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).
@herbertmandicheta6 жыл бұрын
You are wonderful
@GuruJii6 жыл бұрын
Thank you herbert mandicheta
@Crocodilekumar2 жыл бұрын
YOU ARE A LIFE SAVIOR MAN !
@luzy995 жыл бұрын
I'll be in my interview tomorrow like "yes sir, absolutely I know how" 👍💪
@drm95144 жыл бұрын
You can watch Excel Interview question and answer by clicking below link kzbin.info/www/bejne/iH7GdqFopb6ahZo
@Ranger24-z9b2 жыл бұрын
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
@GuruJii2 жыл бұрын
Thank you for the question, we will get back to you soon. In the meanwhile please visit www.myelesson.org for more excel resources
@Ranger24-z9b2 жыл бұрын
@@GuruJii I've got the job😭😭😭♥️♥️♥️
@Anythiing-time6 жыл бұрын
Its really helpful to make me knowledgeable.
@GuruJii6 жыл бұрын
Thank you for the kind words, you can see more of my videos and get free files from my website www.myelesson.org
@naheedyousuf22386 жыл бұрын
Marvelous.. I must say.. i never thought I could learn excel in few minutes.. simply amazing and effortless learning. Thanks!
@gauudi82306 жыл бұрын
Excellent video. You explained the functions clear and effective. 👍🏻
@GuruJii6 жыл бұрын
Thanks dear
@rashirao3127 Жыл бұрын
You earned one more subscriber!! This was short, simple and the most easiest way to learn these difficult topics. Thank you so much.😇
@MarkStJohn-jn4lz5 жыл бұрын
thank you, this was very informative.
@GuruJii5 жыл бұрын
Thanks dear
@kashishhinduja45156 жыл бұрын
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.
@ravikant83447 жыл бұрын
really sir your videos are most effective we are learning a lot from videos THANKS for such video
@GuruJii7 жыл бұрын
Thank you dear, you might find this video also helpful kzbin.info/www/bejne/gaqwm2t-eqeBd80
@kunalparmar21632 жыл бұрын
Best video on excel topics I have seen, Amazing work keep posting valuable videos like this, thank you
@nigusechewaka66676 жыл бұрын
thank you so much God bless you
@GuruJii6 жыл бұрын
Thank you for the kind words Niguse
@Suvendu.Ganguly3 жыл бұрын
I thoroughly enjoyed the confidence you were extending at all times... really motivating...
@tanyagupta81157 жыл бұрын
sir, you are fantabulous. so talented you are. love your videos! And do you have any video on SAP ??
@GuruJii7 жыл бұрын
Thank you Tanya. i dont have courses on SAP :(
@rajneeshpandeyrj58067 жыл бұрын
gup[ta jee mail send kariy i will send u soon about sap softwere oky...my mail id is pandayrajneesh1994@gmail.com
@sailessahoo26137 жыл бұрын
hie Tanya ,, which module u r searching for
@fhaque63027 жыл бұрын
Please send me SAP software. My email ID is fhaque017@gmai.com
@sudhakarmani40767 жыл бұрын
Tanya Gupta hi do you need complete set of SAP video please reply
@AyushTiwari-r2o11 ай бұрын
Thanks for the information
@sushmitagogoi63397 жыл бұрын
you are amazing thank you 🤗
@GuruJii7 жыл бұрын
Welcome Dear :) you may find this video useful kzbin.info/www/bejne/gaqwm2t-eqeBd80
@sushmitagogoi63397 жыл бұрын
My E-Lesson sir plz can you prepare one video on ms access
@THEVIRALSTORY7 жыл бұрын
kzbin.info/www/bejne/lavbg6iCf8unl8U
@mohammedaliumair53296 жыл бұрын
Hi
@mohammedaliumair53296 жыл бұрын
Once
@chetanaanuraj24243 жыл бұрын
Awesome sir. This is the video that i found where i have learnt the new things regarding MS Excel. Thank you sooo much sir.
@amybeelicious5 жыл бұрын
Watching this on my way to my important job interview. I lied and said I knew what a pivot was 😆😂
@ashishbairisetty9843 жыл бұрын
Did they select you?
@amybeelicious3 жыл бұрын
@@ashishbairisetty984 no but I was in the top 3 at least and this video still helped lol.
@Mojoglowfitness2 жыл бұрын
I think you did very well explaining these terms in excel wonderfully and you made it so simple to understand and practice.
@AartiSharma-vu6qe7 жыл бұрын
u r a lifesaver ... keep up the great work :)
@chefdeprestigellc88556 жыл бұрын
your are gorgeous
@Mahi693496 жыл бұрын
Good
@gauthamjoy68393 жыл бұрын
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!
@prabhatghosh886 жыл бұрын
Liked your video...very helpful
@GuruJii6 жыл бұрын
Thank you Prabhat
@s0xispatfe6 жыл бұрын
Very nice, all the useful things in less than 11 minutes. Great work, loved your attitude. Thank you!
@snigdha28385 жыл бұрын
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
@GuruJii5 жыл бұрын
Best of luck.
@snigdha28385 жыл бұрын
@@GuruJii thank you so much sir it means a lot for me u gave reply
@appleeye39725 жыл бұрын
R u selected?
@allenkhadambi13325 жыл бұрын
You explainn much better and easier than my lecturer.
@eigen12555 жыл бұрын
Are you a Telugu speaker? You sound like my favorite actor, Rana Daggubati.
@GuruJii5 жыл бұрын
Thank you.i love him too
@elisaels6 жыл бұрын
Awesome! Many thanks from Stockholm, Sweden.
@briancarpenter64136 жыл бұрын
Excellent
@GuruJii6 жыл бұрын
Brian Carpenter Thank you
@safashaharban52932 жыл бұрын
I already know that you are a good human being ❤️ Thank you sir :)
@ruchiparihar84226 жыл бұрын
u should be radio DJ . mellow voice..
@GuruJii6 жыл бұрын
Thanks Ruchi
@awacheikhdiop13582 жыл бұрын
Thanks I love the way you explain things very clear
@GuruJii2 жыл бұрын
Thank you. To see our latest videos please visit www.myelesson.org/
@aartidave23937 жыл бұрын
hello sir. can u help me to sap accounting online free course searching and which is best for this course. plz sir
@GuruJii7 жыл бұрын
Hello. i am not aware about SAP accounting, sorry, try searching youtube or google for it.
@aartidave23937 жыл бұрын
Ok any other computer courses can u suggest me?
@gazi4u1287 жыл бұрын
i also want online course for sap fico, bsz I completed m.b.a finance
@kirankumarnm86316 жыл бұрын
you are the ultimate sir 🙏🙏🙏tq...no course is needed in front of ur teaching ..amazing
@soumyanayak28985 жыл бұрын
The .XLS file is password protected.
@GuruJii5 жыл бұрын
Password is 123
@GuruJii5 жыл бұрын
I meant that the password is 123
@MuhammadBilal-wt2ne5 жыл бұрын
@@soumyanayak2898 You are a legend among us humans
@pratikmishra5485 жыл бұрын
@@MuhammadBilal-wt2ne Touche!!!
@akashmahesh31245 жыл бұрын
@@MuhammadBilal-wt2ne video thik se dekho vai
@rosichard7 жыл бұрын
Thank you for sharing the video. Today I have learn what is Pivot tablet. Thank you once again
@mohittheshinethakur90317 жыл бұрын
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
@GuruJii7 жыл бұрын
Mohit Thakur I did not understand the question
@mohittheshinethakur90317 жыл бұрын
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
@GuruJii7 жыл бұрын
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
@mohittheshinethakur90317 жыл бұрын
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
@debasmitajhimde45633 жыл бұрын
A wonderful teacher you are... thank you so much
@lizarrrdbeth3 жыл бұрын
This is very good. I liked the pace. Some videos just drag on. This is great and straight to the point!!
@Sara-jc4xw6 жыл бұрын
You are very straightforward! Thanks!
@saggi23114 жыл бұрын
Great you are great... imparting such knowledge is good.God bless you.Yes I do shiver when I receive excel test in interview coz I am know basic, but interviewer need more n more of it.Thanks once again