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/Excel-Tutorials-/tree/main/Excel%20Test%202022 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: https://twitter.com/pitsillides91 https://www.instagram.com/ypexists/?hl=en https://www.pinterest.co.uk/pitsillides91/boards/ https://www.facebook.com/groups/1500092413449073/ Tags: Excel Test for job interview EXCEL: Excel top 5 Interview Questions: https://youtu.be/lp0NwAIcw_c?si=32mHS-_e7U4eYKc2 Excel top 7 Most Used Formulas: https://youtu.be/VvgQjxsHnMQ?si=2EOabWWRNnCpzBT8 Excel Interview Test – Junior: https://youtu.be/p6I3xXYmn2s?si=4k3U5xlPXFwPtXG2 Excel Interview Test – Intermediate: https://youtu.be/ZrWrxF2doRc?si=r5DtQa7dbrHbEJ9v Excel Interview Test – Difficult: https://youtu.be/QGQCW6s_r7A?si=ZLVka_wEBSq6HYFP Excel Interview Test – Average Part 1: https://youtu.be/FEyV96xE0fU?si=tVobgo9Oh9kCBir_ Excel Interview Test – Average Part 2: https://youtu.be/eCN5PuQBMqk?si=cHMgh0zvugLBPGk6 SQL: SQL Tutorial from scratch part 1: https://youtu.be/Xr2xg_u-wzo?si=od0FCH3u0VeY4QC3 SQL Tutorial from scratch part 2: https://youtu.be/bEeHNeED8zg?si=zhJgRA5qMx7QMZmY SQL Tutorial JOINs: https://youtu.be/V4aMAU9VLNo?si=Jd_yWYOijcAzlf9f SQL Top 5 Interview Questions: https://youtu.be/FTamRSw-sFM?si=C4ob1-Ne_Z5sVzV9 SQL Interview Test – Beginner: https://youtu.be/b4Fx5DfrN14?si=ze6IhkC5-qM1mKhk SQL Interview Test – Junior: https://youtu.be/AcNh0cWGYeM?si=orYDlZpodJ2rokAW SQL Interview Test – Intermediate: https://youtu.be/OjQjHd9CT3o?si=7RkBtWkX8qXKc4Qh SQL Interview Test – Difficult: https://youtu.be/edDrSXdRtmE?si=4mUd1EppJT6MNDpK PYTHON: Python Tutorial from Scratch Part 1 – https://youtu.be/nZyKxP04co4?si=zNzr4qyW_CUGQZFO Python Tutorial from Scratch Part 2 - https://youtu.be/JjFifnK3bVg?si=K34fpCUTH2UiDMpy Python Tutorial from Scratch Part 3 JOINS - https://youtu.be/tMv74JmjZ_Y?si=-14Y9Z3X14rlfGWj Python Tutorial from Scratch Part 4 Visuals - https://youtu.be/SQfEeFNAvdE?si=ifkieyVkylFey-PU Python Tutorial from Scratch Part 5 Visuals - https://youtu.be/CsqCLaLMGn4?si=hXOlixcYk0qBLgnE Python top 5 Interview Questions: https://youtu.be/rI0L8qxydZ0 Python Interview Test – Beginner: https://youtu.be/idANfk_F3NY Python Interview Test – Junior: https://youtu.be/xxrn8Uf_7ZA Python Interview Test – Intermediate: https://youtu.be/e02W-jsMaKU Python Interview Test – Difficult: https://youtu.be/e02W-jsMaKU