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