Excel Test for Job Interview - Download this Test and practice your Excel Skills

แชร์
ฝัง
  • เผยแพร่เมื่อ 18 พ.ย. 2024

ความคิดเห็น • 39

  • @YiannisPi
    @YiannisPi  2 ปีที่แล้ว +4

    Nest stop is an Excel Dashboard - The SQL - Then Python

  • @donmelanie908
    @donmelanie908 8 หลายเดือนก่อน

    Thanks so much for your insightful videos. Your patience and step-by-step explanations is commendable❤

  • @farhiohanshi4230
    @farhiohanshi4230 3 หลายเดือนก่อน

    My favourite channel ❤ I only watch and make a resource in ur vedios .thanks
    Iam a beginner of data analyst plz am requesting to make more vediods in excel,spreedsheet,SQL And visualization

  • @claremarie91
    @claremarie91 3 หลายเดือนก่อน

    This is so helpful! Thank you for sharing :)

  • @yadude101
    @yadude101 2 ปีที่แล้ว +4

    Can you do more videos like this to give more examples of test questions on other topics? this was very good 👍 😊

  • @Polina-ur2xi
    @Polina-ur2xi ปีที่แล้ว +6

    Is "average of average" in the Pivot Table correct? Shouldn't it be "Average of Total"?🤔

  • @aboutface1012
    @aboutface1012 ปีที่แล้ว

    Thanks very much for this ❤

  • @MacKaledy
    @MacKaledy ปีที่แล้ว +4

    okay video, i do think you made mistake when trying to get the averages. it shouldnt be the average of the average but the average of the totals. also you need to adjust format in the charts to better show the variances between data entries but thats also due to the data being very broad. in general i do think the video(s) offered me something tho. thank you.
    also i used xlookup as others have mentioned its more intuitive.

  • @Oszysr
    @Oszysr ปีที่แล้ว

    Thank you for making these videos so easy to understand.

  • @rhondamurray5362
    @rhondamurray5362 ปีที่แล้ว

    These were awesome explanation videos!

  • @lawrence_799
    @lawrence_799 ปีที่แล้ว

    Thank you so much, As an international student with IELTS 6.5, I actually understood all of it, which was too clear.

  • @tomjohnas134
    @tomjohnas134 2 ปีที่แล้ว +1

    Great! Been waiting for this!

  • @rogerdeoliveira6749
    @rogerdeoliveira6749 2 ปีที่แล้ว +1

    part 8, you could Xlookup. (A4,'Part 2'!A:A,'Part 2'!B:B)) and itll return the values correctly

  • @AlexMar-r
    @AlexMar-r ปีที่แล้ว

    thanks for the videos are you in the U.S ? i can do all this in Python but not in excel lol thanks for the videos they are helping me catch up .

  • @toeytoey9715
    @toeytoey9715 2 ปีที่แล้ว +1

    Great videos! Thank youuuu! ✨🙏✨

  • @robertue1
    @robertue1 2 ปีที่แล้ว

    Thanks Yiannis. Really helpful content!

  • @timn.8667
    @timn.8667 10 หลายเดือนก่อน

    Can I get this data to try it on my own using an excel worksheet?

  • @marvelousrosales3940
    @marvelousrosales3940 ปีที่แล้ว

    THANK YOU !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  • @MendiMountainMan1969
    @MendiMountainMan1969 5 หลายเดือนก่อน

    My friend, #8 was very close to a question on my excel test. I passed it because I applied that formula =vlookup. Thank you so much for the video!!

  • @magda2193
    @magda2193 ปีที่แล้ว

    thank you!

  • @cristinaposner238
    @cristinaposner238 ปีที่แล้ว

    Thank you for the video

  • @soujanyakris7039
    @soujanyakris7039 ปีที่แล้ว

    Very helpful!

  • @abualbertsesay1034
    @abualbertsesay1034 2 ปีที่แล้ว +2

    How to download this Excel test and practice exercise?

  • @cihanevren3950
    @cihanevren3950 2 ปีที่แล้ว

    Thank you for the content!

  • @ErinBaker-o1d
    @ErinBaker-o1d ปีที่แล้ว

    Why didn't you include the totals for pivot table? Just wondering. Thanks

  • @randoms_7208
    @randoms_7208 2 ปีที่แล้ว +1

    thank you

  • @lfcblaze
    @lfcblaze 2 ปีที่แล้ว

    subscribed, super helpful

  • @Ali-bk1hr
    @Ali-bk1hr 8 หลายเดือนก่อน

    On the assessment day centre i went to they gave me a random data set table paper and told me to tell them what insights i see from it. Is there any resource i can use from a website to practice those types of questions?

  • @gunasekaranm5775
    @gunasekaranm5775 ปีที่แล้ว

    Does anyone know any sites or assessment platforms that has these Excel interactive tests for free?

  • @funmilayofrancis7252
    @funmilayofrancis7252 2 ปีที่แล้ว +1

    Great content....However, Could you go a little slower next time?

  • @Twinsforthewins14
    @Twinsforthewins14 2 ปีที่แล้ว +4

    Where is part 1?

    • @Hrchjfjd
      @Hrchjfjd ปีที่แล้ว

      th-cam.com/video/FEyV96xE0fU/w-d-xo.html

  • @alilakhani7796
    @alilakhani7796 ปีที่แล้ว

    why did the last pie chart (step 12) only have 3 colors instead of 7 colors for all the different distributers?

    • @ememalice7804
      @ememalice7804 8 หลายเดือนก่อน

      There are 7. check data label and you will se all. just that some values are to small

  • @MoodyMooMoo
    @MoodyMooMoo ปีที่แล้ว

    15 minutes seems a bit fast for all those 😮‍💨

  • @KelliCassarella-ek5km
    @KelliCassarella-ek5km ปีที่แล้ว

    Part 1: th-cam.com/video/FEyV96xE0fU/w-d-xo.html

  • @mansimshukurov36
    @mansimshukurov36 2 ปีที่แล้ว +1

    Hello Yiannis, for your help, full video two days ago, I had given a test from Excel for a job, and your videos I found instrumental. If possible, I would like to know your email address for sending you the tasks they provided me during the examination.
    Thanks

  • @abualbertsesay1034
    @abualbertsesay1034 2 ปีที่แล้ว

    I found yours videos very instrumental and really appreciate it. Would you kindly send to me via email.

  • @gardenofhappiness5488
    @gardenofhappiness5488 10 หลายเดือนก่อน

    thank you