Excel Test for Job Interview 2021

Рет қаралды 62,272

Күн бұрын

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 Exce...
Gear Used:
US Links
Camera: Canon EOS R6 - amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - amzn.to/3dgM8wS
Laptop: Dell XPS 15 - amzn.to/3w8CyoK
Lights: Elgato Key Light - amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - amzn.to/3amDRXP
Laptop: Dell XPS 15 - amzn.to/3effMmT
Lights: Elgato Key Light - amzn.to/3vcs6v9
Green Screen (visible in bloopers): amzn.to/3ajUm6Y
Recorded With: Camtasia - www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics KZfaq Channel: bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: 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

Пікірлер: 181

@pengupengu8 3 жыл бұрын

this is wild. i'm glad i found this because i'm gearing up to do a written test and an excel exercise in a few days. thank you so much for the work you put into the video and the tips!!

@ExcelOlympics 3 жыл бұрын

Nice to hear you found it useful and good luck on your test.

@37777steve 3 жыл бұрын

Excellent job, sir. I've never seen a video that put the knowledge process through such easy-to-follow steps.

@ExcelOlympics 3 жыл бұрын

Thank you for your kind words Steve. I will attribute this to 18+ years of running Excel courses 😀.

@dreamangel3487 3 жыл бұрын

"If you drag down to the row 10000 , the day is over , the test is over" ...hahaha ...That is what i did before I see this video...Thank you.

@ExcelOlympics 3 жыл бұрын

You are welcome Angel. Imagine how much time you will save from now on 😀.

@lolaadeoye3584 2 жыл бұрын

Same, I actually struggle with it before getting to the correct method. Very helpful

@laural7693 2 жыл бұрын

🤣🤣🤣

@bigcmacd Жыл бұрын

I was playing along and did a couple of them slightly differently. Q1 was such a great question, so simple but really had to think about it. I used CTRL + G to go to A100000, then CTRL+SHIFT+UP to fill the range back to A3. Didn't know you could select a range the way you did, that will prove very useful!. Q3 I used SUMIFS(range,range,">"&LARGE(range,11)). In power query I would have removed the blanks by filtering a column and would never have considered your method but it's a good tip to learn! Great video!

@ExcelOlympics Жыл бұрын

I love it that you actually took the test Calum. And it just goes to show, there are always multiple ways to solve something in Excel. But it's great to know more than one as their usefulness varies from case to case.

@tutsecret499 Жыл бұрын

I love your delightful videos. Thank you again.

@ExcelWithChris Жыл бұрын

Loved it! Thanks. Regards from South Africa. (learned something new - the index to get top empty rows and use that value in the next step to remove top rows in sample file).

@shruthianegundi3107 2 жыл бұрын

Thank you so much for this! This is mind-blowing!

@ExcelOlympics 2 жыл бұрын

Thanks Shruthi. That means a lot!

@appletreegfx806 2 жыл бұрын

You are amazing!! I've never seen these skills from any other excel teaching sites! I am glad I came across your teaching! Thanks

@ExcelOlympics 2 жыл бұрын

Thanks a lot!

@blink2008 Жыл бұрын

i just love how this guy talks and delivers his content. very useful content also a lot more in depth and complicated than other content creators.

@ExcelOlympics Жыл бұрын

Thanks blink2008. I find the depth does not play a role if you can explain things clearly. If you can make someone understand, you can then take them as deep as you'd like :)

@blink2008 Жыл бұрын

@@ExcelOlympics going to tatto that on my chest haha. please make more practical & complex (content) excel/power query videos

@utubeAgape 2 жыл бұрын

This is truly excellent teaching and SO helpful for the work I do every day in excel. Could you make more of these kind of videos - the examples are fantastic learning tools as they are immediately applicable! Many thanks to you👍

@ExcelOlympics 2 жыл бұрын

Thank you Irene. Means a lot! Was thinking about a more diversified series differentiated by the position one applies for. Could be coming in January 😀

@utubeAgape 2 жыл бұрын

