Рет қаралды 78,428
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.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
- 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
www.instagram....
www.pinterest....
/ 1500092413449073
Tags:
Excel Test for job interview