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

[@omoegbeleghansolomon6903]

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]

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

[@silvestrecamposano6317]

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

[@segunakiode]

Glad it was helpful!

[@emekaokonkwo4804]

This was really explanatory. Thank you, Segun

[@segunakiode]

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

[@yusuftijani236]

Thanks boss for your consistent updates.

[@segunakiode]

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

[@amadeeyo8181]

Great explanation 👌 thank you so much

[@segunakiode]

@A Madeeyo - Glad it was helpful!

[@sagargurung4951]

Really a insightful video

[@segunakiode]

@Sagar Gurung - glad it was!

[@ArifRahman-te9je]

nice share mate, thanks

[@segunakiode]

@Arif Rahman - Thank you for watching! 🙂

[@gbenjoolufisayo9776]

Thank you for sharing..

[@segunakiode]

Thank you for watching 🙂

[@ehisobozele3486]

Insightful

[@segunakiode]

Thanks 🙂

[@chifumbonu]

Thank you

[@segunakiode]

@Chifu Mbanu 😊

[@meghagupta4235]

Thank you sir..plz make videoes on HR metrics

[@segunakiode]

I did another video on "7 HR Metrics To Track", watch it here - kzbin.info/www/bejne/pqjQdaaLidKYjJI

[@randelabundance4500]

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]

@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

[@shilpishrivastava8420]

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

[@segunakiode]

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

[@segunakiode]

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

[@fatalks2939]

link is not working can you please send me this file at [e-mail]

[@segunakiode]

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

[@fatalks2939]

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

[@segunakiode]

@@fatalks2939 thank you for your kind words.

[@fatalks2939]

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

[@funmimajorfunmimajor9955]

Thanks for sharing.

[@segunakiode]

Thank you for watching!

[@funmimajorfunmimajor9955]

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

[@segunakiode]

@@funmimajorfunmimajor9955 any particular staff welfare topic in mind?

[@funmimajorfunmimajor9955]

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

[@segunakiode]

@@funmimajorfunmimajor9955 well noted.

[@ashag5989]

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

[@segunakiode]

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

[@khalidmohamud5419]

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]

@Khalid Mohamud - thank you for the feedback. Another video was dedicated to Key HR Metrics HR should track. You can watch it here - kzbin.info/www/bejne/pqjQdaaLidKYjJI

[@francisabraham9102]

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

[@segunakiode]

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]

How to download the excel sheet, thanks

[@segunakiode]

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

[@sathikali4923]

informative. pls remove background music

[@segunakiode]

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

[@elaineg5749]

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

[@segunakiode]

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

[@tutsecret499]

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

[@segunakiode]

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