@@ExcelOlympics That’s great news, can’t wait! (I love the question and answer format.)

@GrainneDuggan_Excel 2 жыл бұрын

So helpful to have this guide for the process to use when interviewing candidates - thanks

@ExcelOlympics 2 жыл бұрын

Great to use where it fits. This is a test for advanced Excel users. May it serve you well Grainne.

@andreacavallucci6044 2 жыл бұрын

Absolutely enjoyed your work! Super!

@ExcelOlympics 2 жыл бұрын

Thank you for those kind words Andrea. Glad to hear you enjoyed the video. I hope you picked up a few tricks along the way.

@tracywilliams61 Жыл бұрын

Brilliant you just solved so many of the things I’ve struggledd to solve. Thank you once again. If you still have the files I would love to follow your tutorial hands on. Tracy

@johnadair4979 3 жыл бұрын

Great tips.

@ExcelOlympics 3 жыл бұрын

Thanks John.

@radosvetjosifov1840 3 жыл бұрын

Your videos are amazing :)

@ExcelOlympics 3 жыл бұрын

Such a nice thing to hear Radosvet Josifov. Thanks for your kind words. Any Excel topics you would want to see covered on the channel?

@hankaklapczynska4954 2 жыл бұрын

This is excellent. I am preparing for a job interview myself and need to dust-off that long unused knowledge! Fingers crossed :)

@ExcelOlympics 2 жыл бұрын

Thanks Hanka and it goes without saying, all the best at the interview.

@murjoshua 2 жыл бұрын

Very informative and yet easy to follow! Kudos!

@ExcelOlympics 2 жыл бұрын

Thank you for the kind words Joshua.

@willieward7419 2 жыл бұрын

You are an excellent instructor; however, I am a word person and not so much a numbers person. I will watch this video again. Thank you.

@SendItLady 3 жыл бұрын

Thank you!!! Subscribed!

@ExcelOlympics 3 жыл бұрын

You are welcome. And thank you for the subscription.

@nestortelleria3861 2 жыл бұрын

Hey Gašper, big fan of yours. Keep it going. I'm glad to found this channel.

@ExcelOlympics 2 жыл бұрын

Great to hear that Nestor. I'll see you on the next one 😀

@nestortelleria3861 2 жыл бұрын

I just ran into your channel a couple of days ago and I’m in awe for how easy it seems, and not just for one way to do it, but multiple ways. Definitely mind blowing.

@ExcelOlympics 2 жыл бұрын

There are always multiple ways to do things in Excel, and sometimes which is best could be determined by the data you are using, so it's always great to know how to do something multiple ways. Thanks you for all the kind words Nestor. It's comments like yours that give creators like me a lot of "energy" to create so thank you again!

@nestortelleria3861 2 жыл бұрын

@@ExcelOlympics completely agree, regarding the best way is according the data you’re working for. I’m still a rookie when it comes to Excel but I hope with more practice I would be mastering, and of course, with videos like yours would help my journey. Thanks! Anytime, Gašper! I’m eager to watch more videos of you.

@johirulmridul2306 2 жыл бұрын

that's a good way in excle to recalculate . thanks, sir.

@ExcelOlympics 2 жыл бұрын

It's my pleasure Johirul. Glad to hear that you enjoyed the video.

@kebincui Жыл бұрын

Gasper, you are such an excellent Excel teacher. Thank you for sharing👍🌹

@ExcelOlympics Жыл бұрын

Thank you for those very kind words Kebin!

@michaeldempsey3471 8 ай бұрын

Thank you so much for this amazing tutorial. I learned so much from it it's remarkable! In 40min i upped my data skills 10 notches. It helped consolidate what i knew of arrays into an applicable real world scenario and the fact that you contrasted and compared the more "traditional" or antiquated ways to solve those problems in Excel with the latest and hippest was really useful. My only regret is that you didn't include a link to a test question file and more crucially to the 4 text files that were transformed in power query. I literally just discovered Power query and those text files would've been a great tool for practice. Anyway, fantastic job and i am now

