5 Excel Questions Asked in Job Interviews ☑️

By | August 27, 2019

Hello and Welcome to MyElesson. I’m your guru. And in this video I’m going to teach you
5 most common topics that are asked in excel JOB interviews. Alright, those topics are
1- Vlookup 2- Charts
3- Pivot Table 4- Removing Duplicates &
5- Protecting Sheet These are the most commonly asked topics in
a JOB interview. And in this video you’ll learn all these
topics; alright. And there are more topics also that you’ll
be able to learn at the end of the video. I’ll tell you how you can learn all these
other topics also. You’ll also be able to download this link,
this practice file from myelesson.org at the end of the video. I’ll tell you how you can get that for free. So let’s start learning VLookup, One of
the most important question that is asked in interviews is about VLookup. So they ask you. Do you know VLookup? Simply say YES. Because after watching this video you’ll
know how to use VLookup. VLookup is nothing but a lookup formula which
allows you to fetch data based on a criteria. For example let’s understand that these
are 4 students that we have- Lucky Chawla, Thor, Munni & Sheela; alright. These are the subject that they study in-
Maths, English & Physics. And these were there marks. So lucky scores the highest 99, 99 & 99. And anything else. And these are the marks for others. Now If your teacher says that do want to
Get the marks for Thor for Maths, how would you get that. Now you can get that using Vlookup by applying
the Vlookup so we type in=vlookup, and then it says lookup value, it
would be name on the basis of which you’re looking up the result. Correct. Though we’ll select that and press comma,
and then it ask for table array. Now table array is nothing but that range
where your answer is located along with your lookup basis, That is the name. Select this completely and press comma and
now it says column index number. Now this is the most important part. Since you’re looking for the Maths, so you’ll
have to find out the column index number of Maths. How would you find that? What is the starting number? The starting number would always be that column
where the lookup basis is located, that is column 1, this is column 1. Then this is column 2, this is column 3 and
this is column 4. So Maths is column 1, we will type in column
1 So Maths is column 2, Main would be column
1 and Maths would be column 2. So (2,0), 0 would get the exact result. Nothing approx. in at that which is the nearby
as that you know. Will get the exact result always use Zero(0). And you now know marks for THOR in maths is
72. If you make it Sheela, see the marks for her
is 69; correct. Again Thor it is 72. Which is how VLookup works. You’ll learn VLookup more in details go
to www.myelesson.org And I would explain it around 10 examples. Now the next important topic is removing duplicates
in Excel. Now there are many ways os going about it. The easiest one is which I’m going to teach
you is by going to the Data Tab and using the remove duplicates option. It’s and built in command given by Microsoft
Excel. To apply this select this range, now the duplicates
are 390-390 & 490-490; alright. You select this range, go to Data and click
on remove duplicates, click on column C and click OK. And it says 3 duplicate values are found and
removed 9 unique values remains. 390 and 490 rest were gone. Click Ok. See you are able to remove duplicates. So they ask you in the…. Tell them there are many ways to going about
the. The simplest way is going to the Data tab
and using the remove duplicates. If you say this they will be impressed. Next is using password protection on you sheet. If they ask you can u do password protection? Tell them sir Yes I can do it & Three are
things that we can protect in excel. First the complete work book Where in a password
would be require to open the workbook. Second is the sheet that we are looking at
right now. This is a excel sheet. It can be protected so nobody can make a entry
over here or any changes. And the third option is locking this complete
sheet but leaving a few cells open for editing so you can say Yes sir we can do Password
protection in three ways. At the workbook level, at the sheet level
& at the cell level. I’ll tell You How. The easiest is going to File Tab & choosing
the Protect workbook option & from here choose encrypted password. Give it a password. The password I’m giving is 123. Click Ok. Type it again 123. Now what would happen if you see the colour
changes to yellow. Now If anybody tries to open this. If you email this file to anyone. If I try to open this, it will ask for a password. So that’s password protection. Now if you want to protect the sheet so that
nobody can edit anything over here then you go to review tab and click on the protect
sheet. Type the password 123 again type the password
123 and now the sheet is protected. I’m trying to chang, it is saying you can
not change anything. If you want to work on it you have to go review
tab again and click on to unprotect password and type in 123. Now you want to go ahead and say make this
range editable and the rest everything should be protected then you select this range. I’m giving it a colour so that you know
what sheet range we are talking about. Select it and go to the Font Option over here
and click on the small drop down from here go to protection and uncheck this locked option. Click Ok. And now go to review again click on protect
password, protect sheet and click on the password option and type the password 123 type it again
123 now your sheet is protected. I’m going to see if this things works. I’m going to type here It allows me to type. So now you know how to protect your sheet
at three levels. If you give this answer they’ll be just
amazed. Next more important thing they would ask do
you know how to use pivot table? Simply say Yes sir! I can do use pivot table for analysis and
data report. How do be use them? So we select our data in short there is a
header that is there on a data alright we will select it. We go to insert………the sheet is protected. So let me unprotected (haha) 123 and it is
unprotected now. Though select my data very simply like this
and go to insert and from there I insert a pivot table and now it will ask you to select
a range which is already selected always use the pivot table on new worksheet click ok
and now you can start building it. So I’m Just coming the basic of pivot table
more important features are taught on my website myelesson.org
So if I want to find out the sales for county wise for these cars then I just put the topics
over in the rows and the values if there are the numbers should come should go in values. So you are able to find how many sales are
happen in India, Japan, Pakistan & UK. You can simply find it for cities and see
for January immediately in 2 minutes you are able to get this data. For more details on pivot table go to myelesson.org
to learn more about pivot table and then they will learn about charts. If they would ask you can you prepare charts? Of course! You would have to say Yes. And I would tell you how. After watching this video you’ll know how
to create charts. Select you data and I’m going you to teach
a magic trick press F 11 automatically chart is created for your data for the suited chart. If you want to change it you can go ahead
and change the chart type from here the line chart, A Pie chart, just make it a line chart. See and the other way to going about it creating
chart is select your data go to insert and from here choose the charts. If you hover over these icons you’ll know
what kind of charts would be created. So if you want to create a pie chart, so this
is a pie chart. With one click you can create charts I’ve
taught how to create all other types of charts on my site myelesson.org
You can go there and learn more about charts. But this is the way. Now like I said that there are more things
that you can learn there are more option, more questions that can be ask they are listed
over here and this is video link You can download this sheet by going to myelesson.org and looking
for this topic excel for job interview. This is how my site is going to look like
and you go to the excel training section and you’ll find this video excel for job interviews. And from there you can download this sheet
for free. No charges. And you can learn all these options. Last I’ve covered all the other examples
over here. And also you can go video this video, it contains
all these option that I had are explained in details; alright. So hope you like this video if you did please
go ahead and click on the like button if you have a question or something to say about
my video, type in the comments and do please subscribe to my channel. So that whenever I make a new video you’ll
be informed about that and you’ll know what all new videos are coming up. You’ll also be able to see my other videos
also. And I also be motivated. So Thank You for watching this video. This was your excel guru now. Signing off for the day they have a wonderful
day. Happy Learning.

