How to ACE Excel Interview Questions (Based on YOUR feedback & by Position)

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@67duiker]

I can recommend taking the courses from Leila. I have learned a lot and they are extremely useful in a work-environment. I also would like to stress that it's better to give accurate answers for your skills. You will need those for the job if you get it. And it's not good to be fired in your probation period for not knowing what you said you knew. Also if you don't get fired the stress level of doing a job above your expertise is quite high. honesty in an interview is very important from both sides.

[@empsgrr57shulz71]

She is the best teacher in KZbin Channel.

[@0707ravi]

Yes she is very good in teaching but cant afford the price of the course ☹️

[@jannisar-b1v]

With lots of tutorials and mentors on KZbin Leila is just outstanding. Thank you so much for the free content❣

[@LeilaGharani]

Glad you think so!

[@MrAloha]

You ROCK! Leila is the best Excel Instructor in the world! I can say that - I teach Excel and I learn from her! Thanks, Leila! 💪😀

[@SeanGHOB]

If I were asked to use INDEX and MATCH in an Excel test, I would definitely run into difficulties. I've used them before, but I don't know if an interviewer would appreciate me opening KZbin to watch one Leila's videos as a refresher the way I normally would in a work environment. On the other hand, maybe I would get extra points for knowing where to look!

[@LeilaGharani]

Knowing where to look is always a good start 😁

[@foxbox7929]

they'd probably say "shit, she's how we get this stuff done too"

[@dnorm]

Yep... youtube for formula's and excel forums for vba help.

[@ambhat3953]

I kinda used to get mixed up too....I used to interchange position of match and index function. Then I used "I am(I'm)" as short form to realise I comes outside and M goes inside. And once you start typing match using auto generated parameters values of excel, rest will follow easily.

[@GpD79]

What I learned from this video is that I really don't know much!

[@LeilaGharani]

There's always more to learn :)

[@englishmeg]

Hi, I have been to your UTube U. I now have a "degree" in excel. I work at a big pharma company. The MDs and PhDs think I am a smart person! Thanks!

[@LeilaGharani]

Glad the content is useful for you, Meg!

[@vamsiputthuru5836]

Hi Lelia, your youtube channel has changed my total excel skill set mind, i am recommending to my friends and colleagues. You're an Excel master at all. Thank you a ToN.

[@LeilaGharani]

Wow, thank you!

[@himanshuvajani4477]

Genius video. Rarely I come across a video that is so on point as these videos are so practical and makes followers not just consume content but also makes them job ready.. thank you genuinely!!

[@yugalgarg]

Hi Lelia, I generally watch your videos and they are so much informative and i learn a lot from them. I really appreciate your efforts on making us learn a lot of things which makes our life simpler and better in the most effective way. I want to request you to please make a video on how can we call a table from insert function and match the formatting in a different tab, I am unable to do even after months of tries. Again thankyou so much for the resources you provide us.

[@HHH-nv9xb]

At one time I am was an expert spreadsheet user (123). Now, I am a more of a DBMS person (advance) and now am just a casual spreadsheet user. When I do have to use advance tasks in spreadsheets, I think DBMS. I know often there is an equivalent way of doing it in spreadsheet. I can be done, it is just matter of looking it up. Advance spreadsheet sheet features seems to get users to use more DBMS functionality.

[@apamwamba]

Same here

[@chh8860]

This was a brilliant idea for a video ... and very well done (no surprise). Leila comments at the 1:18 mark " ... If you prefer to learn in a more structured way with a lot more hands-on practice, taking a course might be good preparation for you ...". No, not 'might' ... but 'will'. The material is well organized and delivered in understandable nuggets.

[@ScottLititz]

As an interviewer, I always ask people about familiarity with Excel. Many have said they are good with it, but freeze when given a test that starts with a blank sheet. It's then you find out they know how to use an already constructed file, but have no idea how to start at square one. Knowing the functions/key phrases sometimes is not as good as being creative to reach an answer using a blank palette.

[@LeilaGharani]

Many thanks for your feedback!

[@amylasher87]

actually, some ppl just don't test well

[@georgejetson9801]

@@amylasher87 That's true.