@sanumpzha 2 жыл бұрын

Superb content, loved it.

@ExcelOlympics 2 жыл бұрын

Thank you for the kind words Sanoj.

@tomromancheck5355 Жыл бұрын

Great job. I continue to watch videos from several Excel MVP’s and am always amazed with the new features and techniques you come up with. One of my challenges is to have new applications to use these great features (i.e. Power Query, Unique, etc); After using a few of them, work becomes repetitive and it’s just updating the data with new data so I find it challenging to develop a need to use theses new great features unless I have a new assignment requiring me to think differently. Thanks for all your great research and easy to follow and use examples. Tom

@ExcelOlympics Жыл бұрын

Thanks for those kind words Tom. And I love how you keep challenging yourself. Keep rocking!

@TheMosinsheikh 3 жыл бұрын

Welcome sir and really helpful tips

@ExcelOlympics 3 жыл бұрын

Glad to hear you're finding the videos enlightening.

@josephking6913 3 жыл бұрын

Now This Is How You Share And Disseminate Information. A Big Thumbs Up To You Sir And Many Many Thanks. You Now Have One More Sub.

@ExcelOlympics 3 жыл бұрын

Thank you for those kind words Joseph.

@lynnw7618 5 ай бұрын

Thanks! You are on target!

@akmshp Жыл бұрын

Excellent

@realitycorner3365 Жыл бұрын

Evening what are the most Formulars or purchases

@temilolaonash5780 2 жыл бұрын

I am completely blown away. From start to finish I couldn't take my eyes off the screen! you are really an MVP ! could you please share the files with me. It will really help me practice and master these teachings. Thanks in advance!

@ExcelOlympics 2 жыл бұрын

Thanks for those kind words Temilola. Means a lot! You can find the main Excel file here: excelolympics.com/wp-content/uploads/2021/07/Job-Interview.xlsx and the files you need forTask number 4 can be downloaded from here: excelolympics.com/wp-content/uploads/2021/05/Question-4-Files.zip May they serve you well!

@randommcrandom2387 3 жыл бұрын

Excellent video, Thankyou so much! Liked and Subscribed. I will check out your other material soon. How can I get the txt files from task 4?

@ExcelOlympics 3 жыл бұрын

Hey Random, first of all, thank you for your kind words! And sure you can get the files. Here is the link to the files: excelolympics.com/wp-content/uploads/2021/05/Question-4-Files.zip

@balakrishnaj1713 2 жыл бұрын

It's very helpful, thankyou

@ExcelOlympics 2 жыл бұрын

Thank you for those kind words Balakrishna J.

@smolboyi 2 жыл бұрын

Thanks for the video, you're a boss!!

@ExcelOlympics 2 жыл бұрын

Thanks Math. Glad you enjoyed the video.

@smolboyi 2 жыл бұрын

@@ExcelOlympics I hope to be a boss like you one day 🙏

@ExcelOlympics 2 жыл бұрын

Thank you for those kind words Math.

@ankitsaharan6833 2 жыл бұрын

Thank you very much Sir very helpful

@ExcelOlympics 2 жыл бұрын

Thank you for those kind words Ankit!

@giorgimodebadze1869 Жыл бұрын

Great video. I want to work as data analyst and those video is excellent for improving Excel skills.

@ExcelOlympics Жыл бұрын

Thanks Giorgi. Glad you found the content educational.

@scottjones1474 2 жыл бұрын

Task2, you have that dropdownlist of the working functions when you select Average,Sum and so on, how do you do that ..? i have been looking for something like this

@ExcelOlympics 2 жыл бұрын

It's the Total Row of a Table. You must use the Format As Table command and then simply turn on the Total Row (Ctrl+Shift+T).

@andersloren8020 2 жыл бұрын

@@ExcelOlympics Thank you!

@courtneymcdonald2691 2 жыл бұрын

