Top 5 Excel Interview Questions
Vložit
- čas přidán 28. 06. 2024
- 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: / the-career-force
Facebook: / thecareerforce
Instagram: / thecareerforce
• Top 5 Excel Interview ... - Jak na to + styl
What other questions have you been asked about Excel in an interview?
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
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!
this video is so good and practical. it should have much more views.
This is a great video, Jen. Thanks a lot for sharing your knowledge.
This video is really going to help alot . Thnk you very much .Please make same video about SQL.
I don't have a clue what you're talking about, but I could listen to you for hours!
Great content Jen, really helped me a lot thank you!
If we become certified but have little to no experience how can we land a job in the first place???
This is very instrumental, thank you Jen
Thank you for this jen , definitely subscribed !!!!!
Thank you so much for this.
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.
very useful. thanks for sharing!
Question---what would you consider "basic" excel functions to be and what makes up "intermediate" and advanced functions? Thanks for your excellent video!
Thank Jen for sharing your knowledge
Thank you so much!! I have my 2nd market planning analyst interview Tuesday and this will most likely be very helpful to me!!
I hope you got it!
Thank you, I like this video very informative
Love from my heart
Luv it, Jen
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
Subscribed!
You have gorgeous channel.. thanks for your efforts
wow great video excel is so spreadout.
Awesome video
Thank you
I really like it. I have job interview today. Hopefully this video helps me.
How did it go? If you don’t mind me asking.
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
🎉thanks
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.🙏🏿
I love Jen
good video
You are good sis
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,\.
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?
you must be a millionaire by now lol
Data analysis
What company even asks Excel interview questions. Crazy. Just something one can pick up and/or Google.
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
When you have pivot tables and you know how to use them, you hardly ever use ifs, lol
Do you even VBA bruh?
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.
Ohhh my shooooo cute girl!!!!...can i baby sit you!! :)....so adorrrrable!...boscow the cat! :)