How to Create HR Reports Using Excel [UPDATED] | HR Analytics in Excel

⏰Timestamps
0:00 - Introduction
0:37 - The Basics of HR Data Collection
1:07 - Common Excel Charts for HR Reports
2:40 - Practical Session: Creating HR Reports in Excel
5:24 - Simple HR Report - Workforce Age Distribution
8:48 - Simple HR Report - Employment Sources Summary
11:55 - Simple HR Report - Performance Scores Summary

📲 Remember to subscribe to my channel @segunakiode for more videos.

🎀You may be interested in the following Human Resources Insights Episodes:

★☆★ CONNECT WITH ME ON SOCIAL MEDIA ★☆★

[adminug]

Segun u are God sent to support us. Whatever motivates you to support us for free only God knows thank you 🙏

[adeolamichael]

I always look forward to your videos, it has been very educational.

[sundayfaithy]

So insightful. I'll be glued to your page henceforth

[yusuflawal]

Good Job, its indeed awesome. Thank you.

[Kayla-wilf]

your channel is so helpful!!! thanks so much.

[d]

Thank you Segun. Very helpful. I have a question: how we make data sheet with employees numbers per gender and location via pivot table and graph. Like all in one data report. Thanks a lot

[ayenidamilola]

This is very helpful and educative. Could you please reshare the practice file link, the attached link is not opening. Thank you.

[ifeanyiohaka]

I have all your videos with me. I have downloaded all your HR Videos

[sabiboi]

Just came across your profile now.. Well done sir... I want to learn HR Analytics but I have no experience.. How can we connect sir?

[ibisojack]

Hello sir, I don't know if I missed a step, but once I click summarise with pivot table it brings an error prompt that said “ Excel cannot complete this task with available resources. Choose less data or close other applications.

[ifeanyiohaka]

I need a HR Mentorship group or institute where i can learn some HR Practical application, on how to design HR Policies, Strategy, Compensation and Benefit that are required in HR. Please i need your help in connecting me to any of these HR Institute or Consultancy firm where i can pay and learn more about practical application of HR Functional area.

[muliyechuula]

Sir, what can i say, this Zambian HR girl is your forever student💯👌👌👌👌👌👌👌👌👌👏👏👏👏👏👏👏👏👏👏

[prakveasna]

Hello there, I'm Veasna; could you please to share excel file come me? I'm really interesting with your lesson and i try to earn learning form you too Guy❣🌻🌻, thanks you, best bless too

[ifeanyiohaka]

good Moring Segun Akiode, pls i need to chat you personally.

[ifeanyiohaka]

its being awhile. I have not been seeing your videos for awhile now. hope you are good?

[ifeanyiohaka]

Thank you and God bless. i will need your contact and your email address too.