In Question 5, what is the last symbol you added to the formula for the source in the Data Validation dialogue box? I couldn't get the screen to be clear enough to see how you did that to keep it dynamic. Thanks soooo much for all of this content! I'm learning lots, including directions for continuing to keep learning.

@ExcelOlympics 2 жыл бұрын

Thanks for the kind words Courtney. The symbol is a #. In the "dynamic arrays" world that implies that you are referencing not only the cell but also the entire range that the formula in the cell defines.

@vincentmokwenye250 3 жыл бұрын

May I request a copy of the file used in these examples/presentation. Thanks.

@ExcelOlympics 3 жыл бұрын

Sure thing Vincent. You can find the main Excel file here: excelolympics.com/wp-content/uploads/2021/07/Job-Interview.xlsx and the files you need forTask number 4 can be downloaded from here: excelolympics.com/wp-content/uploads/2021/05/Question-4-Files.zip May they serve you well!

@miguel60087 3 жыл бұрын

Hey Gašper Kamenšek, first of all, thank you for sharing your knowledge with us. I just have one question regarding question 3. Why does the three different solutions you provided gives different sum values??

@ExcelOlympics 3 жыл бұрын

Hi Miguel. You are welcome and I hope you already found innovative ways to use the new-found knowledge. In regards to your question. First of all, you have a keen eye for spotting that. The reason is that a whole range of values that I am summing up is created with the RANDBETWEEN function and gets recalculated every time I change anything on the sheet. So between the time it takes me to recalculate it another way, it's a totally different set of values that I am summing up.

@miguel60087 3 жыл бұрын

@@ExcelOlympics Thank you very much for the prompt answer. I found this video super enriching!I will follow your videos from now on as it is truly an excel olympics. *^^* Keep it up :)

@amberfalzon9615 2 жыл бұрын

Thanks for this helpful video! My 'Series' option seeems to be greyed out so I can't click it. Do you know how to rectify this please?

@ExcelOlympics 2 жыл бұрын

You probably have an active cell. Press Esc and see if that helps.

@amberfalzon9615 2 жыл бұрын

@@ExcelOlympics Thank you!!!

@jayjackson2916 2 жыл бұрын

This is pretty cool. I have done VBscripting of editing excel files but still am not aware of some of these basic functions. Normally I don't have to worry about it, but apparently for a test next week I do. Also, my very first question is: What is faster? Doing it manually or spending 20-30 minutes trying to figure out the elegant solution and is this a one time thing or will I have to perform this calculation multiple times?

@ExcelOlympics 2 жыл бұрын

I guess the question is if you will have to do it again. If it's a one off, you can practice manual cleanup to stay sharp in Excel. But if it's an ongoing thing, then there is no question Power Query is the best way to get it done.

@CEAmadi Жыл бұрын

Please I need to try my hands on this, please share the file. Thank you

@amandar3905 2 жыл бұрын

On question #2...there's an down arrow next to january.. what is that and how do you formulate the cell to do that? Thanks!

@ExcelOlympics 2 жыл бұрын

It is simply that symbol inserted through cell formatting. It's a trick you use to make Data Validation Drop Down Lists "visible" as one can only guess otherwise. If you wand I can send you a cell format to use.

@johnappleton3382 Жыл бұрын

@@ExcelOlympics Hi , I just discovered this excellent video. Could you also send me the cell format for the Data Validation display trick? This is fantastic. Thank you.

@OlawaleMichael-qm4kf Жыл бұрын

Thanks for the training. Please I need the data for practise. Thanks

@tutsecret499 Жыл бұрын

Hello, is that ok if you could make available the big file with the txt files and the transformed data you di so that I can practice the importing on my end and comparing with yours to see if I am getting right. So I need data to play with and follow with your exercises. Thank you again for your generosity.

@ExcelOlympics Жыл бұрын

You can find the main Excel file here: excelolympics.com/wp-content/uploads/2021/07/Job-Interview.xlsx and the files you need forTask number 4 can be downloaded from here: excelolympics.com/wp-content/uploads/2021/05/Question-4-Files.zip May they serve you well!

@tutsecret499 Жыл бұрын

