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

Подписаться 2,6 млн

Просмотров 119 тыс.

50% 1

Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Looking for Excel interview tips? What you should know and say at your job interview? In this video, I summarize the MOST COMMON Excel questions that are currently asked during interviews. This covers positions such as business or MIS analyst, Data Analyst, Financial Analyst or more senior positions such as HR manager, Finance Manager or Team Lead. You'll be surprised at the level of Excel that's currently required for some of these positions. It's safe to say that advanced Excel skills are now required.
★★★ My Online Excel Courses ► www.xelplus.com/courses/
00:00 Most Common Excel Interview Questions
04:22 Top Excel Questions for Business Analyst
04:52 Top Excel Questions for Data Analyst
05:46 Top Excel Questions for Financial Analyst
06:09 Top Excel Questions for Senior Positions
07:13 Resources to Practice for Interview
07:39 Wrap Up
LINKS to related Excel videos:
► Pivot Tables Basics: • Excel Pivot Table EXPL...
► Pivot Tables Advanced: • Advanced Pivot Table T...
► VLOOKUP Explained: • VLOOKUP EXPLAINED - 2 ...
► SUMIFS, COUNTIFS: • How to Use SUMIFS, COU...
► Nested IF: • Excel IF Formula: Simp...
► Charts Basics: • Excel Charts & Graphs:...
► Conditional Formatting: • Excel Conditional Form...
► AGGREGATE Function: • Excel for Accounting -...
► Power Query: • How Power Query Will C...
► Filter Basics: • Excel Filter Basics (f...
► Index Match Basics: • How to use Excel Index...
► SUMPRODUCT Function: • How to Use SUMPRODUCT ...
► New 365 Functions: • 5 Excel Functions EVER...
Read the full article about Excel interview questions: www.xelplus.com/excel-job-int...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #interviewtips #interviewquestions

Опубликовано:

29 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 162

@LeilaGharani 5 месяцев назад

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

@vijayarjunwadkar 3 года назад

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

@himanshuvajani4477 3 года назад

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

@GpD79 3 года назад

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

@LeilaGharani 3 года назад

There's always more to learn :)

@MrAloha 3 года назад

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

@StanEby1 3 года назад

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.

@67duiker 3 года назад

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 3 года назад

She is the best teacher in RU-vid Channel.

@0707ravi 11 месяцев назад

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

@ahamadaibrahimben8596 3 года назад

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

@marioayala2510 3 года назад

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!

@user-ps3pc6jc8g 9 месяцев назад

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

@LeilaGharani 9 месяцев назад

Glad you think so!

@MillersLanguageSchool 3 года назад

Thank you for your knowledge!

@actocalmness4918 3 года назад

Thank you for all the helpful information.

@teforapapadi6280 3 года назад

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

@angelrodriguez7237 3 года назад

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 3 года назад

My pleasure, Angel 😊

@yugalgarg 2 года назад

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.

@SeanGHOB 3 года назад

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 RU-vid 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 3 года назад

Knowing where to look is always a good start 😁

@foxbox7929 3 года назад

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

@dnorm 3 года назад

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

@ambhat3953 2 года назад

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.

@FarhanMerchant 3 года назад

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

@LeilaGharani 3 года назад

You're very welcome :)

@maryqc8418 3 месяца назад

Helpful video. Thank you.

@Christy-fn7cg 2 месяца назад

She is great, very clear!

@bharatkotwani9311 3 года назад

Best instructor, I have ever seen 😇

@rp5339 3 года назад

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

@LeilaGharani 3 года назад

My pleasure!

@chh8860 3 года назад

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.

@SyedMuzammilMahasanShahi 3 года назад

Thank you for the share.

@kossiviaglee2997 3 года назад

Good to know, thanks!

@danicasrsen4935 3 года назад

Thank you so much!!

@wayneedmondson1065 3 года назад

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 3 года назад

Yes! Thank you!

@dilipinamdarpatil6301 3 года назад

Thanks for sharing your knowledge 🙏🏼

@LeilaGharani 3 года назад

My pleasure!

@emmafeng55 3 года назад

thank you so much!

@vamsiputthuru5836 3 года назад

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 3 года назад

Wow, thank you!

@tedgrove9412 3 года назад

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 3 года назад

Welcome aboard!

@turntalkpodcast4324 3 года назад

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

@apamwamba 3 года назад

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.

@ranaganguli2892 3 года назад

Really superb...

@MohitKumar-ec4en 3 года назад

Thanks Mam, Waiting for next video on same topic.

@everything5568 3 года назад

very very informative video

@brightafghans2886 9 месяцев назад

Thank you Leila

@tifouraamina1761 3 года назад

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

@LeilaGharani 3 года назад

You're welcome 😊

@upendrasharma4257 3 года назад

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 3 года назад

Wow, thanks!

@lawrencekazibwe9751 2 года назад

Thanks alot Leila, it's very informative

@LeilaGharani 2 года назад

My pleasure, Lawrence.

@SeamusHarper1234 2 года назад

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!

@englishmeg 2 года назад

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 2 года назад

Glad the content is useful for you, Meg!

@ai_dividend_daily_1 3 года назад

Great Infos...thx

@markissleepy 3 года назад

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 3 года назад

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 !

@ScottLititz 3 года назад

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 3 года назад

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

@Tina-gp4rg 3 года назад

I can't thank you enough.

@StephenBoothUK 2 года назад

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.

@HHH-nv9xb 3 года назад

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 2 года назад

Same here

@ICOD73 3 года назад

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.

@siddiqi111 3 года назад

Laila o Laila. Your videos are awesome with good training

@brahmmamb24 3 года назад

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

@LeilaGharani 3 года назад

So nice of you!

@vineethalekshmy5359 2 месяца назад

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

@HRH_Queen_JoJo 3 года назад

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

@georgeaboh 2 года назад

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

@noelkhamala277 3 года назад

Number 1😁😁😁

@vanmij4926 3 года назад

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

@ATInstitute 3 года назад

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

@jasonipfatsiong2062 3 года назад

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 3 года назад

Haha, that would be too easy 😂

@sundertalreja7208 3 года назад

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

@micha4186 3 года назад

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

@lkumar2727 3 года назад

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.

@sachinrv1 2 года назад

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 :)

