Excel Test for Job Interview 2021

My Name is Gašper Kamenšek. I'm a Microsoft MVP for Excel and this is my version of the Excel skills test for a job interview. All in all, it's five questions... Well, they are not so much questions as "Open up Excel and do this", or "here is the data now tell me this"... It's important to note that none of the questions are "There is just one correct answer" questions. In this video, I'm going to present the questions to you. I'm going to tell you why those questions are essential and give you an understanding of what each question is designed to accomplish. And on top of that, this video will also provide ideas of build-up questions if someone hits a home run in the first attempt. This video was recorded using Excel 365, and you can follow along its entirety only by using the Office 365 version of Excel. Chapters: 0:00 Introduction to the video 00:32 Excel Olympics Animation 00:39 Understanding the Tests Structure 1:46 Task 1 - Enters Today's Date in A3:A100000 11:06 Task 2 - Find Errors, Text and Convert Text To numbers 17:35 Task 3 - Sum Of Top 10 Values From a Range 23:43 Task 4 - Join Four Txt Files 33:49 Task 5 - Keeping Up With Microsoft Additional Material for Task 1: https://youtu.be/Gm-dOxuYk64 Gear Used: US Links Camera: Canon EOS R6 - https://amzn.to/3e9zxML Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK Lights: Elgato Key Light - https://amzn.to/3rurte7 EU Links Camera: Canon EOS R6 - https://amzn.to/3tubwGy Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0 Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP Laptop: Dell XPS 15 - https://amzn.to/3effMmT Lights: Elgato Key Light - https://amzn.to/3vcs6v9 Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y Recorded With: Camtasia - https://www.techsmith.com/video-editor.html Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission with NO additional charge to you! Thank you for your support! #Excel #ExcelOlympics #gasperkamensek