@@ExcelOlympics Thank you.

@willcontreras9983 2 жыл бұрын

Thank you Gasper. Great video. All Tasks are good, but Q4 & Q5 are awesome. I would appreciate if you would send me the files you used. Also, please keep up with the EXCELLENT work. I've looked at a few other "Interview Exam" videos. But none like yours!

@ExcelOlympics 2 жыл бұрын

Thank you for those kind words. Could you just ping me on LinkedIn with your email and I'll see if I can find the file 😀

@SamanthaMellor-hj3po 2 ай бұрын

Hi, please can you send me the files for this super exercise.Thanks

@sethunyamasebe9733 Жыл бұрын

Brilliant tutorial - I just need to update my excel to the current version with Power Query

@ExcelOlympics Жыл бұрын

So, you will need 2010 or later version of Excel... In 2010 and 2013 you need to download it separately and in 2016 and all that followed it was built in.

@TheHaratashi 2 жыл бұрын

I can never get half of the things on video instructions to do the same thing. I put an apostrophe in front of and number and tried to find it with goto special but it couldn't find it. I typed it in the exact same way but it can't find it. I must have something different in my excel setup I guess.

@ExcelOlympics 2 жыл бұрын

Hi TheHaratashi. Some functions I was using to show one of the possible solutions are only available in Office 365. So it is possible that other Excel versions were not able to find them.

@nicmacmahon5697 Жыл бұрын

great video

@ExcelOlympics Жыл бұрын

Thanks Nic.

@GeertDelmulle 2 жыл бұрын

OK, I expected to learn exactly nothing from this video, and then the very first trick: BAM! I mean: selecting a range using the Name Box: that was a new one for me. Thanks! :-) The rest I knew (even though I would do the PQ part differently, not needing an index column and not needing all those AUX-queries). Good stuff! PS: I learn from ExcelisFun, My Online Training Hub, Leila Gharani, Mr.Excel, and others. PS2: Dynamic Arrays are my favourite part of Excel (vectorisation* is King!), although I’m very fond of PQ-M (as I call it) (and DAX when I need it) and LET() and LAMBDA, too. As Excel goes these are happy times! :-) *: who in his right mind decided to call it “lifting” and “broadcasting”? What were they thinking? What? Is MS in television, now? Like what? MSNBC or something? Oh, wait… ;-)

@ExcelOlympics 2 жыл бұрын

Hi Geert. A day when you learn something new in Excel is a great day in my book. And as you said. There comes a point where it becomes harder to find new Excel knowledge and judging by all you wrote you've reached that point some while ago so it's a small honor to serve you up with a new trick. Glad to do so!

@GeertDelmulle 2 жыл бұрын

@@ExcelOlympics oh no, I have not plateau-d by any means, I learn new stuff all the time - great or small. And in terms of PQ or PP I’m just an intermediate user. In terms of Excel “Classic” maybe a little better. I like to grow my knowledge by unifying Excel Tables, PQ-M and the Datamodel-DAX (there’s a lot of similarities, and many of the new concepts of -say- DAX (e.g. evaluation contexts) can be ported to the other environments). The focus shifts to creating simulation models of ever increasing complexity that solve real-world challenges in real time that the end user can utilise (fairly) easily. For the uninitiated things like that may look like magic. And for those who are willing to learn: a lot of sparkles of insight occur (I like to explain things at work, too).

@ExcelOlympics 2 жыл бұрын

Love it Geert. Keep on rocking!

@georgibudakov8595 2 жыл бұрын

I have to say this is hands down the best Excel video I have watched so far. If there ware more people teaching this level of skill I can't imagine how faster and better the BA world would be. You have my gratitude subscription and like on this. Keep up the great work!

@ExcelOlympics 2 жыл бұрын

Thanks for your kind words Georgi. This means a lot and also gives inspiration for future videos.

@johndickey2594 Жыл бұрын

Hi Kasper. Really enjoyed your video. If possible can you please send me the 4 files you used in question 4. Cheers and thanks.

