Top 5 Excel Interview Questions

Рет қаралды 108,376

5 жыл бұрын

EXCEL INTERVIEW QUESTIONS // Interviewing for a data focused job or a job that requires excel skills? Expect to be asked more than “do you know how to use excel?”
I’ve interviewed many, many people for jobs that require Excel skills and it’s usually clear who knows how to use it and who has only used it as a data entry tool. We’re looking at the top 5 Microsoft Excel interview questions and answers.
These questions include:
What Excel functions do you find most useful?
Tell me about your experience with PIvot Tables.
What types of Excel charts do you like to use?
Watch the video for my other 2 top Excel interview questions.
#dataanalyst #excel
__________
📊 How to Become a Data Analyst: bit.ly/TCFDataAnalyst
✅ Build The Perfect Analytics Resume to land your next job: bit.ly/TCFPerfectResume
💯 Achieve your analytics career goals with personal career guidance from me:
bit.ly/TCFCoaching
__________
Find out the ideal analytics career for you:
🤔 Take the quiz here: bit.ly/TCFCareerQuiz
__________
CONNECT WITH ME:
Website: thecareerforce.com
Linked In: www.linkedin.com/company/the-career-force/
Facebook: TheCareerForce
Instagram: thecareerforce
kzfaq.info/get/bejne/ia2lidRz0rjWY4k.html

Пікірлер: 48

@TheCareerForce 5 жыл бұрын

What other questions have you been asked about Excel in an interview?

@serageibraheem2386 5 жыл бұрын

1- V look up and pivot table 2- Yes, I have used pivot on daily bases. Extarct claims info. 3- Bar chart and trends chart. 4- I am proud is taking raw unreadable data turn it into a great visual and trends that give idea on how we perform

@johnhillescobar 4 жыл бұрын

Jen. The last question you referred to (when Excel is a preferable choice) was amazing. I usually find myself using small data sets to test some of my filters in my scripts or produce super quick analytics. Sometimes writing a script could take more time. Love this video!

@tracyobi2608 4 жыл бұрын

This is a great video, Jen. Thanks a lot for sharing your knowledge.

@EX-Edex 4 жыл бұрын

this video is so good and practical. it should have much more views.

@williambunter3311 3 жыл бұрын

I don't have a clue what you're talking about, but I could listen to you for hours!

@mxolisibooi3706 4 жыл бұрын

This is very instrumental, thank you Jen

@HydeMyJekyll 2 жыл бұрын

I've been using a lot of index/match with nested offset and count functions as the upper and lower limits for a range to control the size of arrays based on number of input items.

@mayurrindhe2088 5 жыл бұрын

This video is really going to help alot . Thnk you very much .Please make same video about SQL.

@04Hammers 5 жыл бұрын

Great content Jen, really helped me a lot thank you!

@gradjames6699 4 жыл бұрын

Thank you so much for this.

@marie-georgesgeara1186 3 жыл бұрын

Thank you for this jen , definitely subscribed !!!!!

@priyankamangla942 4 жыл бұрын

very useful. thanks for sharing!

@victoryhawks2630 Жыл бұрын

If we become certified but have little to no experience how can we land a job in the first place???

@henryfaust5900 3 жыл бұрын

Love from my heart

@shawanabrown549 6 ай бұрын

Thank Jen for sharing your knowledge

@j.d.singer8517 Жыл бұрын

Question---what would you consider "basic" excel functions to be and what makes up "intermediate" and advanced functions? Thanks for your excellent video!

@melanienguyen3349 3 жыл бұрын

Luv it, Jen

@neetrab 3 жыл бұрын

Thank you so much!! I have my 2nd market planning analyst interview Tuesday and this will most likely be very helpful to me!!

@laurak5196 2 жыл бұрын

I hope you got it!

@garyallan69 3 жыл бұрын

What about the inclusion of VBA or Power Query?? I personally use a combination of these two along with advanced formula on a case by case basis. Creating a CRM, although extremely advanced is a tool that you can solely use excel for. There is no need to go outside

@simonjackson1986 2 жыл бұрын

Thank you, I like this video very informative

@arushijindalpruthi598 2 жыл бұрын

wow great video excel is so spreadout.

@diegososa5280 4 жыл бұрын

Subscribed!

@lindafl2528 2 жыл бұрын

Thank you

@adityaagrawal9531 3 жыл бұрын

Awesome video

@erikaruv22 Жыл бұрын

ive never had a job that requires use of excel and i have been trying to get a job in data entry for the past year with no luck, i just keep practicing with tutorials and some courses

@cococnk388 10 ай бұрын

🎉thanks

@thaerenglish84 Жыл бұрын

You have gorgeous channel.. thanks for your efforts

@AliBoyy1 3 жыл бұрын

I love Jen

@marziehsadr9467 4 жыл бұрын

I really like it. I have job interview today. Hopefully this video helps me.

@sarahmugo1076 3 жыл бұрын

How did it go? If you don’t mind me asking.

@caleb6590 3 жыл бұрын

Wow this really helped. I wish I would’ve watched this before my actuarial intern interview last week.🤦🏿‍♂️ I think I still did fine though so we’ll see.🙏🏿

@AtticusDenzil 2 жыл бұрын

good video

@berhanukebede5763 3 жыл бұрын

You are good sis

@santoshadhikari9933 2 жыл бұрын

Want to add more question? What problem did you have while using Excel as a analytics tool? My answer most of time would be quality of data. Such as: Null values, incorrect values and etc and to increase quality of data we use data cleansing,\.

@Meaty33 2 жыл бұрын

Wait people have jobs for just excel? I'm like an excel and google sheets master, and also have basic fundamentals in python. How do I get a job in this field?

@brandoncollins2193 2 жыл бұрын

you must be a millionaire by now lol

@Ejeomah Жыл бұрын

Data analysis

@messi9991 Жыл бұрын

What company even asks Excel interview questions. Crazy. Just something one can pick up and/or Google.

@Nah481 2 ай бұрын

When you have pivot tables and you know how to use them, you hardly ever use ifs, lol

@violent_bebop9687 4 жыл бұрын

I've literally spent so much time in school learning useless facts. It's time consuming expensive and useless. More practical in s 7 min youtube video lol

@kayceeDis Жыл бұрын

Why do companies want people with 5 years of experience? How can you get the experience if you don’t get hired because you don’t have the experience. Hurting managers are really tripping.