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

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

Рет қаралды 75,485

2 жыл бұрын

You have an Excel test from your Interview? Great! You are in the right place! Learn about all the things you should prepare before an Excel interview test. In this video, we go through a practical example of an Excel Test step by step and explaining how to best complete your test. Ace your test by knowing to solve these excel interview questions.
Data Analytics Course Link:
ipidata.teachable.com/
GitHub Files:
github.com/Pitsillides91/Exce...
Overview:
- How to make excel tables look more professional in an interview test
- How to create column and row totals interview test
- How to create aggregated functions in Excel - SUM, Average, Min, max - interview questions
- How to conditionally format Excel Tables in Excel interview tests
- How to sort the data in Excel
- Create a new column that has “above average” or “below average” text depending on the Total value
- Join the Distributor from part 2. This new column should be second (next to movie)
- Create a pivot table showing the sum and average values for distributors
- Create a horizontal bar chart showing the totals by Movie
- Create a vertical bar chart showing the average value by Genre
- Create a pie chart showing the average value by Distributor
Yiannis Pitsillides on Social Media:
/ pitsillides91
ypexists?h...
www.pinterest.co.uk/pitsillid...
/ 1500092413449073
Tags:
Excel Test for job interview

Пікірлер: 31

@mk32776 Жыл бұрын

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

@kindrathomas9203 Жыл бұрын

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

@AnthonyBoettcher24 Жыл бұрын

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

@gloryths Жыл бұрын

Such a nice utube channel. Well done Yannis.

@amenaislam4573 Жыл бұрын

Thanks for the video! amazing work!

@Dxgreen 2 жыл бұрын

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

@Data360YP 2 жыл бұрын

Early next week it will be out!

@rolandnwatarali9716 2 жыл бұрын

Great Insights.. Awesome Job Yannis!!!!

@Data360YP 2 жыл бұрын

Glad you liked it!

@cococnk388 9 ай бұрын

Great video thanks

@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

@juliorosales1546 2 жыл бұрын

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!

@Data360YP 2 жыл бұрын

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

@marianaparraga7291 Жыл бұрын

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

@Data360YP 2 жыл бұрын

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

@thomaspiskorski7324 Жыл бұрын

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

@erci7962 2 жыл бұрын

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

@Data360YP 2 жыл бұрын

I have a few videos coming up on SQL and python

@AsianStvex 4 ай бұрын

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

@user-ng1ys6pz4h Жыл бұрын

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

@Data_Dr16 2 жыл бұрын

You're amazing

@Data_Dr16 2 жыл бұрын

Let's have more of this

@imosampson5635 5 ай бұрын

waoo , this is interesting

@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 8 ай бұрын

THIS WORKED FOR ME

@bobone6554 3 ай бұрын

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

@ericcaron5654 Жыл бұрын

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

@Steven-cq7yq 6 ай бұрын

ah man this is what they already taught me in college

@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 4 ай бұрын

Incorrect. All should be divided by 590476