@ExcelOlympics Жыл бұрын

Hi John, glad to hear you liked the video. You can find the main Excel file here: excelolympics.com/wp-content/uploads/2021/07/Job-Interview.xlsx and the files you need forTask number 4 can be downloaded from here: excelolympics.com/wp-content/uploads/2021/05/Question-4-Files.zip Enjoy

@TheLaopi Жыл бұрын

I cannot use unique fonction because i have excel 2016, i Can only use the power query solution or pivot table

@ExcelOlympics Жыл бұрын

You are right Pierre, there is no UNIQUE in Excel 2016.

@ulrikep. 2 жыл бұрын

I definitely can't apply to you. I hope I have easier tasks to solve tomorrow 😁 But thanks, I learned a lot.

@ExcelOlympics 2 жыл бұрын

That is great to hear Ulrike. Good luck tomorrow!

@ExcelOlympics 2 жыл бұрын

A little birdie told me you got the job. Congrats!

@markgreen4763 2 жыл бұрын

As a beginner with Excel, will conditional formatting work if two or more numbers are the same? kzfaq.info/get/bejne/ZsCirLelyMuVo3k.html Will that method only work if all of the numbers are different?

@ExcelOlympics 2 жыл бұрын

Hi Mark. It will "work" but it can give unexpected results. So numbers 10, 11, 11, 11, 12, 13,14,15,16,16,16 will get ranked as 1,2,2,2,5,6,7,8,9,9,9 and as you can see there are more than 10 numbers in the top 10 😀.

@markgreen4763 2 жыл бұрын

@@ExcelOlympics Depending on the context, I think it would be proper to include "duplicate" values in a top ten list. For example, test scores. (More than one person could get the same test score.) PS. I also learned the keyboard shortcuts: Alt + = and Ctrl + G from watching the first part of this video. Thank you!

@ExcelOlympics 2 жыл бұрын

I Totally agree @Mark and it does function in that way. You could also use the rank function which has multiple variants and you can simply use the one that best fits your scenario. Learning shortcuts is never a bad thing 😀.

@parkdem 3 жыл бұрын

can you do a full power query tutorial if possible my bro?

@ExcelOlympics 3 жыл бұрын

That is on the ToDo list. Not sure when it's going to happen though but it will.

@dhaval1489 2 жыл бұрын

Question 1: go to cell A3 and Ctl; then go to A10000 repeat ctl; and copy that ctl up arrow and paste Question 2: isnumber is the next column and then filter Question 3: pass, in google sheet I know a flatten function then sort and then sum Question 4: I know power query but I am still learning it capabilities Question 5: Exactly as you have solved it your views on my solutions?

@ExcelOlympics 2 жыл бұрын

Not really sure if I understand the answer to the first question. I think it's missing the Shift key before the paste command but let's not let that ruin what was a great job interview 😀. I have my reservations about pass to q3 as I believe in trying even if we don't know the answer but 80% is nothing to frown upon. Thank you for watching and submitting your answers. That takes courage and I respect that!

@wayneedmondson1065 3 жыл бұрын

Hi Gasper. Awesome video!. Nice to measure my current skills against your tests. I'd love to get the files, especially the .txt files for the PQ task. I'm building a store of PQ procedures to practice and memorize. So, having the data files gives me a way to solve and save the solution and then go back and practice it until I've got it in the bank. I've always deleted variable top rows by replacing blanks with null values and then filtering out the nulls, but it can be unreliable if other data gets in the way. Your add an index column and then filtering to the start of the table with the column name to access the row number is great. Glad to have that new trick in the bag. I'm on your mailing list, so if you can send me the files or a link, would be great. Thanks for all the great videos and lessons. Learning lots of new things from you every time :)) Thumbs up!!

@ExcelOlympics 3 жыл бұрын

Thanks for the kind words Wayne and isn't it a great day when you learn something new about Excel? I love those days. And I also love the fact that those days come 365 times in a year (on a non-leap year) 😀

@Lex-je1jd Жыл бұрын