[@georgejetson9801]

I've used Excel since it came out in the 80s. Does that mean I have everything on the tip of my tongue ready to recite at an instance? Of course not.That doesn't mean I'm not capable of doing the job. I think some interviewers like to pretend the are clever by trying to trip people up.

[@natynt227]

@@georgejetson9801 i agree with you

[@teforapapadi6280]

Thank you very much....I always leave your sessions feeling smart.....Thank you once more......

[@angelrodriguez7237]

Thank you SOOOO MUUUUUCH Ms. Gharani !!!! We so appreciate your content and help. So much of practical on the job skills are not taught in school or by jobs. You’re expected to learn on your own on your own time. I’ve learned so much from you. Danke!

[@LeilaGharani]

My pleasure, Angel 😊

[@StanEby1]

On both style and substance you are superb. You have really organized for us a clear outline of Excel capabilities and uses, helped us mentally summarize our skill sets, and helped us identify the areas we need to improve. Just what the doctor ordered. Thank you.

[@mrnjobvu8861]

Am enjoying lessons. madam you are so good.keep it up

[@tedgrove9412]

This woman is the best. Subscribed! I need to get proficient at Excel in a short period of time, and this channel is a godsend.

[@LeilaGharani]

Welcome aboard!

[@SeamusHarper1234]

As an interviewer, I find it hard to get a nail on a persons excel skills. People often truely believe that they mastered Excel, but they often do not even realize how much there is to know. Also, knowing your way around Excel functions is one thing, but that can be trained really well on the job. What matters even more is a comprehensive understanding of "How" a task should be solved. Like, how do I setup a spreadsheet so that it is safe to use, error resistant, usable by other people, do I better use VBA oder Powerquery... Asking questions and using tests is the key here!

[@FarhanMerchant]

Makes me realise how much more to keep going. Fantastic insights, Thank you

[@LeilaGharani]

You're very welcome :)

[@StephenBoothUK]

A big factor in the sort of questions you get asked is likely to be the size of the organisation. For example, in a larger organisation they are more likely to have people who do the VBA development (probably along with other development work) but in an SME they probably won't. I'm surprised not to see DAX in the list.

[@upendrasharma4257]

So I had to stop my class in between to appreciate your work. Your excel power query course is awesome. I am just learning day by day and I hope it will automate most of my work I do using excel file. Thanks a ton and for sure... no hesitation to recommend your work to all who truly want to learn Excel...!!!

[@LeilaGharani]

Wow, thanks!

[@vijayarjunwadkar]

Thank you Leila, for this crisp and clear video. I am sure many are going to really benefit knowing this. Great work! And links to various topics videos is an added bonus! 😊👍

[@marioayala2510]

I'm from Honduras, i just found out your channel and i love it. You truly are a huge creative person and you have so much knowledge that's amazing. Thank you for sharing!

[@rp5339]

Thank you as always Laila for sharing your knowledge with us.

[@LeilaGharani]

My pleasure!

[@ahamadaibrahimben8596]

As usual your videos are very useful and more exciting. Thanks Coach Leila

[@vineethalekshmy5359]

hi leila,for administration position what might be the expected questions for a practical exam?thank you

[@apamwamba]

I have been using Excel since 1997..Thing is I hate tests that test on memory or that test on wizardry. If you can do basic charts , pivot tables ,power query , power pivot, Basic DAX. You are good to go. Spice up with databases, then you are a hero. I dont worry about memorizing specific functions. I look them up when I need to. I also feel VBA is not a must know tool for most users out there. A little macro knowledge can be helpful. I like this channel because of the wonderful tips that can make one a rock star...

[@georgejetson9801]

Agree. I'll bet 90% of the people interviewing you never had to pass such trivia tests to get the job.

[@Christy-fn7cg]

She is great, very clear!

[@bharatkotwani9311]

Best instructor, I have ever seen 😇

[@markissleepy]

