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

Поділитися
Вставка
  • Опубліковано 26 лис 2024

КОМЕНТАРІ • 157

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

  • @swagga365beaches
    @swagga365beaches Рік тому +12

    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!

  • @MsBrieBrutal
    @MsBrieBrutal 10 місяців тому +5

    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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @zayanrealty8077
    @zayanrealty8077 Рік тому +36

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

    • @OnlineTrainingforEveryone
      @OnlineTrainingforEveryone  Рік тому +6

      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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 11 місяців тому

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

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 11 місяців тому +1

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

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @marytith5899
    @marytith5899 Рік тому

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

  • @danukka6397
    @danukka6397 2 роки тому +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  2 роки тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 роки тому +2

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

    • @OnlineTrainingforEveryone
      @OnlineTrainingforEveryone  2 роки тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

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

  • @HadassahAbidua-he5fn
    @HadassahAbidua-he5fn Місяць тому

    Great tutorial 👏
    Quick question;In question 8,why is the answer 8 and not 7 since it's a similar question to Qu.7?🤔

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @BingXiao-d6b
    @BingXiao-d6b Рік тому +1

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

  • @NetoMedeirosCareiro
    @NetoMedeirosCareiro Рік тому +1

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

  • @MoodyMooMoo
    @MoodyMooMoo Рік тому

    This was great. Thank you!

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 7 місяців тому

    Great Tutorial.

  • @bhagyarekha-bg7sf
    @bhagyarekha-bg7sf Рік тому

    Thank you sir for very good explanation

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @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😅

  • @anthonyfernandezgonzalez8262
    @anthonyfernandezgonzalez8262 2 роки тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 3 місяці тому

    Great tutorial.

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @Attilaohuno
    @Attilaohuno 3 роки тому +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
      ua-cam.com/video/WrXuvT66mo8/v-deo.html
      Many other great tutorials are available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @robertnegron6804
    @robertnegron6804 6 місяців тому

    Where did you get the price of the items from?

  • @habeebalimi3462
    @habeebalimi3462 Рік тому

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

  • @aliyaabdi9853
    @aliyaabdi9853 Рік тому

    Are you the one forming the price sheet table or

  • @ashleypreston3418
    @ashleypreston3418 Рік тому

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

  • @patriciachuang1419
    @patriciachuang1419 Рік тому

    Do u teach pivoting here ?

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 3 роки тому +1

    Great summary and refresher

    • @OnlineTrainingforEveryone
      @OnlineTrainingforEveryone  3 роки тому

      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
      ua-cam.com/video/Op0Kdemme_w/v-deo.html
      Many other great tutorials are available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @waelsulaiman7235
    @waelsulaiman7235 Рік тому

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

  • @govadaanusha-y2y
    @govadaanusha-y2y 4 місяці тому

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

  • @LuzMarinaAdelino
    @LuzMarinaAdelino 7 місяців тому

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

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @m.zohaibbaig7612
    @m.zohaibbaig7612 Рік тому

    Well explained :)

  • @ayojoy1443
    @ayojoy1443 6 місяців тому

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

  • @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  2 роки тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @singkatenzin498
    @singkatenzin498 9 днів тому

    Hi how do I download sample fie

  • @pavithrakannan5677
    @pavithrakannan5677 2 роки тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 10 місяців тому

    Thank you

  • @weirdo_-or3xc
    @weirdo_-or3xc 2 роки тому +2

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

    • @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 - there're videos on VLOOKUP specifically there
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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?

  • @stevekituku8783
    @stevekituku8783 2 роки тому +2

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

    • @3lackman
      @3lackman Рік тому +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!

  • @kardiiobi321
    @kardiiobi321 2 роки тому +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  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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @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  2 роки тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 3 роки тому +1

    Thank you for materials

    • @OnlineTrainingforEveryone
      @OnlineTrainingforEveryone  3 роки тому

      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
      ua-cam.com/video/Op0Kdemme_w/v-deo.html
      Many other great tutorials are available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

    • @zildog
      @zildog Місяць тому

      ​@@OnlineTrainingforEveryone You're a liar. You don't provide anything except a link to buy your damn subscription.

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @rifaeeehaimed3635
    @rifaeeehaimed3635 Рік тому

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

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 4 місяці тому

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

  • @C_Solu
    @C_Solu Рік тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @arslannadeem-b6s
    @arslannadeem-b6s 10 місяців тому

    thanks

  • @manutjek7215
    @manutjek7215 2 місяці тому

    i can't download

  • @upuldhanushkagajanayake2719
    @upuldhanushkagajanayake2719 3 роки тому +1

    Ohh very helpful

    • @OnlineTrainingforEveryone
      @OnlineTrainingforEveryone  3 роки тому +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
      ua-cam.com/video/Op0Kdemme_w/v-deo.html
      Many other great tutorials are available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @bettybakari2827
    @bettybakari2827 2 роки тому +2

    How do I download the excel for practise

  • @harshambre5332
    @harshambre5332 Рік тому

    can anybody explain me last question

  • @bjornm220
    @bjornm220 Рік тому

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

  • @hartejhaer8851
    @hartejhaer8851 3 роки тому

    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!
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 2 роки тому

      Buy on line training? Not free!

  • @iamsunnysideup7115
    @iamsunnysideup7115 2 роки тому +2

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

    • @purplestringsmariamichelac3391
      @purplestringsmariamichelac3391 2 роки тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @joerybicki1679
    @joerybicki1679 2 роки тому +1

    Hard to understand his annunciation. Parensasys?

    • @OnlineTrainingforEveryone
      @OnlineTrainingforEveryone  2 роки тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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!

  • @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!
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 роки тому +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  2 роки тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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  2 роки тому +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
      ua-cam.com/users/OnlineTrainingforEveryonesearch?query=excel
      Many other great videos are also available here ua-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 роки тому +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 9 місяців тому +1

      @mattbogerson1360 you need English classes

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

  • @banteiksih793
    @banteiksih793 Рік тому

    Don't ai will help you in this situation 😂

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

  • @francishubertovasquez2139
    @francishubertovasquez2139 6 місяців тому

    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!

  • @viralnews.247
    @viralnews.247 Рік тому +1

    video quality is very bad