How to Pass Excel Test for Job Interview: Excel Formulas & Functions Questions and Answers

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

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

  • @OnlineTrainingforEveryone
    @OnlineTrainingforEveryone  ปีที่แล้ว +5

    Practice Microsoft Excel Assessment Test www.howtoanalyzedata.net/how-to-pass-the-microsoft-excel-assessment-test/

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

      Prepare for an Assessment Test: www.howtoanalyzedata.net/assessment-test-practice-and-preparation-resources/
      Download FREE Sample Hiring Assessment Test Questions (PDF eBook): www.howtoanalyzedata.net/0fyb

  • @zayanrealty8077
    @zayanrealty8077 ปีที่แล้ว +34

    Waw you did better than my professor that took a whole semester in a few minutes video

    • @OnlineTrainingforEveryone
      @OnlineTrainingforEveryone  ปีที่แล้ว +5

      Glad it was helpful! Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @swagga365beaches
    @swagga365beaches ปีที่แล้ว +9

    You're so knowledgeable in Excel. I am learning a lot from all your videos already. I am preparing for an accounting interview in ten days. I am working day and night to pass this test. I am confident and ready because of you. Thanks a million. I will study all the relevant videos in my profession that you have made already!

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

      So did you clear it?

  • @MsBrieBrutal
    @MsBrieBrutal 7 หลายเดือนก่อน +4

    Probably one of my favorite videos! I love that you are clear and straight to the point, this makes learning much easier

  • @bamlaktadele3457
    @bamlaktadele3457 ปีที่แล้ว +34

    Just mind blowing ! You went straight to the point and explained it very quickly:))
    Your the best!!!

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @brownigirlpie
    @brownigirlpie ปีที่แล้ว +12

    Thank you I needed to ramp up quickly on my knowledge of these functions - this is a great starting point. Thanks again.

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

      Glad it was helpful! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @MetalD
    @MetalD ปีที่แล้ว +5

    This is awesome excel training/tutorial! You are precise & speak clearly. Thank you!

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

    Thank you! Hoping you would never stop making videos about excel 💕

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

      You got it Caryl! Thank you for watching and leaving a kind comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    My interview is after 3 days and this is really helpful, thank you!

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

      Thanks! All the best on your job interview and assessment test!

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

      How did your interview go?
      Thank you for watching and leaving a kind comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    Thank you so much for this tutorial as it was very helpful. I am not very familiar with Excel and how to used the formulas and functions but I will continue to try to learn more.

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

      Glad it was helpful! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    You are very helping regarding excel Assessment Test and teaching way is very simple & concise .

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

    I knew most of them but I couldn't have done them all. I am in awe of how you can ask so many questions on a set of dara in such a concise way.

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

    Great tutorial! this is the first excel video I choose to learn excel. Thank you! You earn a subscriber :)

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

    Thanks for the very clear explanations. I discovered your posts today, and i am going to follow all of them.. what you are sharing with us is very useful.

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

      Awesome! Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    Wow. U made it so easy. At one view, ive understood all the functions you taught.

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

      Glad it was helpful! Thank you for watching and leaving a comment as well! Please check out my new video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @sevensevenseven6989
    @sevensevenseven6989 8 หลายเดือนก่อน +1

    I have an upcoming test for excel for a new position in the company. I hope this will help me 😊

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

    I learn a lot from this video . Thank you so much 😊

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

      My pleasure 😊 Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @felipezimuriithi9801
    @felipezimuriithi9801 21 วันที่ผ่านมา

    Great tutorial.

  • @k.6160
    @k.6160 2 ปีที่แล้ว +4

    Great video. You explain so clearly, I thank you!!

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

      Thanks for watching K! Keep on going!!!

    • @k.6160
      @k.6160 2 ปีที่แล้ว +2

      @@OnlineTrainingforEveryone I took the Excel LinkedIn skills test and passed! In the top 5%! I've been studying my butt off!!!🏆😁

    • @k.6160
      @k.6160 2 ปีที่แล้ว +2

      Thank you!

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

      That's awesome! Congrats!!! Thank you for watching and leaving a comment as well! Keep learning! Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @user-of1dt4yo5p
    @user-of1dt4yo5p ปีที่แล้ว +1

    This is awesome and really helpful! Thanks for the great video!

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

    Thank you so much! ✨

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

      Thank you very much for watching Erika and leaving a comment as well!
      Please make sure to check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    Excellent instructions 👌 👏 👍 😀

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

      Glad it was helpful! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @divyaadr26
    @divyaadr26 4 หลายเดือนก่อน

    Great Tutorial.

  • @bhagyarekha-bg7sf
    @bhagyarekha-bg7sf 11 หลายเดือนก่อน

    Thank you sir for very good explanation

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

    Thank you! I took the exam first and got 9 out of 12 passing is 8, then I look up for this video. I could have ace it if I've watch this video first😅

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

    You too good in this sir, keep it up

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    Great resources. Very helpful. Thanks!

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

      Glad it was helpful Charlie! Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    I have a skills test this Friday. I'm hoping it is similar to this.

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

      Fingers crossed but do try to prepare as much as you can please! Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

      @@OnlineTrainingforEveryone thank you!

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

    You are the Best!!!

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

      You're very kind Julio! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @AJ-et3vf
    @AJ-et3vf ปีที่แล้ว +1

    great video! Thank you!

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

      Thanks for the feedback! All the best on your job interview and assessment test!

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

    Last one I have learned now

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    Thank you so much for this!!

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

      Glad it was helpful! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @mj-sl2wg
    @mj-sl2wg 2 ปีที่แล้ว +2

    I love your videos. Very educative! 😍😘

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

      Glad you like them MJ! Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

  • @MoodyMooMoo
    @MoodyMooMoo 11 หลายเดือนก่อน

    This was great. Thank you!

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

    Extremely helpful, thanks for sharing!

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

      Thank you for watching SB and leaving a comment as well. Please check out my newest video and let me know what you think about it
      th-cam.com/video/WrXuvT66mo8/w-d-xo.html
      Many other great tutorials are available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them.
      You can also check out my website for extra materials that would help you to get ready for an interview.
      www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    Fantastic man, thanks again!!!

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

      Glad you think so Anthony! Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    Great summary and refresher

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

      Thank you for watching and leaving a comment as well. Please check out my newest video and let me know what you think about it
      th-cam.com/video/Op0Kdemme_w/w-d-xo.html
      Many other great tutorials are available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them.
      You can also check out my website for extra materials that would help you to get ready for an interview.
      www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    i got the job!

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

      That's awesome! Huge CONGRATS! Thank you for watching and leaving a comment as well! Please keep learning and make sure to check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @user-ip9bw2vl8i
    @user-ip9bw2vl8i 7 หลายเดือนก่อน

    thanks

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

    Thanks for posting

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

  • @Dee-uz4us
    @Dee-uz4us 7 หลายเดือนก่อน

    Thank you

  • @weirdo_-or3xc
    @weirdo_-or3xc ปีที่แล้ว +2

    Thanks a lot for this but the vlookup part still confuses me😓

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them - there're videos on VLOOKUP specifically there
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

      @@OnlineTrainingforEveryone yes, at one point he says A2:A6 but he types A2:B6?

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

    Hi, in the 6 question =SUM(SUMIFS(A2:A12;B2:B12;{"PEN";"PENCIL"})) ctrl+shift+enter

  • @TC-xz4im
    @TC-xz4im 2 ปีที่แล้ว +1

    Very helpful indeed!

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

      Glad you think so TC! Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview.
      www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    thanks !

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

      You're welcome! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    Thank you for materials

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

      Welcome 😊 ! I'm really glad you liked it! Thank you for watching and leaving a comment as well. Please check out my newest video and let me know what you think about it
      th-cam.com/video/Op0Kdemme_w/w-d-xo.html
      Many other great tutorials are available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them.
      You can also check out my website for extra materials that would help you to get ready for an interview.
      www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

  • @ashleypreston3418
    @ashleypreston3418 11 หลายเดือนก่อน

    How do you know which functions to use for each answer the question is asking?

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

    Where did you get the price of the items from?

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

    do you have online classes? i would love to be your student

  • @govadaanusha-y2y
    @govadaanusha-y2y หลายเดือนก่อน

    hey pls help I couldn't download files related to this video for practice

  • @m.zohaibbaig7612
    @m.zohaibbaig7612 ปีที่แล้ว

    Well explained :)

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

    Wish I could control speed of presentation I have a reattached-retina left eye so an you slow it mabelet viewer control speed?

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

      Thank you for watching and leaving a comment as well!
      Rick,
      You can adjust the speed of the video in the video settings. You can make it as slow as you need. Please try to work with the setting so you find the speed that works for you.
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    Are you the one forming the price sheet table or

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

    Thank you for this lecture,but I couldn't get answer 18 and 19,as the formula counting and sumig is not responding.

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

      Thank you for watching Ruth and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    On point 👌

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

      Thank you for watching Elvis and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    quite informative. thanks!

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

      Glad it was helpful Peter! Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

  • @LuzMarinaAdelino
    @LuzMarinaAdelino 4 หลายเดือนก่อน

    Hello. I can't seem to make the multiple SUMIF functions work. Need help with this one. Thank you!

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

    Please when you say we should download the practice file please do drop the practice file cause incant seem to find them ,all I see a stuff and that's all

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    Nice!

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    how to download the file i cont find file link...............can you please paste the link here

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    Hi! I have an issue when it comes to executing vlook up function i get #N/A

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

      Having exact same issue, i have tried several ways and its still N/A for couple of them not all.

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

      The most common cause of the #N/A error is with XLOOKUP, VLOOKUP, HLOOKUP, LOOKUP, or MATCH functions if a formula can’t find a referenced value. For example, your lookup value doesn’t exist in the source data. Solution: Either make sure that the lookup value exists in the source data, or use an error handler such as IFERROR in the formula. For example, =IFERROR(FORMULA(),0), which says:
      =IF(your formula evaluates to an error, then display 0, otherwise display the formula’s result)
      You can use “” to display nothing, or substitute your own text: =IFERROR(FORMULA(),”Error Message here”)
      Hope it helps! Best of luck!

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

    Do u teach pivoting here ?

  • @waelsulaiman7235
    @waelsulaiman7235 11 หลายเดือนก่อน

    Pivot table ? Where I can find link to excel download?

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

    where is the excel file for this video? is it for sale?

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

    I'm using NeoOffice,no. of characters not working I got 0 results.?

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

    Ohh very helpful

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

      Glad to hear that! 😊 Thank you for watching and leaving a comment as well. Please check out my other newer video and let me know what you think about it
      th-cam.com/video/Op0Kdemme_w/w-d-xo.html
      Many other great tutorials are available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them.
      You can also check out my website for extra materials that would help you to get ready for an interview.
      www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

  • @NIVEDITAMUKHERJEE-u5q
    @NIVEDITAMUKHERJEE-u5q หลายเดือนก่อน

    Please write the formula hear of Q no 9... can't understand

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

    How do I download the excel for practise

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

    How to get six fourty two best calculations

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    If I get that Job tomorrow you are getting a cookie!

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

    can anybody explain me last question

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

    Wait a minute! How is the price of each item A COLOR???? You lost me on that one!

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

      he used the color just to mark the question as answered in the right-hand side table. The actual answer for the question consists in many prices, so he wrote them in the left-hand side table. If this makes sense

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

      Great explanation Maria! Thanks for stepping in!!! It's awesome to see people helping each other!
      Thank you for watching and leaving a comment as well! Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    Where is the dataset please?

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

      Glad it was helpful! Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning!
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

      Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

      Buy on line training? Not free!

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

    Hard to understand his annunciation. Parensasys?

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

      Sorry you find my pronunciation hard to understand! Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    I order the ebook but only received 15 questions instead of the 50 questions as described. Please refund as I am taking test today (5/15/2023).

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

      Very sorry Rose - not sure what or how exactly it happened. Would you please reach out to me via the website? This kind of questions need to be addressed there not here. Thanks for understanding! Best of luck on your test!!! Please keep me posted on how it went.

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

    😍😍😍😍😍😍😍😍😍😍😍

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

      Thank you for watching Timothy and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them. There're so many great features in Excel - please keep learning!
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/ Please let me know if it was helpful and good luck in your journey!

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

    I am discharged with 40% disability for DM Type II and Hypertension in peace stations.saying it is life style disease NANA no disability pension admissible. Please advice me.

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

    Hard

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

      Hi Jana, sometime you might get get hard questions on the real test! please keep practicing to master the material. All the best on your job interview and assessment test!

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

      Thank you again Jana for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

    it would be easier, but i cant understand what the narrator is saying half of the time

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

      Very sorry you have hard time understanding me! What exactly you struggling with? Thank you for watching and leaving a comment as well!
      Please check out my other video tutorials on Excel and let me know what you think about them
      th-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here th-cam.com/users/OnlineTrainingforEveryone
      Lots of helpful information in each and every one of them. You can also check out my website for extra materials that would help you to get ready for an interview. www.howtoanalyzedata.net/resources/
      Please let me know if it was helpful and good luck in your journey!

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

      He speaks so clear, maybe you are not understanding because you need some other more basic excel to help understand this level.

    • @manjarisampang905
      @manjarisampang905 6 หลายเดือนก่อน +1

      @mattbogerson1360 you need English classes

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

    Don't ai will help you in this situation 😂

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

    4, 7 and 11? Are you one of the four angels of the 4 corners of the Earth to confront the four horsemen in the endtime 7 Trumphets? And your probing on me ha? Trying your KGB or Speznaz training on me if thatll work or not? Well I dont care about quarrels in the spiritual world nor your ambitions, just dont mess with my life because the Caesar King is not spiritual. Got that!

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

    video quality is very bad