How To Make HR Reports Using Excel | HR Analytics in Excel

[@segunakiode]

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

[@LinLin2084]

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.

[@segunakiode]

@Lin K - thank you for your kind words!

[@only_nene1]

Wow thank you sir. I'm sleeping on this channel. Thank you very much. You're a very good teacher.

[@segunakiode]

Glad you enjoy it!

[@AJ-fd3yj]

this is done so well! thank you for sharing your valuable knowledge for free with us youtube-lurkers!

[@segunakiode]

Glad you enjoyed it!

[@olamidediamond]

This video has simplified work for me. Thank you @Segun Akiode

[@segunakiode]

Glad it was helpful!

[@dorinekanguha224]

Woow woow, i really appreciate the lessons. Am so happy to have come across your youtube.

[@segunakiode]

Glad you found the video very valuable. Thanks 😊

[@rubyruby7370]

Is really helpful for new HR and glad to know this

[@segunakiode]

@Ruby Ruby - I am glad the video is helpful to you!

[@victorious9491]

At last, I've found what I've been looking for. Thank you for this video 👌🏽

[@segunakiode]

@Victorious - I am so glad you found this video and it was helpful to you. 😊

[@otshepengtshepi8709]

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

[@segunakiode]

@Otshepeng Tshepi - I am so glad to hear that the video made your HR dashboard creation process easier. I wish you all the best! 🙂

[@chidieberenzeakuba6395]

Very insightfull. Thank you so much.

[@segunakiode]

Glad you enjoyed it!

[@morenikeadedeji4051]

Thanks. Very insightful 👏 👌

[@segunakiode]

I am glad you found it insightful.

[@profmartinCA10]

Segun, nice one. Well done!

[@segunakiode]

Thank for your kind words. 🙂

[@elnur.musayev]

Very very very thank’s from Baku. Azerbaijan! 😊

[@segunakiode]

Thank you too!

[@johnpatterson1154]

thanks a lot ! very easy to follow and great learning

[@segunakiode]

@John GingerPat - I am glad it was helpful! 🙂

[@zeyadalkuheli9815]

Well done, that's what I was looking for Thank you so much🌹

[@segunakiode]

@Zeyad Alkuheli - I am glad the video was helpful! 🙂

[@eniolaajayi8268]

Wow!!!!! Very educative.....Thank you

[@segunakiode]

@Eniola Ajayi - awesome! 🙂

[@aziz6109]

I appreciate ur efforts encompassing almost every aspect of HR, would u pls consider making a video on L&D?

[@segunakiode]

@Aziz UL Hassan - thanks! 🙂 I will add a video on L&D to my video content calendar.

[@yusuftijani236]

Very well broken down. Keep up the good work, Sir.

[@segunakiode]

Thank you for your kind words and for watching!

[@RootsEastern]

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

[@segunakiode]

@RootsEastern - thank you for your kind words. Glad the video was beneficial to you.

[@1qtaz]

Can you offer a non-music version?

[@prettydiva595]

Quite enlightening. Thank you.

[@segunakiode]

You are welcome!

[@benitaumenzeh6081]

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 🥳

[@segunakiode]

@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" (kzbin.info/www/bejne/qKqXfouLZZKJp8U)

[@benitaumenzeh6081]

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.

[@beeoby]

Thank you so much boss

[@segunakiode]

Most welcome.

[@Priscillasings_]

Thanks so much

[@segunakiode]

You're welcome!

[@aliciafrancis7053]

Thanks much. Excellent

[@segunakiode]

Glad it was helpful!

[@mavisawuah6841]

Very informative.

[@segunakiode]

@Mavis Awuah I am glad you liked it!🙂

[@hyderngina1029]

good job God bless'

[@segunakiode]

Thanks!

[@rubyruby7370]

Very powerful

[@segunakiode]

Thanks!

[@zeyadalkuheli9815]

Can you make a video about how to evaluate employee's performance?

[@segunakiode]

@Zeyad Alkuheli - I have videos on Performance Management on my channel. Check How To Conduct Performance Management - kzbin.info/www/bejne/l5rbaZqvoKeVhtk and How To Set Performance Measures That Is Objective - kzbin.info/www/bejne/rZ7Hp5JqlLB8hs0

[@sylviaosasolajide1928]

Thank you sir

[@segunakiode]

Thank you too.

[@GreenchaserMusic]

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

[@segunakiode]

Thank you for the feedback 🙂

[@hiuhiu714]

You try to give the video more brightness it will be great if you do

[@segunakiode]

Thank you!

[@kalypsotrigger]

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?

[@segunakiode]

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

[@kalypsotrigger]

@@segunakiode Thank you so much!

[@rachealmaduagwu7398]

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?

[@segunakiode]

@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" - kzbin.info/www/bejne/fGXNaYKwj8SUeZo

[@buthynahmanaa2166]

I can not focus BCS of the music!!!

[@segunakiode]

Sincere apologies. The background sound has been corrected in subsequent videos.

[@ebenzershroff5354]

This is not hr reporting it's jjust presentation

[@segunakiode]

I am not sure I understand what you mean.