Excel Test for Job Interview 2022 - Download this Test and practice your Excel Skills

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 (interview questions) step by step and explaining how to best complete your test.

Data Analytics Course Link:

GitHub Files:

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
- How to join data in Excel
- How to use VLOOKUPS
- How to use Pivot Tables in Excel
- How to create visuals in Excel
- How to pass an excel test

Yiannis Pitsillides on Social Media:

[YiannisPi]

Nest stop is an Excel Dashboard - The SQL - Then Python

[Polina-urxi]

Is "average of average" in the Pivot Table correct? Shouldn't it be "Average of Total"?🤔

[yadude]

Can you do more videos like this to give more examples of test questions on other topics? this was very good 👍 😊

[claremarie]

This is so helpful! Thank you for sharing :)

[Oszysr]

Thank you for making these videos so easy to understand.

[MacKaledy]

okay video, i do think you made mistake when trying to get the averages. it shouldnt be the average of the average but the average of the totals. also you need to adjust format in the charts to better show the variances between data entries but thats also due to the data being very broad. in general i do think the video(s) offered me something tho. thank you.

also i used xlookup as others have mentioned its more intuitive.

[rogerdeoliveira]

part 8, you could Xlookup. (A4, 'Part 2'!A:A, 'Part 2'!B:B)) and itll return the values correctly

[rhondamurray]

These were awesome explanation videos!

[abualbertsesay]

How to download this Excel test and practice exercise?

[funmilayofrancis]

Great content....However, Could you go a little slower next time?

[farhiohanshi]

My favourite channel ❤ I only watch and make a resource in ur vedios .thanks
Iam a beginner of data analyst plz am requesting to make more vediods in excel, spreedsheet, SQL And visualization

[donmelanie]

Thanks so much for your insightful videos. Your patience and step-by-step explanations is commendable❤

[Ali-bkhr]

On the assessment day centre i went to they gave me a random data set table paper and told me to tell them what insights i see from it. Is there any resource i can use from a website to practice those types of questions?

[gunasekaranm]

Does anyone know any sites or assessment platforms that has these Excel interactive tests for free?

[AlexMar-r]

thanks for the videos are you in the U.S ? i can do all this in Python but not in excel lol thanks for the videos they are helping me catch up .

[timn.]

Can I get this data to try it on my own using an excel worksheet?

[MoodyMooMoo]

15 minutes seems a bit fast for all those 😮‍💨

[ErinBaker-od]

Why didn't you include the totals for pivot table? Just wondering. Thanks

[alilakhani]

why did the last pie chart (step 12) only have 3 colors instead of 7 colors for all the different distributers?

[robertue]

Thanks Yiannis. Really helpful content!