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!
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
Question---what would you consider "basic" excel functions to be and what makes up "intermediate" and advanced functions? Thanks for your excellent video!
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.
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.🙏🏿
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?
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,\.
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.
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
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
I believe this is the only video you need to watch for excel interviews. Thanks for sharing!
If we become certified but have little to no experience how can we land a job in the first place???
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 really going to help alot . Thnk you very much .Please make same video about SQL.
this video is so good and practical. it should have much more views.
I don't have a clue what you're talking about, but I could listen to you for hours!
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
Question---what would you consider "basic" excel functions to be and what makes up "intermediate" and advanced functions? Thanks for your excellent video!
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.
Thank Jen for sharing your knowledge
This is a great video, Jen. Thanks a lot 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!
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.🙏🏿
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
This is very instrumental, thank you Jen
Great content Jen, really helped me a lot thank you!
You have gorgeous channel.. thanks for your efforts
Thank you for this jen , definitely subscribed !!!!!
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.
very useful. thanks for sharing!
Thank you, I like this video very informative
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,\.
Thank you so much for this.
Luv it, Jen
🎉thanks
wow great video excel is so spreadout.
Thank you
Love from my heart
Awesome video
Subscribed!
good video
What company even asks Excel interview questions. Crazy. Just something one can pick up and/or Google.
You are good sis
When you have pivot tables and you know how to use them, you hardly ever use ifs, lol
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.
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
Do you even VBA bruh?
Ohhh my shooooo cute girl!!!!...can i baby sit you!! :)....so adorrrrable!...boscow the cat! :)
I love Jen