How To Calculate HR Metrics in Excel | HR Analytics in Excel

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

КОМЕНТАРІ • 52

  • @segunakiode
    @segunakiode  3 роки тому +3

    Remember to drop a comment and to subscribe.
    Download the practice file here - segunakiode.com/ytresources

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

      link is not working can you please send me this file at faizanali8535@outlook.com

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

      @@fatalks2939 apologies as the link was broken.
      Kindly click here to access the file - segunakiode.com/ytresources

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

      @@segunakiode you are such a kind person brother thank you

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

      @@fatalks2939 thank you for your kind words.

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

      @@segunakiode I am also a HT Generalist in my company & your insightful videos are helping me alot
      Love from Pakistan

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

    Thank you very much. I learned many things.... about human resource management.

  • @emekaokonkwo4804
    @emekaokonkwo4804 3 роки тому +2

    This was really explanatory. Thank you, Segun

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

      @Chukwuemeka Okonkwo - I am glad you got value from the video. 🙂

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

    Many thanks for the insightful and educative works.
    Please, can you help with the calculation (formulas) for workforce age distribution and the "what if" statement. I have listened to it several times but still need the know how of the working formula.
    Many thanks once again.

    • @segunakiode
      @segunakiode  7 днів тому

      I will be releasing another video to explain IF Statements in details.

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

    Thanks boss for your consistent updates.

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

      Thank you for your kind words. I am encouraged to keep at it. 😎

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

    Great explanation 👌 thank you so much

    • @segunakiode
      @segunakiode  2 роки тому

      @A Madeeyo - Glad it was helpful!

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

    Really a insightful video

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

      @Sagar Gurung - glad it was!

  • @ArifRahman-te9je
    @ArifRahman-te9je 3 роки тому +1

    nice share mate, thanks

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

      @Arif Rahman - Thank you for watching! 🙂

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

    Thank you for sharing..

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

    Goodmorning Segun. I am most grateful for all your videos.
    I reside in Lagos. Do you have a school where all of these is taught in person and certificate issued to participants at the end of the training.

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

      @Randel Abundance - yes we have an Academy that offers Human Resources Courses and we issue training certificates.
      You can check here for details - crescitahcl.com/academy

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

    Insightful

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

    Thank you sir..plz make videoes on HR metrics

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

      I did another video on "7 HR Metrics To Track", watch it here - ua-cam.com/video/pwmDsUTmeV0/v-deo.html

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

    Hello.....could you please make some videos on attrition report and absenteeism report and other report like 4Q.

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

      @Shilpi Shrivastava - your request would be looked into. Thanks.

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

    Thank you

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

    Here you explained Common HR metrics but for me calculating HR metrics you must consider certain factors such as employee attendance, Benefits, Compensation and salary, employee relations, and others

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

      @Khalid Mohamud - thank you for the feedback. Another video was dedicated to Key HR Metrics HR should track. You can watch it here - ua-cam.com/video/pwmDsUTmeV0/v-deo.html

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

    Thanks for sharing.

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

      Thank you for watching!

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

      @@segunakiode It will be of honour if you can enlighten us on staff welfare. Thank you.

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

      @@funmimajorfunmimajor9955 any particular staff welfare topic in mind?

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

      @@segunakiode Generally as regards staff welfare, Apart from accurate payment of salary. Thank you

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

      @@funmimajorfunmimajor9955 well noted.

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

    Hello segun.
    Please tell how to measure the quality of hire metrics .

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

      This is often measured months after hiring, using various indicators like new hire performance metrics, turnover, and retention rates.

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

    What's the difference between turnover rate and attrition rate? Or are they the same.

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

      Hello Francis, both are often used synonymously, as they both occur when an employee leaves the company.
      The major difference is a technical one (read it here - talexes.com/blog/employee-attrition-vs-employee-turnover-whats-the-difference/).

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

    How to download the excel sheet, thanks

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

      @Raksha Tak - you can download the practice Excel file here - segunakiode.com/ytresources

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

    informative. pls remove background music

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

      @Sathik Ali - thank you for the feedback. This has been corrected in newer videos.

  • @elaineg5749
    @elaineg5749 3 роки тому +2

    Why do you need music in the background? This is not inclusive to cater for all your audience

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

      @Elaine G - apologies for your experience with the background music. Your feedback is well noted.

  • @tutsecret499
    @tutsecret499 11 місяців тому

    Your music is interfering with your explanations. I can't focus on you, the music is distracting very loud and unecessary

    • @segunakiode
      @segunakiode  11 місяців тому

      Thank you for the feedback. This has been corrected in subsequent videos.