Excel Test for Job Interview 2021

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

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

Excellent

I love your delightful videos. Thank you again.

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

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

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

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

Thank you

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.

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!

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

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

Where can I find these files please to practice with? Thanks

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

Evening what are the most Formulars or purchases

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

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

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.

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

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

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

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.

great video

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

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

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!

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?

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

Thank you very much Sir very helpful

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.

Absolutely enjoyed your work! Super!

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

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.

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

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

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

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

No fill button :(

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!

It's very helpful, thankyou

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!

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

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.

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

Superb content, loved it.

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