100 thoughts on “5 Excel Questions Asked in Job Interviews ☑️

  1. Mira Maca09 Post author

    Hello i just want to ask the vlookup why you need to write zero before close parentheses like colomnb 2,0) what the zero ??

  2. bhawna singh Post author

    u r a good teacher, i like dis video actually i want to do job in back office field so this will help me …… thanku

  3. shweta kulkarni Post author

    Thank you sir ….u have good voice n its very perfect to catch for mind …u r way of teaching is very simple n easy to understand n attractive skill…for grabing entire attention….all the videos are very useful for begginers…..

  4. Derrick Bryson Post author

    index and match are better than vlookup, especially for that example because it will change auto if you need a diff name and subject.

  5. Evgenia Agafonov Post author

    It's a good brief on Excel questions, thank's! But please get another mic, the sound is pretty bad and it's difficult to understand what you're saying. Thank's !

  6. Byron Dotson Post author

    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!!!

  7. ishara madhushani Post author

    Your teaching style is very simple and this lesson is very important me…thank you verymuch sir.God bless you..!
    (from Sri Lanka 🇱🇰 )

  8. Olga Vinokurov Post author

    Thank you, you’re so charming. Loved your tutorial, very simple and positive ❤️

  9. K. L. G. Post author

    Thanks for this video and download of spreadsheet. Very helpful information.

  10. Hansraj yadav Post author

    your video is nice but i knew already sir. Bring something new

  11. maria-jose barron Post author

    Fantastic tutorial! I will have an interview working with Excel. I feel ready now! Thank you!!!

  12. P Sethi Post author

    Thanks you sir.
    You are*Great*.
    I have a very humble request to you.
    Sir please kindly guide me very slowly.
    I am a slow learner sir.

  13. DaSoggyWaffle Post author

    can't find the link to download the sample from the video above …where is the exact link

  14. Amiel Sabangan Post author

    Thank You so much! You just saved a college student applying for a job!

  15. Shameer Abdul Post author

    Hi guru,

    Please teach me that how to find out latest revision in a work sheet by using formula as follows

    Drawing number-Revision
    SM10-DW-110. A
    SM10-DW-110. B
    SM10-DW-110. C

    Here are mentioned same drawing number but revisions were changed.So how to find out void and latest


  16. Alston Lobo Post author

    Thank you for sharing. Worth every minute.

  17. BudgetGlam Babe Post author

    Wow Sir. Thank you so much for this awesome tutorial. Just subscribed. Will be checking out the Website

  18. eigen Post author

    Are you a Telugu speaker? You sound like my favorite actor, Rana Daggubati.

  19. Elizabeth Ince Post author

    I'll be in my interview tomorrow like "yes sir, absolutely I know how" 👍💪

  20. Ainee Rehman Post author

    Best Video, understood so easily!! Totally impressive 🙂

  21. Umar Brima Post author

    Thank you sir, it is comprehensive how can get access to the material?

  22. poohsree Post author

    Thank u so much, i was able to learn something at the last moment before an interview !

  23. John ajay Post author

    thank you sir. It was really so simple and clear explanation

  24. HYPER Gaming Post author

    Thank u so much sir. Its very helpful for us.

  25. SANJAY JALONDHARA Post author

    Respected sir

    In one book have 100 certificate ,I want to give certificate number according to quantity5,15 …different party according to 5,15 … example certificate number 1to 5 then next party like certificate number 6 to 20 ..etc….with continues rang give some formula start with 1 to 100.

  26. Arun Kumar Post author

    Sir, thank you very much… you are really best teacher…….

  27. poonam Bakshi Post author

    Thank you sir you have explained very clearly everyone can easily understand

  28. Sarfaraj Khan Post author

    Thank you for your kind support sir.
    I have one question
    Suppose I have a huge data of employees with their single or multiple address
    Now I want to find a single address of particular employee then I can use lookup or index match formula
    But the concern is I have a multi addresses of employees
    So I want to display all address of particular employee so which formula should I apply in one click

  29. Ruksazar Ruksazar Post author

    Such good teaching video… Sir😇

  30. Joyal Mariya Tom Post author

    Thank you for your good lesson about excel in simple and understandable way. It was really helpful for me.

  31. Seema Pinto Post author

    At 8:31 he has his city listed as "Bombay" instead of mumbai! how cool

  32. Yves dela cruz Post author

    thank you my friend for this video, it helps a lot. God Bless you my friend.

  33. Tamjid Arefin Post author

    You are such a technical teacher …easy techniques …easy to learn..Thanks a lot..love u man..
    from Bangladesh

  34. Kendall Outlaw Post author


  35. Khan1 Hamza1 Post author

    vedio buht acha but kia ye app English bolni walo ko sekatin hu ya urdu hindi speak bolne walo ko.not agree this language

  36. diegoaop Post author

    Great material and tutorial! Thanks a million!!

  37. Audrey Dimson Post author

    I subscribed not because I need more but because thats the easiest way to show support. You deserve all the good things in the world sir! Thank you for the vid 🤗

  38. Audrey Dimson Post author

    0:57 VlookUp
    3:20 Remove Duplicates
    4:20 Password protection
    6:50 Pivot Tables
    8:30 Charts

  39. VLADZF Post author

    You are God send. I feel way more confident now for my interview tomorrow to become an FA

  40. Lovely Thakur Post author

    Just wow. The way you explain. Thank you so much.

  41. Dexter Morgan Post author

    Amazing. I came back to inform you I just rocked the interview. Thank you so much.

  42. Adrian Roberts Post author

    I fail to see the point of vlookup. What have I missed?

  43. Reshma Sharin Post author

    It's so good sir. Thank you so much sir

  44. syeda tabassum fareed Post author

    Thank you for sharing your knowledge, it was a great help

  45. tay riii Post author

    thanks very interesting better than learning in a class here you can rewind, pause etc

  46. Annapurnasenapati1995 9090350345 Post author

    thank u very much.its very useful

  47. Ivy Rica Federis Post author

    I just subscribed! I love how the way you teach sir, thank you for making it easy to follow.

  48. Anoop Bartaria Post author

    Sir i am having the lower version of the ms excel. So how can i put a password in that sheet like suppose I have the version of system windows 7.

  49. Black Heart Post author

    Wow! This was awesome! I didnt know about the chart f11 trick so cool! Thank u so kuch Sir!

  50. Meesu Technology Post author

    Plz suprt me…

  51. Brianna Hall Post author

    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!

  52. P Elangovan Post author

    You taught to protect your excel workbook by going to file and selecting PROTECT WORKBOOK( and adding a password) – Also guide how to set the workbook free from password protection .or deactivate the password protection.

  53. Julia Abelle Post author

    I locked with password the workbook from "File" as you showed. How do I unlock it now? Cannot find an 'unprotect' option as with the Sheet protection.

  54. Csilla Alfoldi Post author

    OMG this video was so simple and useful!!! Thank you! I am going to check your website now!

  55. Vishwas Post author

    Thank u cause of u I can crack the interview u made it easy


Leave a Reply

Your email address will not be published. Required fields are marked *