Be prepared for your next interview. Sign up to our bestselling Excel Essentials course here 👉 www.xelplus.com/course/learn-excel-essentials/
@apamwamba
3 жыл бұрын
I have conducted quite a number of interviews for data managers. I dont usually test them on memorizing excel formulae and the nitty details because that stuff can easily be looked up. You need to be working with these functions everyday to have them imbedded in your memory. What i test them is 1.Tables (and related operations like filtering) , 2.Pivot tables and 2.charts. 4. [Optional].I then ask them if they have ever used Excel power tools (Power query, Power Pivot) to analyze big volumes of data. I usually provide a relative big dataset for them to demonstrate their skills levels of 1,2,3. If they can use their initiative and try out the optional 4, they they get hired. In addition to the above i also test them on basics of databases (Relational database design , SQL)
@jessicasteele7829
2 жыл бұрын
Having been interviewing the past week, I have found exactly this to be true. I am asked more regarding HOW I am using Excel in the real world. For example- "How do you use Pivot tables in your current position?" "Give an example of a way you have used Excel power tools." "Give an example in detail of how you analyzed data using Excel and what was your outcome?" I've only been asked one time what functions I use, and I froze up and flat out said a few and then stopped and said, "good grief I can't remember." (I got an offer lol).
@georgejetson9801
2 жыл бұрын
@@jessicasteele7829 Good points. My brain is meant to solve their business problems, not fill it with flashcard trivia of keyboard shortcuts and precise formulas for things.
@Aima952
5 ай бұрын
Interviewer: What shortcut do you use for N? Me: Give me a keyboard and I'll press it, but no idea which button it is... actually I think I edited that feature because I liked the old macro shortcut I used before they added feature N. No idea what I'm doing here, can I just load the data into a RStudio instead?
@LeilaGharani
5 жыл бұрын
Have you recently attended an Interview where Excel questions were asked? What were they? Please share below.
@MrKallemyran
5 жыл бұрын
Not as a test, but because I had Excel and basic VBA in my CV, I was asked what I used that skill for. I explained that I used small, almost embarrassing simple, macros and such to speed up and reduce error in monotone data entering and presentation. At least I got a few lifted eyebrows and smiles.. lets hope it was enough to tip the scale 🙃
@LeilaGharani
5 жыл бұрын
It's a good idea to show the problem and see the different approaches. Thanks for sharing @Up4Excel
@adeelqureshi9339
5 жыл бұрын
One of the one question frequently ask in interview regarding excel that is how you handle data almost 5 million rows in excel? Can you please share your experience about this question
@fordfactor
4 жыл бұрын
I had an Excel practical test where I was asked (a) perform linear interpolation and (b) build a product code text from components (i.e. concatenation).
@apamwamba
3 жыл бұрын
@@adeelqureshi9339 Power query + power pivot
@elenamalimenkova475
2 жыл бұрын
OMG!!! The first three questions is exactly what I was asked at Amazon interview (in the same order). I wish I watched this video prior to the interview, not after. Thanks a lot!
@OakleyTurvey
5 жыл бұрын
Great video once more. Now can you think of a few questions they SHOULD be asking but aren't? Basic user... Q1. Where do you look to see what is actually in a cell? Q2. What is the correct way to enter a date in Excel? Q3. What is the kbd shortcut to close a file, but keep Excel open? Q4. What comprises a 'Good' data set. Q5. How do you turn a Data Range into an Excel Table? More adv... Q6. How do you get to Power Query? Q7. What is the difference between a Pivot Table and Power Pivot? Suggested answers: A1. The formula bar will show this. What you see in a cell is either the answer to a formula, a referenced cell, or 'Formatted' data in the cell. (One of Mike's Golden Rules - formatting is a facade) A2. The same as your PCs regional settings. i.e. the same as you see in the lower right of your screen. If I use the German format in UK it is NOT recognised as a date by Excel but simply as text, denying me the ability to use any of the date features and functions inc. Timeline slicers. (This can be got around using 'Locale' data types when doing Power Query.) A3. Ctrl + W. This means you keep Excel open and only have to use your machine's resources to open each file, and not to re-open Excel each time. Sure it only saves a few seconds each time but 10 secs x 100 files in a day = more than quarter of an hour wasted each day. The important thing is that if an applicant knows this they will also know many more time-saving and productivity tips. A4. Nothing touching the data range that is not part of the data, Headers at the top and in bold, dates in correct format, totals not touching (they are a calculation done on the data - not a part of the data). Additionally to make lookups easier - Unique IDs in the left column if 'Lookup Data' and should contain a timestamp if 'Fact Data'. A5. Click anywhere inside and Ctrl+T. The next thing you do is immediately give it a sensible name. A6. DATA Ribbon - Get & Transform Data Group. A7. Pivot Tables summarise a single data set, Power Pivot does the same for multiple data sets using related fields in the various data sets. What do other people think SHOULD be asked?
@LeilaGharani
5 жыл бұрын
Well, I would hire you right away :) Great list. Thanks for your input!
@wayneedmondson1065
5 жыл бұрын
Hi Leila.. thanks for the 5 EXCEL interview questions. Even when you think you know the answer.. it is good to test and challenge yourself so you don't freeze in the headlights when someone asks you point blank. Your courses, videos, web site and blog posts are full of so much value. Anyone wanting to up their skills in EXCEL should have you at the top of their list. Thanks for all the knowledge, tips, techniques and inspiration that you share with the community. We are all better at what we do because of what you do. Thumbs up!
@LeilaGharani
5 жыл бұрын
That's so nice Wayne, thank you. I really appreciate the kind words. I'm always happy to see your comments.
@Mandelbrot567
5 жыл бұрын
I just had an interview two days ago, and vlookups and pivot tables did indeed come up.
@LeilaGharani
5 жыл бұрын
Hope the interview went well :)
@jax.8.10
3 жыл бұрын
1) VLOOKUP 2) F4 (Lock Feature) 3) PIVOT Table 4) Condition Formatting 5) IF Function
@learntoteach4244
Ай бұрын
Hi Leila, I have been trying to learn Excel formula and become advance, but i am confused from which formula should I start the basic and jump intermediate and advance, I would appreciate if you advise.
@excelisfun
5 жыл бұрын
Awesome 100% TRUE about the questions during an interview!!!
@LeilaGharani
5 жыл бұрын
Thanks teammate!
@sachinrv1
5 жыл бұрын
Wonderful and very useful video Leila; I had asked a candidate a question; "I am using TRANSPOSE function and after using I'm getting an VALUE error, so what is the possible mistake I'm making ?", he could not answer.
@LeilaGharani
5 жыл бұрын
I can imagine. You're a tough interviewer Sachin :)
@مقدادحديد
5 жыл бұрын
The Queen of Excel is always imaginative and Creative in your style
@LeilaGharani
5 жыл бұрын
I'm trying my best :)
@مقدادحديد
5 жыл бұрын
@@LeilaGharani real queen
@romeop2345
4 жыл бұрын
I use index , match, match usually as an alternative to xlookup, but do mix it up sometimes ... anyway really helpful your videos Leila.. keep it up.. the dynamic date filters video was one Highlight that particularly helped me at work
@LeilaGharani
4 жыл бұрын
I'm glad the video was helpful at work.
@bingxiao1008
Жыл бұрын
Hey Leila, may I know if this "excel essentials for the real world" course is updated with the latest new functions/features released recently in 2023?
@simdog635
5 жыл бұрын
Totally agree Leila, every company i have worked for in the last 20 years has been ruled by the VLOOKUP command and Pivot tables.
@LeilaGharani
5 жыл бұрын
Glad you can confirm it Steve.
@shabbirkanchwala-abwaab6263
5 жыл бұрын
Gr8 Thnx I usually watch ur Vdos from a different perspective. I recommended my HR team and staff to join the course. Simplicity is the Beauty of ur Vdo.
@LeilaGharani
5 жыл бұрын
That's great. Many thanks for your support!
@jayaxe79
5 жыл бұрын
The column issue with Vlookup can be overcome by "columns" function - VLOOKUP(ref,table_array,COLUMNS(A:D),0) ? This is a great video to test my basic understanding of Excel but sadly, never had chance to answer Excel questions even though I very much wanted to.
@Juxtavarious
5 жыл бұрын
So does that return the first instance in one cell or multiple cells to one or across multiple cells? That looks like I could REALLY use it for something if I understood that better.
@ricos1497
5 жыл бұрын
@@Juxtavarious No, it simply counts the number of columns in your dataset up until the item you want to return. For example, if your lookup value is in A1 and table is in B2:G100 and you want to return the value in column F (the fifth column) then you write: =VLOOKUP(A1,B2:G100,COLUMNS(B:F),FALSE) COLUMNS(B:F) in this instance returns the number 5 because it is just a count of the columns. Crucially, when you insert a column in your table - for example, between columns C and D - then, because you have used column references, the formula will automatically update to COLUMNS(B:G) and so will now return the 6th column as there are 6 columns between B and G (inclusive).
@jayaxe79
5 жыл бұрын
Yes Rico is right! Thanks for the good example. To understand better, need to try it out, insert more columns after that to visualize how it works.
@markjenkins464
2 жыл бұрын
Amazing video! Thanks!
@officetricks6303
2 жыл бұрын
Thanks a lot for your guidance!!
@clickclick8761
5 жыл бұрын
Leila, this video is very useful, short in time, rich in mind.
@LeilaGharani
5 жыл бұрын
I'm glad to hear that :)
@clickclick8761
5 жыл бұрын
@@LeilaGharani My pleasure : )
@lunt1969
5 жыл бұрын
i’ve just signed up for the course 😀
@LeilaGharani
5 жыл бұрын
Thank you for your support. I hope you will like it.
@NileshVoraN
5 жыл бұрын
Hello Madam Good morning, i know which Excle was batter Office 365, 2016 or 2019 i sow and learn in your video every Thursday i see video and i try to know more and learn
@malcolmbacchus421
5 жыл бұрын
It all depends what level of expertise you are looking for. If I get someone who says they are expert as Excel, I tend to ask questions about VBA, DAX measures and m formulae. That tends to sort out real experts from those who are merely proficient. If I was looking for a very good model builder I'd probably throw in a question about customising the ribbon using html or something like that. If I'm looking for someone who is only proficient at the basics however then the sort of questions posed in the video are about right.
@LeilaGharani
5 жыл бұрын
Good points Malcolm. Thanks for the feedback!
@hatimparkar8068
2 жыл бұрын
Thanks for sharing mam was very helpful.
@victorvonderkrausse5492
Жыл бұрын
Hi Madame, thank you very much for your videos are very useful, I just have an issue when I am choosing " sign and space after , excel is transforming into $ sign !!! ??? This issue is unwanted and annoying although I ve tried to eliminate it I couldn`t !!! If you can help me it you will save my life 😁, cheers from Manchester !!
@Hey_Delight
5 жыл бұрын
Hi Ms Leila, this is non-related question but ur response would very helpful. Can u recommend the best screen video recorder and editor for video tutorials like urs. Thanks so much.
@LeilaGharani
5 жыл бұрын
I use Camtasia. You can check out my gear here: www.xelplus.com/resources/#gear
@ckokse
5 жыл бұрын
Awesome! Exactly what I've been waiting for. Definitely going to check out this course!
@DK-ls1tx
5 жыл бұрын
Thanks a lot Leila 😃
@LeilaGharani
5 жыл бұрын
You're very welcome :)
@marcvslicinivscrassvs7536
5 жыл бұрын
Thanks your classes on Udemy and videos on KZitem, I can now answer these questions easily. Thanks your for effort and passion in teaching.
@wojciechm2428
3 жыл бұрын
Thanks for sharing!
@drew3030
Жыл бұрын
Index-Match can be used to pivot too. For instance, when your primary key in the reference table has multiple rows but you need to pivot from long format to wide in your main table. Index-Match in combination with AND and IF can confirm that the next row down matches the same PK as the previous row.
@peternganga9371
5 жыл бұрын
Thanks, Leila.
@moorkara
3 жыл бұрын
Very Useful stuff from Leila..
@DougHExcel
5 жыл бұрын
Great tips! Excel is such a useful tool
@LeilaGharani
5 жыл бұрын
It sure is Doug!
@hv3300
3 жыл бұрын
Great video. Would you call these questions good for advanced or intermediate Excel questions. If it is intermediate, what are the typical advanced level Excel interview questions?
@katerina6495
5 жыл бұрын
Vielen Dank Liebe Leila ,so practical and useful. Viele liebe Grüsse 🤗
@LeilaGharani
5 жыл бұрын
Danke liebe Katerina 😘
@golfdelta790
5 жыл бұрын
I am on the interview panel next week ... I do hope that they have seen this video
@LeilaGharani
5 жыл бұрын
Let's hope they do :)
@golfdelta790
5 жыл бұрын
@@LeilaGharani Oh no they didnt :-(
@neetrab
3 жыл бұрын
Wow! Thank you, lady!! 👍
@LeilaGharani
3 жыл бұрын
You are so welcome!
@monte4955
5 жыл бұрын
Great video Leila. Thanks for sharing.
@LeilaGharani
5 жыл бұрын
My pleasure.
@joyce7405
4 жыл бұрын
excellent tips ,thanks
@paulm8079
3 жыл бұрын
Thank You Leila, I have tried to learn Excel from other courses.With not very much good luck. But the way you explain everything is perfect. Thank You Again.
@aymanbadour7144
2 жыл бұрын
Hi Leila can you please advise what excel formulas i need to learn to work for retail merchandising , do you have any clips useful so i can watch it
@prakashs2576
5 жыл бұрын
Thankyou so much man for your great job
@LeilaGharani
5 жыл бұрын
My pleasure Prakash.
@athumanisimbeye475
5 жыл бұрын
Thanks Leila
@Sarika897
3 жыл бұрын
I wish we learned this stuff in school
@nohandlehandle274
5 жыл бұрын
I'm starting a new job tomorrow where I mentioned xlookup at the interview.
@LeilaGharani
5 жыл бұрын
Congratulations Michael! I wish you a good start.
@drillcream
4 жыл бұрын
What was their response? "X-what now?"
@nohandlehandle274
4 жыл бұрын
@@drillcream yes but in a more accounting like manner. I think they said oh I'll have to google that.
@Rey-sb6li
5 жыл бұрын
I've just enrolled and purchased this course! Excited! Thank you as always, Leila!
@LeilaGharani
5 жыл бұрын
Great! Thank you for your support. Looking forward to getting your feedback.
@teoxengineer
5 жыл бұрын
You are amazing!! You have changed my worls in excel. After that, I'm looking to excel not just calculator. It contains planning, managing, charting whatever you want I think it reflects a real World! Thanks for everything
@LeilaGharani
5 жыл бұрын
I'm very happy to hear that Emre. I hope you enjoy the course.
@erwinjansen2885
5 жыл бұрын
Have you got a video/lesson how to use a excell data filter in a html page / webpage to use as a Dropdown-Menü for my webpages?
@vinodpandey4927
5 жыл бұрын
Thank you for making video. But still i just to clarify 1 things if you will not used to any formaul on daily basic routine activity.after few days you will forget which formula will be work on which case. Thanks again👍
@robertakwasiadjei8223
5 жыл бұрын
You're indeed amazing. Keep up the good work Leila
@josephjoestar995
4 жыл бұрын
Finally some advanced level questions not the "how to make text bold" like in other videos lol
@roynaicker775
5 жыл бұрын
Leila you are great!!you have helped me so much I love index and match,,but now I want to learn Xlookup:)
@wmfexcel
5 жыл бұрын
Very well presented. :) One point needs to be caution though... XLOOKUP is super cool, no doublt. However if we are answering that in an interview, we have to be extremely careful before the interviewer may not have the knowledge of XLOOKUP. Before we show off our Excel skill, I'd suggest we ask the interviewer what Excel version the company is currently using, and response accordingly. 😉Make sense?
@LeilaGharani
5 жыл бұрын
Absolutely, good point!
@dhananjaykansal8097
5 жыл бұрын
Very helpful! Lovelyyyyyy
@developyourself7
3 жыл бұрын
This Is amazing thanks
@suresht3212
4 жыл бұрын
thank you
@ptichka1371
5 жыл бұрын
Thank you, Leila, for the new course on Udemy! Can we expect the next course to be on Power BI, please??
@LeilaGharani
5 жыл бұрын
No but currently Power Query is planned.
@ptichka1371
5 жыл бұрын
Leila Gharani Awesome! Will be waiting for the course to launch! 🤞🤞
@hosseinhosseinpoor4845
3 жыл бұрын
thanks...
@MrEms333
5 жыл бұрын
Excellent
@jdcarter157
2 жыл бұрын
thanks alot!
@infamousprince88
3 жыл бұрын
Hi, is this course still applicable to 2021?
@Deependra1991
5 жыл бұрын
I was asked in mis executive interview, pivot table and chart, index and match, pivot slicer, short cut keys of ctrl and shift etc...I cleared interview but i Not joined coz of salary issue. Now i am in account department in e-commerce company
@gautamdhar1368
5 жыл бұрын
Always learnt a lot from your videos. I have a query. I am using combobox ActiveX control. I have selected a range but the data in it are not hard-coded but derived by formula. Hence at times blank space are appearing at the end of the drop-down list.
@gautamdhar1368
5 жыл бұрын
Is there a way to make the appearing list dynamic without changing the formulated range selection
@mundonemesis
5 жыл бұрын
I have used Xlookup but I prefer Index-Match instead.
@LeilaGharani
5 жыл бұрын
Really? Why do you prefer it?
@nurmukhamedovnurislam6155
4 жыл бұрын
You're the best!
@michaelshultz5584
5 жыл бұрын
During an interview, I was given a test. I was given a model to clean up without using a mouse. I got through it, but must not have completed the task fast enough. Not a problem, I am know working for a much larger company.
@LeilaGharani
5 жыл бұрын
Strange test :) Glad it worked out for you.
@Juxtavarious
5 жыл бұрын
I get the concept, but that's still kind of dumb. I really hate hare-brained schemes recruiters and interviewers cook up because they think Edward Nigma is some kind of role model.
@jxggxr_dxv
5 жыл бұрын
Well, good that you got to work in a better place. That's kinda hilarious test. I remember first time I got to work with Excel, I didn't know much and I was learning on my own based on the job requirements. You come across stuff you haven't done before and automatically you gonna do your research and learn it on spot - my problem was that I had the logic but didn't know how to apply it, which i think it is the case for many people. Recruiters tend to forget that you do learn a lot by doing it, especially if you're new in the field. In 2 months I knew more than the others that were there way before me... it just matters how knowledge hungry you are. They should focus on the basics and things that are required for the job, not the damn "clean up stuff without mouse".
@Sailor.Catracha
Жыл бұрын
@@jxggxr_dxvhi! Just going for an in-take clerk position and they said they'll test my basuc excel skills. Which questions do you think I should prepare on besides the ones in this video?
@RizwanAli-bt7uo
3 жыл бұрын
Thank you so much Maam. It helped me ease my tension a little bit as I have an interview tomorrow. By the way, I belong to the city of Satya Nadella :}
@LeilaGharani
3 жыл бұрын
Best of luck!
@nonsoamamchukwu9598
5 жыл бұрын
This is amazing, Leila! Thank you.
@Meremannkibaat
5 жыл бұрын
Hey i like your videos and style of your videos content. Best of luck and keep the good work mam.👌👌
@LeilaGharani
5 жыл бұрын
I'm glad to hear that :)
@alexdickey9542
5 жыл бұрын
There is another vlookup/hlookup limitation. In vlookup et al both the lookup value and column/row lookup need to be in the lookup array. This forces the lookup value to be on the edge of the array and the result to only be found in one direction. Lookup, Index/match, sumproduct separate the two to allow more flexibility.
@LeilaGharani
5 жыл бұрын
Very true Alex. Thanks for your feedback.
@shakiraasfoor7599
4 жыл бұрын
جزاك الله خيرا
@macky2green
5 жыл бұрын
Employer: Asks the common Excel questions for job interviews slightly similar to those in this video. Applicant: Answers the questions exactly how Leila explained them. Employer: Wait, are you subscribed to *Leila Gharani's KZitem Channel?* Applicant: Yes, Sir. I am... With the notification bell icon to get notified of all new and upcoming videos. Employer: (Instantly stops the interview. Crumples and throws the Applicant's CV/resume in the trash bin... With an intimidating look on his face.) Applicant: (Nervous and shaking. Telling to self: "OMG, I didn't make it.".) *Employer: CONGRATULATIONS! YOU'RE HIRED. And let me tell you something, kid. This is top corporate secret. Highly classified. **_I'm also subscribed to Leila and watch all her videos._** Don't tell anyone.* #excel #msexcel #microsoftexcel
@LeilaGharani
5 жыл бұрын
Mark, thanks for the laugh to get my day started right 😂
@macky2green
5 жыл бұрын
@@LeilaGharani It's great to know that, Leila. My fingers just started typing (tapping) those. LOL! Seriously, we owe you a lot with what we learn from your Channel. Please keep the great content coming. Thank you so much.
@alexanderromeo5367
5 жыл бұрын
This comment is very cringeworthy
@ExcelSquad
5 жыл бұрын
Thanks mam . Considering my request
@kvin9210
3 жыл бұрын
Does anyone know about the question: "rate your excel skills out of 10?" Bombed this question like 3 times on 3 interviews. Anyone know the answer?
@natashak2125
5 жыл бұрын
Congrats on your new course. Of course I am signing up. Your videos have helped me so much.
@LeilaGharani
5 жыл бұрын
That's great Natasha. Looking forward to getting your feedback!
@thedavidseatonshow
5 жыл бұрын
Superlative job as always!
@roynaicker775
5 жыл бұрын
Leila I want to sign in for your course and ready to pay, however it ask me payment method but there is no drop down list?
@LeilaGharani
5 жыл бұрын
That's great Roy. You can pay with credit card or PayPal.
@Panthers8912
4 жыл бұрын
Vlookup match the way to go
@stevennye5075
4 жыл бұрын
well done
@SholaDsdg
5 жыл бұрын
very sweet and simple. Thanks Leila!
@samuelkodjoe1645
5 жыл бұрын
That was cool!!
@sarfarajkureshi6569
5 жыл бұрын
Nice video mam, really helpful for interview, love you.
@LeilaGharani
5 жыл бұрын
I'm glad to hear that :)
@mgithaiga3007
Жыл бұрын
TY
@martinizadifar3093
3 жыл бұрын
Thank you Leila , I starting now to learn accounting , I watched your video about accounting,, it was very good , can I ask a question,, where are you from originally?
@vamsikrishnakangala5535
5 жыл бұрын
Madam..could you please upload tutorials on MS Word?
@LeilaGharani
5 жыл бұрын
It's not planned yet but I'll add it to my list. Thanks for the feedback.
@TY-zl1vw
3 жыл бұрын
I only heard about XLOOK up amongst a few others, not first hand experiences, because I'm not using the 365 version. I use the prompt for each argument of many functions over the years, so I have not spent a lot of energy memorising the syntax . So it's advisable to remember the syntax by heart?
@kiwiesp
2 жыл бұрын
Really valuable information. Thank You.
@fordfactor
4 жыл бұрын
I train Excel, and in my view the range_lookup argument for VLOOKUP is not very well explained by the Insert Function or Intellisense features i.e. the term "approximate match" is misleading. I prefer to explain it as "Do you want to implement a range look-up method? Yes or no?" I then like to say WHY you'd use a range lookup i.e. if the value you are looking up is effectively continuous, such as an annual income for tax rates, where the income is broken up into bands or ranges.
@dkb1111
5 жыл бұрын
Thank you so much my great Teacher
@ryangolla
5 жыл бұрын
Thank you for this, will come in handy when I go to interviews. Love your channel! :)
@LeilaGharani
5 жыл бұрын
My pleasure Ryan. Glad you like it.
@mr.gardengreen7124
4 жыл бұрын
Hi Leila..how to sign up?
@ashutoshdwivedi9600
5 жыл бұрын
Hi, mam You have a good knowledge
@LeilaGharani
5 жыл бұрын
I'm glad to hear that :)
@andrewmoss6449
5 жыл бұрын
Very useful advice. Thanks, Leila!
@rahulcomputercentre2463
2 жыл бұрын
Love you maam
@tha2irtalib343
5 жыл бұрын
Thanks for shairing , excel lady. That's really helpful.
@LeilaGharani
5 жыл бұрын
My pleasure. Glad to hear it's useful.
@rifaatahsan1893
4 жыл бұрын
You are an amazing instructor! I have learned a lot of things from your videos.
@muhammadsiddiqueakbar7550
2 жыл бұрын
Awesome
@romeocostillas
5 жыл бұрын
Definitely one of the best! Thanks Leila for sharing
Пікірлер: 214