Excel Test for Job Interview - 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:
ipidata.teachab...
GitHub Files:
github.com/Pit...
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:
/ pitsillides91
www.instagram....
www.pinterest....
/ 1500092413449073
EXCEL:
Excel top 5 Interview Questions: • Top 5 Excel Interview...
Excel top 7 Most Used Formulas: • Top 7 Most-Used Excel ...
Excel Interview Test - Junior: • Excel Test for Job Int...
Excel Interview Test - Intermediate: • Data Analyst Excel Tes...
Excel Interview Test - Difficult: • EXCEL Interview Test Q...
Excel Interview Test - Average Part 1: • Data Analyst EXCEL Int...
Excel Interview Test - Average Part 2: • Excel Test for Job Int...
SQL:
SQL Tutorial from scratch part 1: • SQL Tutorial for Data ...
SQL Tutorial from scratch part 2: • How to Learn SQL as a ...
SQL Tutorial JOINs: • SQL JOINS with Example...
SQL Top 5 Interview Questions: • Top 5 SQL Interview Qu...
SQL Interview Test - Beginner: • Data Analyst SQL Test ...
SQL Interview Test - Junior: • Easy SQL Test example ...
SQL Interview Test - Intermediate: • SQL Test for Data Anal...
SQL Interview Test - Difficult: • SQL Test Example for I...
PYTHON:
Python Tutorial from Scratch Part 1 - • How to learn Python? -...
Python Tutorial from Scratch Part 2 - • Complete PYTHON Tutori...
Python Tutorial from Scratch Part 3 JOINS - • How to Merge DataFrame...
Python Tutorial from Scratch Part 4 Visuals - • How to create Data Vis...
Python Tutorial from Scratch Part 5 Visuals - • Complete Seaborn Tutor...
Python top 5 Interview Questions: • Python Interview Test ...
Python Interview Test - Beginner: • Python Interview Test ...
Python Interview Test - Junior: • Junior Data Analyst Py...
Python Interview Test - Intermediate: • Python Interview Test ...
Python Interview Test - Difficult: • Python Interview Test ...

[@YiannisPi]

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

[@gloriousgloria-i1e]

thank you for helping

[@donmelanie908]

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

[@Polina-ur2xi]

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

[@rahmahmohamed5058]

Excellent video thank you!

[@claremarie91]

This is so helpful! Thank you for sharing :)

[@farhiohanshi4230]

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

[@yadude101]

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

[@tomjohnas134]

Great! Been waiting for this!

[@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.

[@MendiMountainMan1969]

My friend, #8 was very close to a question on my excel test. I passed it because I applied that formula =vlookup. Thank you so much for the video!!

[@Oszysr]

Thank you for making these videos so easy to understand.

[@aboutface1012]

Thanks very much for this ❤

[@rhondamurray5362]

These were awesome explanation videos!

[@lawrence_799]

Thank you so much, As an international student with IELTS 6.5, I actually understood all of it, which was too clear.

[@timn.8667]

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

[@robertue1]

Thanks Yiannis. Really helpful content!

[@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 .

[@toeytoey9715]

Great videos! Thank youuuu! ✨🙏✨

[@abualbertsesay1034]

How to download this Excel test and practice exercise?

[@magda2193]

thank you!

[@gunasekaranm5775]

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

[@Ali-bk1hr]

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?

[@cihanevren3950]

Thank you for the content!

[@rogerdeoliveira6749]

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

[@soujanyakris7039]

Very helpful!

[@cristinaposner238]

Thank you for the video

[@marvelousrosales3940]

THANK YOU !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[@lfcblaze]

subscribed, super helpful

[@ErinBaker-o1d]

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

[@randoms_7208]

thank you

[@alilakhani7796]

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

[@ememalice7804]

There are 7. check data label and you will se all. just that some values are to small

[@Twinsforthewins14]

Where is part 1?

[@Hrchjfjd]

kzbin.info/www/bejne/fHbch2xsrapjnLc

[@funmilayofrancis7252]

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

[@MoodyMooMoo]

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

[@KelliCassarella-ek5km]

Part 1: kzbin.info/www/bejne/fHbch2xsrapjnLc

[@mansimshukurov36]

Hello Yiannis, for your help, full video two days ago, I had given a test from Excel for a job, and your videos I found instrumental. If possible, I would like to know your email address for sending you the tasks they provided me during the examination. Thanks

[@abualbertsesay1034]

I found yours videos very instrumental and really appreciate it. Would you kindly send to me via email.

[@gardenofhappiness5488]

thank you