This is great information but one problem is that I wanted to be able to download the spreadsheet so that I could work in the errors myself. I realize the first question is blank but the others are not.

@ExcelOlympics Жыл бұрын

Thank you for that info Lex. I'll check and see what went wrong.

@tutorxai 2 жыл бұрын

Hello, great video !! Would I be able to get the txt files to practise please !

@ExcelOlympics 2 жыл бұрын

Sure thing. You can find the main Excel file here: excelolympics.com/wp-content/uploads/2021/07/Job-Interview.xlsx and the files you need forTask number 4 can be downloaded from here: excelolympics.com/wp-content/uploads/2021/05/Question-4-Files.zip May they serve you well!

@tutorxai 2 жыл бұрын

@@ExcelOlympics Thank you !! will for sure get the job now 😁😁

@ExcelOlympics 2 жыл бұрын

I have no doubt 😀. Good luck.

@TheLaopi Жыл бұрын

Gasper, one word Excellent, where Can i find the txt files ?, From France i watch all your vidéos congrats

@ExcelOlympics Жыл бұрын

@mirelaprodan1536 2 жыл бұрын

These are amazing. I have an interview tomorrow that requires me to take an Excel test. Edit- I failed the test lmaooo. I was preparing for hard stuff and they got me with the basics

@ExcelOlympics 2 жыл бұрын

Best wishes Mirela. You got this!

@USALifeDiaries 3 ай бұрын

Can you tell us what were the questions and on what they tested? Pivot tables or other tests?

@tutsecret499 Жыл бұрын

Is that ok if you can provide the files for us to practice. Thank you.

@ExcelOlympics Жыл бұрын

Here you go Tut. You can find the main Excel file here: excelolympics.com/wp-content/uploads/2021/07/Job-Interview.xlsx and the files you need forTask number 4 can be downloaded from here: excelolympics.com/wp-content/uploads/2021/05/Question-4-Files.zip May they serve you well :)

@tutsecret499 Жыл бұрын

@@ExcelOlympics Thank you.

@leahleydon114 2 жыл бұрын

Was it me or did task 3 examples give 3 different totals?

@ExcelOlympics 2 жыл бұрын

You are totally correct and that is due to the fact that the numbers were made using the RANDBETWEEN function in Excel and if you look closely you will see they change with every press of the Enter key. Sharp Eyes 😀.

@lolaadeoye3584 2 жыл бұрын

You just added to my knowledge base, thanks for your help. Please send me the file for practice.

@ExcelOlympics 2 жыл бұрын

Glad to hear that Lola.

@wiseplanner7479 Жыл бұрын

Please send me the files you used in your video, thank you.

@ExcelOlympics Жыл бұрын

@twainego6059 2 жыл бұрын

Thanks ,I would like to have the files please,thank

@ExcelOlympics 2 жыл бұрын

@jenniferbongalon1758 6 ай бұрын

very informative video sir. that would help me a lot in working with excel..... good thing you're not the CEO of the company that i'm aiming for, or there's no way that i'll ever get hired😁

@matematiksel Жыл бұрын

20:55 I'am not use english language. i write # caracter but i take error. you are write H5# and it is work. but i can't.

@matematiksel Жыл бұрын

i'm find a video about this. i understand my fault. kzfaq.info/get/bejne/Zrlln7Ogva68j5c.html

@ExcelOlympics Жыл бұрын

I believe that syntax will only work in Excel as part of Office 365. So if you have any other version of Excel it will not work...

@matematiksel Жыл бұрын

@@ExcelOlympics Tanks for answering . Your videos are so useful. i am using office 365. Language is not important. I am using this technique frequently now. I subscribe your channel. Have a nice day.

@tomheim9516 2 жыл бұрын

99,998 :-) 6:40

@ExcelOlympics 2 жыл бұрын

True Tom, true. Keen eye 😀

@xodiCxodiC 2 ай бұрын

I have to look you up on Udemy. I want to be in your Classroom. I am 10x better with my excel thinking :). Thank you.

