Рет қаралды 61,718
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.teachable.com/
GitHub Files:
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
- 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
ypexists?h...
www.pinterest.co.uk/pitsillid...
/ 1500092413449073