Data Analyst EXCEL Interview Test Example - Prepare for your EXCEL Test - 2022

[@mk32776]

Wow, that was the most informative 16minutes turorial I ever had for excel, thank you so much.

[@gloryths]

Such a nice utube channel. Well done Yannis.

[@juliorosales1546]

Great video. I feel like a few steps can be avoided if i you transformed your data as a table from the beginning. You won’t have to drag down the little black button or have the issues with the totals. Great video regardless!

[@YiannisPi]

Yes, I agree, but I wanted to show the steps Vs formatting the table str8 away. Thanks, glad you enjoyed it!

[@AnthonyBoettcher24]

Thank you! Great video. I think this is applicable for consultant and Finance Roles as well

[@marianaparraga7291]

Hi Could you please add the excel template that you are using in the video in order for us to practice.

[@kindrathomas9203]

Wow.. and to think, I went all of these years hating excel.. until now! lol Thank you!!! 😄

[@thomaspiskorski7324]

when sorting the sheet you had trouble with the moving totals row. why not just freeze it?

[@byahenijoga4490]

If you want that way Just click row 2 , highlight all the way down to row 18. ctrl+shift+L then sort cell J2 (Totals). It will filter lowest to highest vice versa , and it will stay the details in row 19

[@khatunakurdovanidze5957]

Thank you very much, can we before selecting cells for ordering, move the totals row one row below and then when expending Excel is not counting it? We can move the totals row up again at the end.

[@abigailabobarin2329]

THIS WORKED FOR ME

[@cococnk388]

Great video thanks

[@YiannisPi]

Hope this video helps you land a data analyst job!!

[@uchihaid4842]

Sir I'm a beginner,pls after excel what should I learn

[@rolandnwatarali9716]

Great Insights.. Awesome Job Yannis!!!!

[@YiannisPi]

Glad you liked it!

[@AsianStvex]

so the MoM only does January and December? is that good enough sample

[@amenaislam4573]

Thanks for the video! amazing work!

[@bobone6554]

Is the average of average calculation correct for the question, wasn’t the sum of average correct? Thanks

[@erci7962]

Hey Yiannis, I need exactly the same type of content for Data Analysis on SQL and Phyton. I would be so appreciated if you can. Amazing content btw! :)

[@YiannisPi]

I have a few videos coming up on SQL and python

[@Dxgreen]

Loved the video can't wait for the next one!

[@YiannisPi]

Early next week it will be out!

[@graceegbe9803]

please i need clerification, from the formula of MoM (Month over a Month -1) WHY PUTTING MINUS 1

[@ErinBaker-o1d]

This may seem stupid but can you look ahead and then sort ahead of inserting all the totals ?

[@imosampson5635]

waoo , this is interesting

[@Data_Dr16]

You're amazing

[@Data_Dr16]

Let's have more of this

[@M1_Enazay]

Thank you for sharing with us the type of excel test. However the question 4 is calculated differently , the growth or decrease between two period is calculated as next : (N - N-1)/N ► N = Now Period ► N-1 = Previous Period the first row then would be : (300861-590476)/300861 = -0.96 = -96% and you can also notice that the decrease amount is almost double so it can't be -49%

[@traiancostinel5192]

Incorrect. All should be divided by 590476

[@Steven-cq7yq]

ah man this is what they already taught me in college

[@ericcaron5654]

why don't you show the excel table object with all its features, you can achieve much more and learn different skills.

[@sujithm716]

Anyone from ACHARYA INSTITUTE 😂

[@petefrancisco3267]

Why do you need to study excel? There are TEMPLATES and ready made FUNCTIONS! Just insert the proper values. Dont waste your time..