I truly appreciate what you are doing on HR. Honestly, you're giving HR the professional aspect it carries and the value we bring to business. These reports are typically what would assist business in making certain key decisions Thank you.
This as really helpful sir you explained in the simplest way one could understand . i am an information management graduate and now i have to create an Hr dashboard/report i was so stressed but im good now. thanks again
How do I begin to thank you for your videos which is helping my young growing HR career. I am truly blessed to have found you on YT. Thank you sir. Please i would like to know how you calculated the attrition rate. Thank you sir and Happy birthday in arrears 🥳
@Benita Umenzeh - thank you for your kind words. 🙂 To your question - I did another video that covered the attrition calculation. Click here to watch - "How To Calculate HR Metrics in Excel" (th-cam.com/video/ry4MXU0-Vqc/w-d-xo.html)
Sir, I have a question on staff performance. If there is a noticeable decline in performance and productivity of staff what solution can be implemented to address the decline. I’d really appreciate a response. Thank you sir.
brother your videos are great but the music is unnecessary and distracting. very helpful videos however I am a complete novice to excel and your videos have helped a lot
@Zeyad Alkuheli - I have videos on Performance Management on my channel. Check How To Conduct Performance Management - th-cam.com/video/aix8gykBbPw/w-d-xo.html and How To Set Performance Measures That Is Objective - th-cam.com/video/wmdv_4_KIPk/w-d-xo.html
Very informative video. Thank you so much. What type of graph/chart would you suggest using say if you had to report on attrition rate over several years, for both men and women for example?
@Kalypsotee - glad you found the video informative. To your question - use a line graph as it would represent Attrition changing with time (in this case years). Hope that answers your question?
At 12.25 you said employee gender distribution but wrote employee age distribution... Its no biggie, but it is something that would confuse an intern at the job or a new employee if they came across it. I guess the lesson here is to proof read your material when finishing up your excel projects... Thanks for the video.. Im a huge fan and watch all can...
My question will be around linking an excel data sheet to the visuals, so once the source data sheet is update so does the visualization. Can this be done in excel? Or the visuals have to be updated per time?
@Racheal Maduagwu - your question is related to creating a dynamic HR Dashboard that changes with data refresh. You will need the knowledge of PivotTable to get this done. I did a video on this, watch it here:- "How To Create An HR Dashboard in Excel" - th-cam.com/video/F4j8OzZ_aC8/w-d-xo.html
![How to Create HR Reports Using Excel [UPDATED] | HR Analytics in Excel](http://i.ytimg.com/vi/oDWF_dUbUyE/mqdefault.jpg)
![How to build an Interactive HR Dashboard in Excel | HR Analytics in Excel [2024]](http://i.ytimg.com/vi/0IFYY7a5pAo/mqdefault.jpg)
📌 Remember to drop a comment and to subscribe.
📌 Download the slides and practice file here - segunakiode.com/ytresources
Wow thank you sir. I'm sleeping on this channel. Thank you very much. You're a very good teacher.
Glad you enjoy it!
I truly appreciate what you are doing on HR. Honestly, you're giving HR the professional aspect it carries and the value we bring to business. These reports are typically what would assist business in making certain key decisions Thank you.
@Lin K - thank you for your kind words!
This video has simplified work for me. Thank you @Segun Akiode
Glad it was helpful!
this is done so well! thank you for sharing your valuable knowledge for free with us youtube-lurkers!
Glad you enjoyed it!
Very very very thank’s from Baku. Azerbaijan! 😊
Thank you too!
Woow woow, i really appreciate the lessons. Am so happy to have come across your youtube.
Glad you found the video very valuable. Thanks 😊
Very insightfull. Thank you so much.
Glad you enjoyed it!
Wow!!!!! Very educative.....Thank you
@Eniola Ajayi - awesome! 🙂
Thanks. Very insightful 👏 👌
I am glad you found it insightful.
Is really helpful for new HR and glad to know this
@Ruby Ruby - I am glad the video is helpful to you!
Segun, nice one. Well done!
Thank for your kind words. 🙂
good job God bless'
Thanks!
Very powerful
Thanks!
Thank you so much boss
Most welcome.
thanks a lot ! very easy to follow and great learning
@John GingerPat - I am glad it was helpful! 🙂
Thanks much. Excellent
Glad it was helpful!
Very informative.
@Mavis Awuah I am glad you liked it!🙂
Quite enlightening. Thank you.
You are welcome!
Thank you sir
Thank you too.
At last, I've found what I've been looking for. Thank you for this video 👌🏽
@Victorious - I am so glad you found this video and it was helpful to you. 😊
This as really helpful sir you explained in the simplest way one could understand . i am an information management graduate and now i have to create an Hr dashboard/report i was so stressed but im good now. thanks again
@Otshepeng Tshepi - I am so glad to hear that the video made your HR dashboard creation process easier. I wish you all the best! 🙂
Well done, that's what I was looking for
Thank you so much🌹
@Zeyad Alkuheli - I am glad the video was helpful! 🙂
Thanks so much
You're welcome!
Very well broken down. Keep up the good work, Sir.
Thank you for your kind words and for watching!
I appreciate ur efforts encompassing almost every aspect of HR, would u pls consider making a video on L&D?
@Aziz UL Hassan - thanks! 🙂
I will add a video on L&D to my video content calendar.
How do I begin to thank you for your videos which is helping my young growing HR career. I am truly blessed to have found you on YT.
Thank you sir.
Please i would like to know how you calculated the attrition rate.
Thank you sir and Happy birthday in arrears 🥳
@Benita Umenzeh - thank you for your kind words. 🙂
To your question - I did another video that covered the attrition calculation. Click here to watch - "How To Calculate HR Metrics in Excel" (th-cam.com/video/ry4MXU0-Vqc/w-d-xo.html)
Sir, I have a question on staff performance.
If there is a noticeable decline in performance and productivity of staff what solution can be implemented to address the decline.
I’d really appreciate a response.
Thank you sir.
brother your videos are great but the music is unnecessary and distracting. very helpful videos however I am a complete novice to excel and your videos have helped a lot
@RootsEastern - thank you for your kind words. Glad the video was beneficial to you.
Can you offer a non-music version?
Can you make a video about how to evaluate employee's performance?
@Zeyad Alkuheli - I have videos on Performance Management on my channel. Check How To Conduct Performance Management - th-cam.com/video/aix8gykBbPw/w-d-xo.html and How To Set Performance Measures That Is Objective - th-cam.com/video/wmdv_4_KIPk/w-d-xo.html
Very informative video. Thank you so much. What type of graph/chart would you suggest using say if you had to report on attrition rate over several years, for both men and women for example?
@Kalypsotee - glad you found the video informative.
To your question - use a line graph as it would represent Attrition changing with time (in this case years).
Hope that answers your question?
@@segunakiode Thank you so much!
At 12.25 you said employee gender distribution but wrote employee age distribution... Its no biggie, but it is something that would confuse an intern at the job or a new employee if they came across it. I guess the lesson here is to proof read your material when finishing up your excel projects... Thanks for the video.. Im a huge fan and watch all can...
Thank you for the feedback 🙂
My question will be around linking an excel data sheet to the visuals, so once the source data sheet is update so does the visualization. Can this be done in excel? Or the visuals have to be updated per time?
@Racheal Maduagwu - your question is related to creating a dynamic HR Dashboard that changes with data refresh. You will need the knowledge of PivotTable to get this done.
I did a video on this, watch it here:- "How To Create An HR Dashboard in Excel" - th-cam.com/video/F4j8OzZ_aC8/w-d-xo.html
You try to give the video more brightness it will be great if you do
Thank you!
I can not focus BCS of the music!!!
Sincere apologies. The background sound has been corrected in subsequent videos.
This is not hr reporting it's jjust presentation
I am not sure I understand what you mean.