I'm always surprised to hear that someone got asked about Excel charts in an interview. To me that seems more "froufy" - it's make it look pretty stuff, not something useful or practical in most cases. My experience has always been that charts are used for external reporting, occasionally by HR, and for sales/marketing but no one internally ever looks at them or even wants them - from the CEO to the CFO to project managers and team leads, everyone wants to see the actual data (obviously, summarized in most cases, not the full data set, but in something like a well-designed pivot table, never in a chart or graphic). I've been a financial and billing analyst for 10+ years and worked in various mid-level management jobs for 10 years before that and no one has ever asked me for a chart; the couple times I provided one because I thought it might illustrate some point better, everyone completely ignored it.

[@Mazen_2016]

i think maybe in interviews they over test the applicants , maybe in the actual job they wont need all the stuff they've been asked about or tested the about , but i think their point of view is "to know more than you need" maybe !

[@actocalmness4918]

Thank you for all the helpful information.

[@ICOD73]

I think excel interview questions should be a practical test. I am not good with remembering formulas and steps but tell me what you want done and I can do it.

[@wayneedmondson1065]

Hi Leila. Awesome advice and insight! Moral of the story.. study, learn, practice, explore.. as much as possible. The more you know, the more creative you can be and the more complex problems you can solve. Thanks for sharing all of your great resources, wisdom and knowledge :)) Thumbs up!!

[@LeilaGharani]

Yes! Thank you!

[@GDMonty1029]

I’m the lead accountant at my company, so I’ve interviewed a lot of candidates over the years for various levels, and I always ask them to rate themselves on Excel knowledge, and they of course are all experts. I then ask them my favorite interview question: what’s your favorite Excel formula, and when did you last use it? A lot of the “experts” freeze up when I ask that, and say something like VLOOKUP. I’m typically less concerned with what they say, and more interested in how excited they are about the topic. The best candidates come back with a quick answer, and explain both how they learned it, and how it improved their process.

[@LeilaGharani]

Great way to assess candidates. Thanks for sharing your experience!

[@s3icc0]

My answer: "Sir, there is no formula ... it is either Ctrl+E o Group By"

[@sundertalreja7208]

I am surprised, VBA still needed ! I find power query much easer to automate the tasks and build data models.

[@micha4186]

Well, VBA can do a lot more than Power Query. Maybe that's why

[@lkumar2727]

Yes, I m using vba since 5 year....i can say that vba much better than power query.... But power query easy for automate.. And you can learn fast also compare to vba... But company will prefer to vba candidate.... Bcs power query anyone can learn in few days but when comes to vba it's not a cup of tea for some excel user.

[@andrewmoss6449]

You can pretty much gauge someone’s overall knowledge of Excel by asking them about VLOOKUP, INDEX/MATCH and XLOOKUP. If they can only explain how to use the first, it’s very likely they’re a novice. If they can explain all three, it’s a good indication they will also be aware of how to use the other new functions and dynamic arrays.

[@aakarshpratap3200]

I would consider myself of an intermediate to advance user. However I haven't used Xlookup as my firm still uses excel 2016. I know how it works in theory but haven't played around with it.

[@LeilaGharani]

Good point!

[@maryqc8418]

Helpful video. Thank you.

[@georgeaboh]

I love your bright color dress. They add beauty to your videos.

[@vanmij4926]

Working in a country like Belgium, the most difficult things is to know the name of functions in different languages. I'm at the level where Excel starts to have a lot of concurrence from other BI tools such as Business Objects (SAP), Qlikview, etc but they often have a final button to generate an excel report in the end just as an easy to access way to share reports. Microsoft did his best to develop Power Pivot, Power Query, Power Bi so sometimes if i'm just only using excel, if got to remender how things went to create same levels as what i did in the BI tool, but depending on the employer i work in Dutch, French or English version, luckely with the same country settings. And even though in the menu everything is on the same place it's like in another language i have to start all over again, i do not know or i didn't try yet that if i'm in a dutch situation Excel accepts English formulas and i know that i have to try if to use a "," or like in Dutch ";" in the formulas, i know this is a particular situation, we even do not use a QWERTY keyboard

[@turntalkpodcast4324]

Just bought your Google sheets course on Udemy 😊 excited to learn.

[@MillersLanguageSchool]

Thank you for your knowledge!

[@sachinrv1]

