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

In today's video - 'How to Create HR Reports Using Excel' - I taught a valuable skill for HR professionals, and anyone interested in HR analytics. Excel is a powerful tool that can simplify the process of data analysis and reporting. It is also very critical for HR Reports. Download the practice file here - segunakiode.com/hrreportinexc... #hranalytics #excel
📌 Sign-up for my "HR Analytics Using Excel For Beginners Udemy Course" here: segunakiode.com/hranalytics
⏰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
📌Do you need someone to talk to as regards your career aspirations? You can book a FREE 30-mins Career Clarity Session with Segun Akiode with this link: segunakiode.com/clarity-call/
📲 Remember to subscribe to my channel ‪@segunakiode‬ for more videos.
🎀You may be interested in the following Human Resources Insights Episodes:
📌 How To Create HR Report For Beginners - • How To Create HR Repor...
📌 How To Make HR Report Using PivotTable in Excel - • How To Make HR Report ...
📌 Key Excel Features For HR Analytics - • Excel For HR Analytics...
📌 How To Create An HR Dashboard in Excel - • How To Create An HR Da...
★☆★ CONNECT WITH ME ON SOCIAL MEDIA ★☆★
🐦Twitter: - @segunakiode - / segunakiode
📸 Instagram: - @segunakiode - / segunakiode
🎙️ Podcast: anchor.fm/segunakiode
🌍 Website: segunakiode.com

[@adminug7878]

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

[@segunakiode]

Thank you for your kind words.

[@adeolamichael8837]

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

[@segunakiode]

I am glad you found my videos valuable!

[@Kayla-wi3lf]

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

[@segunakiode]

Glad you think so! Thank you!

[@yusuflawal8591]

Good Job, its indeed awesome. Thank you.

[@segunakiode]

Glad you found the video awesome!

[@only_nene1]

you've gained a new subbie 👍

[@sundayfaithy]

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

[@segunakiode]

I am glad you found the video insightful!

[@souviksahoo4528]

Thank you for give nice video

[@segunakiode]

Glad the video was helpful.

[@aminatasygp3313]

Amazing video, it was very helpful!

[@segunakiode]

Glad the video was helpful!

[@aminatasygp3313]

​​@@segunakiodedo you have a phone number or email address where I Can contact you ?

[@ifeanyiohaka8097]

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

[@segunakiode]

Great!

[@ifeanyiohaka8097]

Yah

[@d5379]

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

[@segunakiode]

Thank you! I will recommend a previous video I did on Using Pivot Table for HR Data Analysis. You can watch it using this link - kzbin.info/www/bejne/m5-lqp9metqLZ6c

[@d5379]

@@segunakiode thanks a lot 🙏

[@ayenidamilola2071]

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

[@segunakiode]

Download the practice file here - segunakiode.com/hrreportinexcel2023

[@sabiboi93]

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?

[@segunakiode]

📌 Sign-up for my "HR Analytics Using Excel For Beginners Udemy Course" here: segunakiode.com/hranalytics

[@ifeanyiohaka8097]

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.

[@segunakiode]

You can try Chartered Institute of Personnel Management of Nigeria (CIPM).

[@ibisojack3653]

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.

[@segunakiode]

It is your Excel and Computer Memory issue. You can restart your computer and try it again.

[@ifeanyiohaka8097]

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

[@segunakiode]

You can book a FREE 30-mins Career Clarity Session with Segun Akiode with this link: segunakiode.com/clarity-call/

[@ifeanyiohaka8097]

Thank you very much and God bless.@@segunakiode

[@prakveasna010]

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

[@segunakiode]

You can download the practice file here - segunakiode.com/hrreportinexcel2023

[@prakveasna010]

thank you so much for you sharing come to me 🙏🙏@@segunakiode

[@ifeanyiohaka8097]

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

[@segunakiode]

Thank you. I am good!

[@ifeanyiohaka8097]

Alright. very soon i will be reaching out to you @@segunakiode

[@ifeanyiohaka8097]

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

[@segunakiode]

You can book a FREE 30-mins Career Clarity Session with Segun Akiode with this link: segunakiode.com/clarity-call/

[@ifeanyiohaka8097]

I can't find any date in November. it says no times in November @@segunakiode

[@ifeanyiohaka8097]

i will equally li9ke to know if you have any WhatsApp group so that i can join .i need to have a call with you@@segunakiode

[@ifeanyiohaka8097]

Please i really need a guide from you since you are very experienced and vast in HR.@@segunakiode

[@ifeanyiohaka8097]

like HR Mentorship group, training, institute etc i really need it badly for my personal development@@segunakiode