Data Analyst EXCEL Interview Test Example - Prepare for your EXCEL Test - 2022
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:
http://ipidata.teachable.com/
GitHub Files:
https://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
https://www.instagram.com/ypexists/?h...
https://www.pinterest.co.uk/pitsillid...
/ 1500092413449073
Tags:
Excel Test for job interview
Смотрите видео Data Analyst EXCEL Interview Test Example - Prepare for your EXCEL Test - 2022 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Yiannis Pitsillides 24 Февраль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 81,660 раз и оно понравилось 1.8 тысяч людям.