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:
Ctrl and Enter in Excel - YOU NEED TO...

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-edito...

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

• #education
• #excel_interview_questions
• #excel_test_for_job_interview
• #excel_interview_test
• #excel_interview
• #excel_test_questions_and_answers
• #excel_test_for_employment
• #microsoft_excel_interview_questions
• #excel_test_for_job_interview_2020
• #excel_test_for_job_interview_2021
• #excel_interview_questions_for_business_analyst
• #excel_interview_questions_and_answers_in_english
• #excel_assessment_test_for_job_application
• #interview_questions_to_ask_employer
• #ms_excel
• #excel_olympics
• #gaper_kamenek