What's the importance of semi-colon (;) in Excel? If I write 3 in cell A1, 5 in cell B1 and in C1 a formula =A1+(A1>B1), what will be the result ? With these questions, I got the candidate tottering. There are so many intricacies in Excel which most of us don't know. Most of the people feel that VLOOKUP is the end of Excel, which is their huge underestimation. Thanks Leila for educating us. Cheers :)

[@lawrencekazibwe9751]

Thanks alot Leila, it's very informative

[@LeilaGharani]

My pleasure, Lawrence.

[@dilipinamdarpatil6301]

Thanks for sharing your knowledge 🙏🏼

[@LeilaGharani]

My pleasure!

[@HRH_Queen_JoJo]

What about support roles? That’s the information I was hoping to hear about.

[@brightafghans2886]

Thank you Leila

[@brahmmamb24]

Every video helpful in any position ...Thanks for sharing and I strongly recommend your couriers and chennal...

[@LeilaGharani]

So nice of you!

[@ATInstitute]

After my Exam, i will take it a rountine to watch and pratice minimum of 1video on this page

[@tifouraamina1761]

Oh great, Thank you Leila you're the best 😃

[@LeilaGharani]

You're welcome 😊

[@everything5568]

very very informative video

[@jasonipfatsiong2062]

So does phone a friend…Leila an available interview option lol…admittedly I do support the testing portion, even if it’s simple exercises, particularly if it is core requirement job. Thanks Leila useful preparation.

[@LeilaGharani]

Haha, that would be too easy 😂

[@Tina-gp4rg]

I can't thank you enough.

[@siddiqi111]

Laila o Laila. Your videos are awesome with good training

[@kossiviaglee2997]

Good to know, thanks!

[@MohitKumar-ec4en]

Thanks Mam, Waiting for next video on same topic.

[@SyedMuzammilMahasanShahi]

Thank you for the share.

[@syedabbasalim4675]

Hey leila, When will be your power BI videos will available.. Really waiting to learn from you.. Kindly do the show

[@bheemarajukrishna8272]

Mam, can u make video regarding full course on EXCEL.

[@s3icc0]

Well ... is that what employers expect in US? In my position I need to work with data, analyse and report, but what I need to really know in excel? 1. I need to be able to prepare some mockups of the reports or to test and present new report, but the detailing and final realization is then passed to a BI professional who just have to do what I say :-) My emploer is sometimes upset I use PowerQuery extensively as they don't like/understnd the initial load ...

[@s3icc0]

anyway - nowadays if the question is to describe drawbacks of VLOOKUP for me its biggest drawback is the existence of XLOOKUP. The moment I get the feeling the employer wants me to use old version of excel, it is not him trying to eliminate me as candidate, it is me trying not to become an employee.

[@danicasrsen4935]

Thank you so much!!

[@emmafeng55]

thank you so much!

[@lopher70]

I think a test of Excel is mandatory for each candidate. I had several cases that I had to teach the basic to the new hires and that doesnt help I mean, they dont need to be a guru in excel, but they need to have what is neeeded

[@ranaganguli2892]

Really superb...

[@ai_dividend_daily_1]

Great Infos...thx

[@MJBrown901]

Hi Leila! May I recommend a video topic? google data studio vs microsoft power BI

[@LeilaGharani]

I'll think about it. Thanks for the suggestion!

[@MJBrown901]

