@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!

@willieward7419

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.

@dreamangel3487

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

@pengupengu8

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!!

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

@37777steve

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

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

@shineandseek

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

@kebincui

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

@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

@michaeldempsey3471

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

@grigitajanule8770

mind blowing, great educational video and i loved it

@OlawaleMichael-qm4kf

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

@utubeAgape

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👍

@nestortelleria3861

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

@giorgimodebadze1869

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

@sethunyamasebe9733

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

@GrainneDuggan_Excel

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

@johirulmridul2306

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