@romulusmilea2747 3 жыл бұрын

Hello Sir, One quick tip from my side: when you write a formula using just one function (any function), there is no need to write in the end the closing parenthesis, just press Enter, and Excel is there for you and add that closing parenthesis. This would save you one second, per formula. Were you aware of this trick ? By the way, excellent 5 interview questions, I would love an one-to-one discussion with you, about other 5 interview questions, of your choice, just to test my 20+ years of Excel knowledge.

@ExcelOlympics 3 жыл бұрын

Hey Romulus. I'll admit. When it comes to pressing Enter and expecting Excel to "autocomplete" my parenthesis... I will probably never get used to this. But it goes beyond just finding it difficult to change one's habits. Writing formulas in so many different places (Excel, Power Pivot, Power BI, Power Query...). The Autocomplete doesn't apply to everything and therefore gets no repetitive use... As far as the one-to-one is concerned. I am thinking of recording part two (just because the first video was so well received by the viewers, and a lot of requests for additional questions have been posted).

@carlewers8591 2 жыл бұрын

My mind is completely blown. Is there anyway you can send me the files so I can practice with you please?

@ExcelOlympics 2 жыл бұрын

Sure thing Carl. You can find the main Excel file here: excelolympics.com/wp-content/uploads/2021/07/Job-Interview.xlsx and the files you need forTask number 4 can be downloaded from here: excelolympics.com/wp-content/uploads/2021/05/Question-4-Files.zip May they serve you well!

@carlewers8591 2 жыл бұрын

@@ExcelOlympics Thank you

@MY-zx6lz 2 жыл бұрын

Great with what you showed us - but just give us the quickest way to get answers - me personally do not care about all the ways to get an answer - just give me the fastest and simplest way - too many steps and possibilities given - how did you get "go-to" did you right-click????

@ExcelOlympics 2 жыл бұрын

Hi. I totally get what you are saying. You see the issue is. All Excels do not have the same commands and whereas there might be multiple solutions, some may not be available for many people. This is particularly important when it comes to Office 365 and newest arrivals like Dynamic arrays and the New Data Types.

@JoanneBemister 4 ай бұрын

This is great! Could I please get the files used sent to my email. Thank you so much. Great job

@qrsimon 11 ай бұрын

So the best question is to ask several ways to a certain outcome

@ObuL83g 3 жыл бұрын

So, unemployed person without money, stuck with Excel 2013(PQ,PBI), should not get the job because of lack of UNIQUE/FILTER knowledge? These two funtions are like: freeware for masses and paid version for pro. Or like: it wasn't Excel all these years till now!

@ExcelOlympics 3 жыл бұрын

My massage definitely wouldn't go towards someone's version of Excel but rather towards how up to date are they with Excel news. Totally agree that it is much harder to do if you don't have the latest version but nevertheless requires only the inquisitive mind. And it's important to note all 5 tasks are solvable in many different ways and none of them is a deal breaker by itself. It all comes down to the person sitting opposite to you.

@sherikaypennati6190 2 жыл бұрын

No fill button :(

@ExcelOlympics 2 жыл бұрын

Sorry to hear that Sheri. Fill button grayed out or not present at all? Did you go for the mouse shortcut or Home/Fill/Series?

@sherikaypennati6190 2 жыл бұрын

@@ExcelOlympics It is actually just not there. I have an online version of Excel that came on my new computer. However, I have a subscription and I guess I need to download Office Suite. Just thought it interesting the thing I needed to follow your exercises is just not there.

@ExcelOlympics 2 жыл бұрын

Oh, yes. You will need a desktop version of Excel to use some of the features I demonstrated in this video.

@lynnw7618 5 ай бұрын

Look, its 25 questions on the SHL Robert Half test and you have less than 25 minutes to complete. Issues are too many options to solve and u fail. It’s bullshit! I used excel when it was shit!

@tutsecret499 Жыл бұрын

Oh God, I have already failed. LOL. I am so rusty. Don't use it, lose it.