​@@LeilaGharani As Peter Teil would say, "Competition is for losers", one area for youtube that has no competition so far is Google glide tutorials, and how it can be used with Data studio (possibly linked through coupler.io but I haven't played around enough yet). Right now I'm trying to figure out how to make an app for our foremen to do their daily reports on their phones a little easier. There's so many applications though, from payments, to delivery tracking, quality control or safety documentation.. and you can send stuff from the google sheets to make reports. Google data studio should be able to give your presentations to all your CEO's and the coupler.io app should connect your reports from the glide app to your presentations for live updates. Tutorials on the use of these apps is minimal and could have a huge impact for businesses and hopefully your youtube channel, because I love the way you deliver your content.

[@Live-Entrtainment35]

Maam , Why did you not making as same videos on Advanced and Basic Lavels Tutorials on ( Power Bi , Tableau Dynamic Dashboards , Calculation fild , Dax , Charticulator - Charticulator it's Inbuild hidden function of Power Bi for Making For Dynamics ,Charts , diagrams for make Viz. from (Power Bi -Custom Charts app source , how to make Tableau Custom Charts ) , Numpuy , M-Language , Panda's , Python lang.) Please also make videos on this topics / Subject Basic to Advanced tutorial & updates. You should make videos on this topics , ma'am your tutorials are helpful for us of billion dollers we got learning from your channel ,so I have described this topics start tutorial on this topics or make otherwise separate channel for topics bcoz it's demanding/ Trending for upcoming jobs requirements as well as Adv Excel function & Tricks. With an real job query data using formulas. Please start this tutorial 👆on this described what I've topics in Bracket , please a reply me if this feedback helpful ma'am. Thank You , Ma'am Regards, Amar😊

[@nareshmakwana32324]

❤❤❤❤❤ good 👍👍👍👍👍🎉🎉🎉🎉

[@domnicking3965]

Mam, thanks for helping us.. i have one more doubt, do we have an formula to consolidate 2 different columns into one in microsoft excel? i am currently converting columns into 2 tables and appending both ... pls need ur guidance .. it would be great ful to u.. pls help

[@SeamusHarper1234]

+1 for the coffee cup. Be carefull not to #spill :-D

[@cellchow2339]

Just wondering what kind of job interview would ask Excel based questions. I have been working as system developer, teacher, and now as a building surveyor but never for once in my life i have been asked an Excel based question during job interview

[@iamcurios]

Ma'am,, could u give any solution for dependent drop-down list auto update? For example if A1 cell changes den B1 remain in result of A1s previous value, When B1 drop-down list depend on A1 drop down value..

[@deepaksahu-nf1vb]

Hello mam I am your student from past 3 year I have questions I am senior analyst . I know advance excel power query power pivot and even Regular DAX function as well I am hesitate to learn VBA because of coding part I am not sure should I learn VBA and how much it will be useful can you guide and if possible can you plz explain through video anyday

[@jeffc5218]

Thanks for the share Leila! Definitely useful! 💯

[@tutorials--1234]

I am surprised at the basic-level of knowledge that seems to be required for those types of positions...

[@naveedazam1445]

Me too...

[@apamwamba]

much of the work using excel does not really require very advanced skills

[@ambhat3953]

Very advanced Excel is kind of useless in current scenario where million row data has become a norm. And anyone who uses excel for such data...good luck.

[@carlingas666]

I know how to use pivot tables cause at work this fu cation makes my job a lot easier and faster. I use if functions and sum functions. I see that I need to learn more :(

[@chandannasta]

Hello Leila Mam. First time saw ur video really liked it. I need some help. Can I mail you so that you can view my data and help me out

[@kahhengyeong7947]

Interesting insights but in Asia's context, I definitely don't think those in senior positions have such advanced knowledge. It's more like the lower ranked positions who need or have them. In short, these bosses just need to know who have the skills :)

[@GeertDelmulle]

I second this opinion. Hear, hear! :-)

[@LeilaGharani]

😁

[@wazmink2459]

You also conduct courses in excel? Is it online? How much is the pay? Just making query

[@LeilaGharani]

Yes, you can check them out here: www.xelplus.com/courses/

[@wazmink2459]

@@LeilaGharani ok I will by tomorrow

[@wazmink2459]

@@LeilaGharani Actually, I'm very much interested to learn MS Word, Excel, PowerPoint

[@mccoydiego5444]

...but, doesn't xlookup replace vlookup and, index and match?

[@LeilaGharani]

Yes, but many companies are not on Office 365 yet.

[@hussainmeghani4809]

Is there any solution to vlookup from multiple value cell. Like A1 =25, A2=7|25, A3=0, A5=0|7|25..desired result B1, B2, B5 should be mark as positive match...pls guide

[@hussainmeghani4809]

@Pinned by Leila Gharani cannot get you..

[@noelkhamala277]

Number 1😁😁😁

[@StevenLee-xj6gx]

2:24 my answer will be... I subscribed to Leila Gharani YT channel 😂

[@wmfexcel]

I would ask a silly straight question... how many rows we have on a worksheet. If the interviewee can answer it correctly, (or even can tell the answer for Excel 2007 or before), I can tell, he/she is an Excel nerd already. XD

[@ermiasdamte16]

HI SWEEY YOU ARE SO NAIC LECTURER AM ERMIAS ANDL WHAN GOOD USER WITH EXCEL BUT AM BIGNE CAN YOU HEALP ME PLECE IM SO FOR MY ENGLIS I HOP YOU ANDERTUND ME THANK YOU

[@deeppatel2264]

0:43 kr$ maloom hai na?

[@mcmn]

Meh I needed this four months ago

[@polucovekpolukomarac]

Hm... interesting... I am working in the field of data analysis and to my embarrassment, i never obtained any excel skills. I am pretty experienced in getting the data from excel using vbs or python or R and then build the charts in powerbi or grafana or tableau or SSRS or even build a web application to present it but i would have hard time doing it in excel... I assume you are from USA, is it common there the employer to expect the candidate to be proficient in excel? I work mostly in Europe and Russia and i don't believe that many data analysts are that proficient here...

[@de_da_oo]

python, r or tableau are far more complicated/complex than excel. I assume you are far from entry level if you know the three tools mentioned above. Or at least I hope you are. Surprised you didn't mention SQL though, which is the bread and butter of analysis, and rightfully so.

[@polucovekpolukomarac]

@@de_da_oo oh... i like to believe I'm pretty experienced. I am working in this area for 9 years. Of course, It is for others to judge my skills, but i use those tools for work for quite some time. And i also use some other tools like Matlab and even i build software for data acquisition so i also use lower level programming languages like Micro C, step 7, etc... they are used for PLCs and controllers to det the data from various sensors. And of course we use sql here. That is pretty common here. And i think for anyone that works in that area SQL is something they need to be pretty good at and i felt like there's no need to mention it. Sorry.

[@defeatedgamerz3838]

Good 🌹🌷🌻🌺💐

[@Galileo2pi]

We're on the same page, Leila.

[@sabusinha9694]

Good information

[@thedon8210]

You Rock!!! Thanks !!!!

[@LIMODWS]

Est-ce que pouvez parler en français?

[@cdyard1]

Excellente occasion pour apprendre l'anglais, ne croyez-vous pas? ;-)

[@pramodparnami6012]

𝙱𝚎𝚜𝚝 𝚛𝚎𝚐𝚊𝚛𝚍𝚜 𝚏𝚛𝚘𝚖 𝙳𝚎𝚕𝚑𝚒, 𝙸𝚗𝚍𝚒𝚊

[@ChrisLee-yr7tz]

In my experience most people rate themselves as advanced excel users....but they're usually way way off anything like that.

[@TimeFadesMemoryLasts]

"advanced excel user" in a CV often just means "I have used Excel before"

[@foxbox7929]

I once made the font italicized. Felt pretty advanced.

[@LeilaGharani]

😂

[@markissleepy]

No kidding. I took some test on LinkedIn and it said I was in the top 5% of 12 million people who took the assessment, but the whole time I was taking it I kept thinking "Who doesn't know this that actually uses Excel?" Apparently a lot of people.

[@andrewmoss6449]

Very true. But there are so many nuances that most people aren’t aware of. Try asking things like: how do you ignore hidden rows in calculations?

[@bahadrtaspinar4575]

pivot tables are just overrated

[@foxbox7929]

Everybody knows excel. However, few KNOW excel.

[@NishadJ-os2jc]

b ad video , quite useless

[@Sunnyoznorth]

Leila r u single r u not married r u available

[@ChrisLee-yr7tz]

Seriously Gerry..

[@mcd22630]

I found the types of questions asked a little surprising. The focus seemed to revolve around specific attributes and features of Excel. I would have thought for at least some of the senior level positions the focus would have been more towards the conceptual level of data analysis. The most frightening interview regarding Excel would go something like this, "Hello, I am Leila Gharani and I will be conducting this interview."