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!

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

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.

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.

This is very instrumental, thank you Jen

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

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

Love from my heart

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

Thank you so much for this.

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

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

Thank Jen for sharing your knowledge

very useful. thanks for sharing!

Thank you

Luv it, Jen

🎉thanks

Thank you, I like this video very informative

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

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

wow great video excel is so spreadout.

Subscribed!

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!

Awesome video

You have gorgeous channel.. thanks for your efforts

I love Jen

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.

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

You are good sis

good video

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

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

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

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