20 Excel Formulas and Functions to Master in 2024 - Excel Formulas and Functions Training Tutorial

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

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

  • @SimonSezIT
    @SimonSezIT  Год назад +2

    🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

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

      I like this video and comment, I’m from Vietnam and you?❤❤❤

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

      these links are not for files...they seem to link to more videos. do you have a link to files to download please? Thank you

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

      Could you please tell us where is the Link for the practice files?

    • @AbdiAliOsman-k7g
      @AbdiAliOsman-k7g 14 дней назад

      I have been looking for it around months ​@@noorn7129

  • @Jollygood-br5pd
    @Jollygood-br5pd 9 месяцев назад +17

    No one explains Excel like this lady. Having taken excel training at work,school and other RUclips videos over the years I can honestly say she is just awesome!

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

      Thank you so much for your kind words! I'm glad you found the Excel tutorials helpful. 😊
      🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

  • @negueisaackone6051
    @negueisaackone6051 9 месяцев назад +5

    Many thanks to you. I have now became an expert in excel thanks you.

  • @JKelvinFallah
    @JKelvinFallah 11 месяцев назад +8

    This lady is the best Too much respect

    • @SimonSezIT
      @SimonSezIT  11 месяцев назад

      Thanks for the kind comments 🙂
      🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

  • @ferrywobma1836
    @ferrywobma1836 11 месяцев назад +2

    I would like to express my compliments for the clear explanation, but also for the wonderfully calm and clear pronunciation of the lady who explains the formulas. As a Dutchman, it is just as easy for me to follow as if it were spoken in my own language. Thanks.

    • @SimonSezIT
      @SimonSezIT  11 месяцев назад

      Thank you so much for your kind words! I'm glad to hear that the explanation and pronunciation were clear and easy to follow for you. It's always my goal to make my content accessible to viewers from all over the world. Thank you for your support! 😊
      🔥Check out our FREE 300+ hour training course playlist here 👉
      ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

  • @grahamjarman6356
    @grahamjarman6356 11 месяцев назад +1

    Many thanks Deborah, this helped me with the formula I needed, using the nested if statement but also because the field I was using was a text field I also needed to use the right function.

    • @SimonSezIT
      @SimonSezIT  11 месяцев назад

      I'm glad I could help you with the formula! Nested if statements can be really powerful in Excel, especially when combined with other functions like RIGHT. Keep up the great work!
      🔥Check out our FREE 300+ hour training course playlist here 👉
      ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

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

    @1:26:00 xlookup , is there way so that whatever is displayed in formula , same corresponding value is displayed in revenue-example if $1166 is displayed in profit then 17900 will display in revenue and not 50000

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

    Well developed and easy to follow and comprehend. I need the data sheets in order to practice.

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

      This training is part of the complete set of courses we offer at Simon Sez IT www.simonsezit.com/courses/

  • @abhishekbaunthiyal7339
    @abhishekbaunthiyal7339 11 месяцев назад

    I appreciate the clarity with which you explain concepts. I would like to offer a suggestion, if possible. It would be beneficial if you could include the data files, allowing everyone to practice the same techniques demonstrated in the video.

    • @SimonSezIT
      @SimonSezIT  11 месяцев назад

      Great suggestion! Thank you :-)

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

      I do request for the same.

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

    this tutorial is so cooll..thanks a alot

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

    Itis worthy mentioning that you are using comparison operators with the logical functions. With sum and average functions, you have used the arthimetic operators addition (+) and division (÷).

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

    Wow! For the first time i have learnt the excel logic Thank you very much!

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

      You are very welcome! Thanks for watching 🙂
      🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
      & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

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

    Can you provide same excel worksheets for practice , its realy helpful.

  • @susanmorris1007
    @susanmorris1007 Год назад

    Great tutorial. Thanks.

    • @SimonSezIT
      @SimonSezIT  Год назад +1

      You are very welcome! Thanks for watching 🙂
      🔥Check out our FREE 300+ hour training course playlist here 👉
      ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

  • @goodman-it2qy
    @goodman-it2qy Месяц назад

    I thank you very much you made it's very much extremely.

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

      Wow, thanks! Glad it was helpful. 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

  • @PriyankaDroach-du2yb
    @PriyankaDroach-du2yb 7 месяцев назад

    You are an amazing explainer

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

      Thanks for the kind comment 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
      ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

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

    superb teaching. The entire video is full of knowledge for the excel lovers, but one thing which this video is lacking that no download file has been provided for the students to do exercises by themselves. Excel requires practice and these exercises would be very fruitful if provided.

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

      Wow, thanks a lot 😊 We have additional free Excel training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

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

    video was awesome please provide me the link so that i can practise.

  • @rajeevgosavi4514
    @rajeevgosavi4514 11 месяцев назад

    Excellent Tutorial. Basics coverage is very professional and superb. Would have been of additional help, had you provided a link to download spreadsheets to follow along.

    • @SimonSezIT
      @SimonSezIT  11 месяцев назад

      Great suggestion!

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

      @@SimonSezIT Love the trainings too, would you please add the practice files for all of us asking for them? It's greatly appreciated.

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

    Why is it difficult for you to assist us with the practice files!!!We really need it.

    • @damilolafulani1836
      @damilolafulani1836 17 часов назад

      I wonder why it's so difficult to provide the files too. It takes practice to master Excel

  • @SiminLotfjou-e4m
    @SiminLotfjou-e4m 5 месяцев назад

    Can I have the practice file?

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

    nice

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

      Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
      ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

  • @AbdiAliOsman-k7g
    @AbdiAliOsman-k7g 15 дней назад

    Please how to get the file of this lessons?

    • @SimonSezIT
      @SimonSezIT  10 дней назад

      This training is part of the complete set of courses we offer at Simon Sez IT. ✅ Get a free 14-day trial with unlimited access to 200+ courses, details here 👉 simonsezit.lpages.co/ssit-14-day-free/

  • @AbdiAliOsman-k7g
    @AbdiAliOsman-k7g 8 месяцев назад

    How to get the file for this lessons

  • @adamtabor6754
    @adamtabor6754 Год назад +1

    Exersise file ? 🤔

  • @arifuzzamansumon6865
    @arifuzzamansumon6865 11 месяцев назад

    Please provide practice file.

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

    CAN WE GET THE FILES TO PRACTISE PLEASE ?

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

      This training is part of the complete set of courses we offer at Simon Sez IT www.simonsezit.com/courses/

  • @soundaryasuresh1845
    @soundaryasuresh1845 Год назад +3

    Practice file pls

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

    Yes, i was expecting files to practice as well. Not going to watch it as it doesnt have files. Thats the first thing i look at .. thanks though

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

    Do you have time for a question right now?

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

    Data set link please

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

      This training is part of the complete set of courses we offer at Simon Sez IT www.simonsezit.com/courses/

  • @mkgeidam
    @mkgeidam Год назад

    Thanks for sharing. @SimonSez

    • @SimonSezIT
      @SimonSezIT  Год назад

      You are very welcome! Thanks for watching 🙂
      For more information about Simon Sez IT courses, visit:
      SimonSezIT.com: www.SimonSezIT.com/
      Stay in touch!
      RUclips Channel: www.youtube.com/@SimonSezIT
      LinkedIn: www.linkedin.com/company/simon-sez-it/
      Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
      ♥️ We appreciate your support!