Take this Excel Interview Test and Avoid Interview Embarrassment

Поделиться
HTML-код
  • Опубликовано: 22 дек 2024

Комментарии • 98

  • @KenjiExplains
    @KenjiExplains  10 месяцев назад +8

    👉Take our Excel for Business & Finance Course here: www.careerprinciples.com/courses/excel-for-business-finance

  • @ahamedarif9933
    @ahamedarif9933 10 месяцев назад +40

    Thank you Kenji for the test. I have finished the test in 7 min. In the future i want you to make a more video like this. it will help our Excel knowledge. Love you man.

    • @KenjiExplains
      @KenjiExplains  10 месяцев назад +3

      Thanks for the suggestion! Will keep it noted :)

  • @abzino
    @abzino 10 месяцев назад +14

    i learnt something new with the CTRL+H trick, but you still have the space after your sentence, so a cleaner formula would be TEXTBEFORE. In cell D6 enter =TEXTBEFORE(C6," (").

    • @hiymanotmidhaksa6185
      @hiymanotmidhaksa6185 5 месяцев назад

      Wow its important

    • @rajan5551
      @rajan5551 11 дней назад

      I tested that inserting a space before opening parentheses in "find what" will also work.

  • @lynnw7618
    @lynnw7618 9 месяцев назад +6

    Thank you. I took a timed test, only 30 seconds per question and that was daunting.

  • @excelgazialimuhiddinhacibekir
    @excelgazialimuhiddinhacibekir 8 месяцев назад +2

    Great video and a diverse array of fundamental Excel questions. Thank you Kenji!
    For the BONUS QUESTION, I'd go by the formula *=LEFT($C6,SEARCH("(",$C6)-2)* since the parentheses appear only at the end of company names in column C.

    • @Xirnatts
      @Xirnatts 4 месяца назад

      Here's a more elegant one for M365 users: =TEXTBEFORE($C6, " (")

  • @lunagale1573
    @lunagale1573 9 месяцев назад +1

    thank you for going over both the text split formula and the text to columns options. It makes it very accessible.

  • @gemini4109
    @gemini4109 10 месяцев назад +2

    @KenjiExplains, I've been watching your videos for some time now, I was able to complete all the questions without following along with the video, however I will watch now to get other ideas on how to solve. Thank you!

  • @willzinner8813
    @willzinner8813 10 месяцев назад +11

    had no idea about the * in the bonus q thanks

  • @stevejauna2751
    @stevejauna2751 8 месяцев назад +5

    This exercise is great but I thought of a better solution for Q5 which uses SUMIF: =SUMIF(B6:B16,F6,D6:D16). If Sarah was to work part-time in one department and part-time in another, then she would occur twice in the table, so you would need to sum for the two occurences. XLOOKUP would only reference the first occurence. In your example, Xlookup works fine, but only because Sarah only occurs once in the table. Also if instead you wanted to know the revenue for a department like Sales (3 occurences), then SUMIF would be better.

  • @Ben-gd4db
    @Ben-gd4db 10 месяцев назад +1

    I used =LEFT(C6,FIND("(",C6)-1) in a new column for the bonus question, had no idea it was possible the other way! Will definitely be using that one going forward

    • @KenjiExplains
      @KenjiExplains  10 месяцев назад

      Awesome! Thanks for watching :)

  • @lizmcneill1641
    @lizmcneill1641 8 месяцев назад

    Thanks!

  • @thesonofasniper
    @thesonofasniper 10 месяцев назад

    So an excel test I had the other week involved using LEFT to pull a code from a larger file name, using those codes for a v look up on a 2nd sheet. A pivot table for client costs, and some basic maths formula

  • @TerraDefensor
    @TerraDefensor 8 месяцев назад +1

    Awesome video 🤝 Here's an additional solution for your bonus question that works when you need to erase text after or before specific characters. So, you can use the same function REPLACE (CTRL+F) and use (* to delete whole text after it finds last character "( " , or if you want to delete text before certain character you can use logic *( to delete all text before last character in this case "(".
    Best regards, Stevan

  • @lvsingh7509
    @lvsingh7509 8 месяцев назад +1

    Hi Kenji, I used the function textbefore for the bonus question and used "(" as the delimiter. That worked too.

  • @johannes_9078
    @johannes_9078 2 месяца назад

    Bonus q can be solved with text to columns too, using "(" as delimiter and selecting skip column for the latter part.

  • @mysticz7791
    @mysticz7791 10 месяцев назад

    Hi Kenji, for the last question, I would use text to columns separated by (; your solution is obviously more elegant

  • @kasturilahkar8186
    @kasturilahkar8186 6 месяцев назад +1

    No one like him. Life saver.

  • @waynez8136
    @waynez8136 10 месяцев назад

    I have passed your test using the exact same solutions shown in this video. You are truly my master ^_^

  • @alexrosen8762
    @alexrosen8762 10 месяцев назад +2

    Loved that bonus answer

  • @nyambesimangolwa5755
    @nyambesimangolwa5755 10 месяцев назад

    Finally! A video that easily explains Index Match and how is compares to Xlookup. Thanks Kenji!

    • @KenjiExplains
      @KenjiExplains  10 месяцев назад +1

      Glad it was helpful!

    • @nyambesimangolwa5755
      @nyambesimangolwa5755 10 месяцев назад

      @@KenjiExplains As always! Please keep 'em coming, these videos help way more than you can imagine.

  • @SingZeon48
    @SingZeon48 9 месяцев назад

    With the bonus question: would the extra space cause any issues e.g. when sorting? My plan was to find-replace “ (” to some other symbol not used, then Text to Columns, splitting via that symbol, and only retaining the left column

  • @shadeburst
    @shadeburst 8 месяцев назад

    Hi, I'm better than I thought! For the bonus question to leave the original data intact, should someone need the stuff in parentheses later, I would have used SUBSTITUTE().
    Off topic, autofill is magic at learning by example. You type in what transformations you want for the first few rows and autofill does the rest.

  • @shabchique7149
    @shabchique7149 10 месяцев назад +1

    That was fun! I even got the bonus question because I learned it from you, on another video. 😆🙏

  • @MrVilla305
    @MrVilla305 7 месяцев назад

    Great video! I think that for Q5, a sumif would've been useful in case there were multiple Sarah values in a larger dataset.

  • @MohammadShafeeq-n3g
    @MohammadShafeeq-n3g 10 месяцев назад

    Really great prep help!! Cheers, Kenji!!, could you do a video on how to make a quality MIS report in excel

  • @patricksanchez8447
    @patricksanchez8447 10 месяцев назад +1

    That bonus question got me. Thank you! 😊

  • @lizmcneill1641
    @lizmcneill1641 8 месяцев назад

    Great video thanks Kenji. I did another of your excel common questions earlier which really helped when I did this one. Chuffed with myself 🙂

    • @KenjiExplains
      @KenjiExplains  8 месяцев назад

      That's awesome to hear! Best of luck if you have an Excel interview coming up :)

  • @malmedia
    @malmedia 10 месяцев назад +3

    For the bonus I probably would have used textsplit or text to columns. But Learning the wildcard option in find and replace it great. I can see myself using that for quick results. Thanks!

  • @shweta-bisht
    @shweta-bisht 7 месяцев назад +1

    best interviewer and the best applicant 😂💞🙏🏽

  • @qfit80
    @qfit80 10 месяцев назад

    Excellent Excel proficiency exercises. Keep up the good work!

  • @hotcarlsf
    @hotcarlsf 10 месяцев назад

    Neat trick on the bonus question. Shouldn't you add a space in front of the open parenthesis though? Otherwise if you try to do a lookup for the name, you wont get a match because of the space at the end that isnt instantly noticeable

  • @financnifitness2583
    @financnifitness2583 8 месяцев назад +2

    Hi Kenji, what if I have in my Excel only IFS function (not the IF), how should I put it then? Because with IFS, there are not enough ifs...if you understand that :D

  • @EvansAdarkwah-e3t
    @EvansAdarkwah-e3t 3 месяца назад

    Great resource. I want more of this. Thank you

  • @ayomideomolara341
    @ayomideomolara341 8 месяцев назад

    Hi Kenji, pls the bonus question i cud not solve it from my end and my excel is 2021. And thanks for your videos i learn alot from you.

  • @shweta-bisht
    @shweta-bisht 7 месяцев назад +3

    For the 5th que I've used Vlookup then index+match+match bcz I have excel 2013 and it doesn't have the Xlookup function 🤡🙏🏽

  • @camlex6310
    @camlex6310 10 месяцев назад

    Really great prep help!! Cheers Kenji

  • @petlover6072
    @petlover6072 20 дней назад

    Very helpful video. Thanks

  • @PiereAllexandraBermejo
    @PiereAllexandraBermejo 3 месяца назад

    can you explain how does dollar sign mean each replacement? like what does it mean if $G$5 or G$5

  • @ronniepajas1872
    @ronniepajas1872 10 месяцев назад

    Good morning Kenji, I have a formula that use to link different sheets, but when i new information to the main sheet, the Links become dead, how do maintain the link with additional information that changes the location from original sheet. Again the main is a master list with different information, but i have to isolate a column to another sheet. Thank you in advance

  • @ryyyyy2010
    @ryyyyy2010 10 месяцев назад +1

    tysm man appreciates it.

  • @oluwandetowoju6323
    @oluwandetowoju6323 10 месяцев назад

    In question 5, I can also use SUMIF function too

  • @pavanigoud98
    @pavanigoud98 10 месяцев назад

    Please make more videos of excel test . Lots of love ❤❤

  • @ChrisL-z5h
    @ChrisL-z5h 6 месяцев назад +1

    I passed! have an interview tomorrow

  • @francishubertovasquez2139
    @francishubertovasquez2139 7 месяцев назад

    Thanks for new formulas I've just learned usually done for corporate departmental earnings calculation and presentation. It's like having a peek into the corporate world of meticulous data accuracies. Can AI in a specific department be programmed to update or correct data and files in real time for numerous data files for for personnel reviews complete with displays and presentations to proof check any probable errors and having to update newly entered data's in real time as an assessment tools to asses AI performance and to double check also for any human errors aside from supervisorial reviews and checks in Data and files segregation by systematic orderings of entered data's pre prorammed as such like having second opinion like in medical check ups and transforming AI solutions as a human assistance partner in real time accurate information enterings for very large bulk of data files only at the same time as a tool mechanism of pre programmed data storage facilitator.

  • @brytonbeats5077
    @brytonbeats5077 9 месяцев назад

    Man i like the way you explain things

  • @casonalimudgal7986
    @casonalimudgal7986 6 месяцев назад

    Great . It really worked for me.

  • @SilenceHurtsMore
    @SilenceHurtsMore 10 месяцев назад

    I need help, how would you count the number of consecutive days in excel ? For example, if after 5 days worked in a row, there is at least 1 day off?

  • @KittKatPawz
    @KittKatPawz 3 месяца назад

    I have to get used to using wild card * - been doing excel for 25 years and still learning new things.

  • @AzeezulGani
    @AzeezulGani 5 месяцев назад

    I got them all correct, what will be my level of expertise in excel?
    Is it beginner or intermediate or advanced?

  • @MakeSomethingToday.
    @MakeSomethingToday. 3 месяца назад

    I love the bonus 😊

  • @andreasandoval5039
    @andreasandoval5039 10 месяцев назад

    Awesome, thanks Kenji!

  • @damarisrodriguez5118
    @damarisrodriguez5118 10 месяцев назад

    I didn’t know about that bonus question 🙌🏼🙌🏼

  • @shaadshamim-gl7bk
    @shaadshamim-gl7bk 9 месяцев назад

    Hey Kenji, i hope you are doing well, just a quick question for Q5, when i put the same formula my excel doesn't show the correct answer but it shows the last revenue at D16, is it because if have old excel or is there something else wrong?

  • @Sjlove37
    @Sjlove37 10 месяцев назад

    Thank you ❤❤❤

  • @rehantechzone5690
    @rehantechzone5690 10 месяцев назад

    Wanderfulll ❤️ ❤️ form India..

  • @abuzarkhan8466
    @abuzarkhan8466 10 месяцев назад

    Good Questions Kenji😀

  • @AbdulRahman-yp6oy
    @AbdulRahman-yp6oy 10 месяцев назад

    Very Good Kenji Carry on
    please work on Power BI 🥺🥺🥺🥺

  • @francishubertovasquez2139
    @francishubertovasquez2139 7 месяцев назад

    Actually the Michael Jordan and Scottie Pippen in the Chicago Bulls, and John Lennon and Paul McCartney tandem in the Beatles winning formula indirectly infused a glimpse of what's gonna be ahead of time that works.

  • @travisos7199
    @travisos7199 8 месяцев назад

    Thank you

  • @773yanna
    @773yanna 3 месяца назад +1

    I need this to be thee EXACT test they give me lol

  • @anjaligoorha3180
    @anjaligoorha3180 8 месяцев назад

    in my excel 2016 no function is textsplit..which is your version?

    • @WMD4929
      @WMD4929 8 месяцев назад

      It was introduced in Excel 365.

  • @Taj73-l3w
    @Taj73-l3w 10 месяцев назад

    I'm seriously waiting for your video on python basics to advance

  • @iamtheman4416
    @iamtheman4416 10 месяцев назад

    Love u bro❤

  • @aspectoflife
    @aspectoflife 10 месяцев назад

    the best community service too

  • @dclomg5
    @dclomg5 4 месяца назад

    Very good

  • @PriyaPuranik-s1m
    @PriyaPuranik-s1m 2 месяца назад

    Woww great !!

  • @vandana2480
    @vandana2480 9 месяцев назад

    I appreciate the video, but most of these questions were already covered in your previous videos.

  • @francishubertovasquez2139
    @francishubertovasquez2139 7 месяцев назад

    Galing mo sir sa push button, chicks drawer Yan, kaya nga ako nag aaral Dyan, he he.

  • @chuken1067
    @chuken1067 10 месяцев назад

    For the question 3, there is another formula to split the text, I will use MID and Find to do this question if the excel version is before 2013😅

  • @swapnilyadav6162
    @swapnilyadav6162 10 месяцев назад

    Kenji make video on how to automate whole financial modeling using AI to save hell out of time

  • @ildodossantos3807
    @ildodossantos3807 10 месяцев назад

    Great :)

  • @TshetenDorji-wx4ud
    @TshetenDorji-wx4ud 6 месяцев назад

    Bravo

  • @aspectoflife
    @aspectoflife 10 месяцев назад

    top man

  • @ruslanazimov8616
    @ruslanazimov8616 10 месяцев назад

    Great

  • @MelissaWilliams-m4r
    @MelissaWilliams-m4r 3 месяца назад

    Rodriguez Ruth Anderson Donald Martinez Cynthia

  • @hashimshah7732
    @hashimshah7732 Месяц назад

    I knew the answers to all the questions but still I'm unemployed 😂😂😂

  • @mugomuiruri2313
    @mugomuiruri2313 10 месяцев назад

    AI IS COMMING

  • @obi4830
    @obi4830 5 месяцев назад

    Hit the Tab key thereee❤

  • @michaeldanquah4318
    @michaeldanquah4318 10 месяцев назад

    who would i be if i didn’t meet Kenji Explains?🥹