@GDMonty1029 3 года назад

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 3 года назад

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

@s3icc0 3 года назад

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

@syedabbasalim4675 3 года назад

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

@domnicking3965 2 года назад

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

@bheemarajukrishna8272 2 года назад

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

@cellchow2339 3 года назад

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

@jeffc5218 3 года назад

Thanks for the share Leila! Definitely useful! 💯

@iamcurios 3 года назад

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

@lopher70 3 года назад

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

@SeamusHarper1234 2 года назад

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

@deepaksahu-nf1vb 3 года назад

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

@carlingas666 3 года назад

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 :(

@s3icc0 3 года назад

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 3 года назад

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.

@captainmartine Год назад

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😊

@byronstutorialspage2134 3 года назад

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

@naveedazam1445 3 года назад

Me too...

@apamwamba 2 года назад

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

@ambhat3953 2 года назад

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.

@defeatedgamerz3838 3 года назад

Good 🌹🌷🌻🌺💐

@MJBrown901 2 года назад

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

@LeilaGharani 2 года назад

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

@MJBrown901 2 года назад

@@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.

@chandannasta 3 года назад

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

@Galileo2pi 3 года назад

We're on the same page, Leila.

@mcmn 3 года назад

Meh I needed this four months ago

@wmfexcel 2 года назад

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

@hussainmeghani4809 3 года назад

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 3 года назад

@Pinned by Leila Gharani cannot get you..

@mccoydiego5444 3 года назад

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

@LeilaGharani 3 года назад

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

@StevenLee-xj6gx 3 года назад

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

@wazmink2459 3 года назад

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

@LeilaGharani 3 года назад

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

@wazmink2459 3 года назад

@@LeilaGharani ok I will by tomorrow

@wazmink2459 3 года назад

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

@user-xq3bv9ko2x 4 месяца назад

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 2 года назад

0:43 kr$ maloom hai na?

@kahhengyeong7947 3 года назад

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 3 года назад

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

@LeilaGharani 3 года назад

😁

@polucovekpolukomarac 3 года назад

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 3 года назад

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 3 года назад

@@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.

@LIMODWS 3 года назад

Est-ce que pouvez parler en français?

@cdyard1 3 года назад

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

@pramodparnami6012 3 года назад

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

@thedon8210 3 года назад

You Rock!!! Thanks !!!!

@foxbox7929 3 года назад

Everybody knows excel. However, few KNOW excel.

@ChrisLee-yr7tz 3 года назад

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

@TimeFadesMemoryLasts 3 года назад

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

@foxbox7929 3 года назад

I once made the font italicized. Felt pretty advanced.

@LeilaGharani 3 года назад

😂

@markissleepy 3 года назад

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 3 года назад

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?

@sabusinha9694 3 года назад

Good information

@bahadrtaspinar4575 3 года назад

pivot tables are just overrated

@Sunnyoznorth 3 года назад

Leila r u single r u not married r u available

@ChrisLee-yr7tz 3 года назад

Seriously Gerry..

@NishadJ-os2jc 15 дней назад

b ad video , quite useless

@mcd22630 3 года назад

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."

@andrewmoss6449 3 года назад

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 3 года назад

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 3 года назад

Good point!