How To Create An HR Dashboard in Excel | FREE HR Dashboard INCLUDED | HR Analytics in Excel

[@swathidayalan-q5l]

I can't believe I finally learned how to create an HR dashboard in just 15 minutes! The explanations were incredibly simple and easy to understand-mind-blowing, actually. You are truly amazing. I'm binge-watching all your videos as I prepare for my interviews. I used to lack confidence in Excel, especially with HR reports, but you've made it a piece of cake. Thank you so much for your great work and KEEP ROCKING !

[@victoradeyemo8182]

I feel it would be unjust if I continue this... For some months now, I've been ghost watching your channel. I can't even remember how I stumbled on it. But, ever since I discovered it, it's been my favourite thing on KZbin for some time now. Most of your videos, I've watched at least twice. Some, I've watched at least 7 times. And I'm not even capping... I'm new into HR, switching into it from a science background. Your channel offers me a safe learning abode where I can learn unrestricted. Your videos are so simple and easy to understand. I've gotten so much value... All for free. There are so many concepts I've read in theory but never really understood until I watched a video you made on it. Thank you so much Segun for all you do. If no else is, I for one am grateful. Keep up the good work!!!

[@segunakiode]

@Victor Adeyemo - I appreciate your kind words greatly. I am encourage to keep creating valuable contents.

[@adeniranadesanya3499]

wow.. this is so resourceful, i am actually an IT professional trying to assist my HR department and your tutorial has greatly been of help. thank you, sir.

[@segunakiode]

Glad it was helpful!

[@jacksonjackson4532]

From Tanzania I appreciate how you scarifies your time to help us. GOD BLESS YOU

[@segunakiode]

You are so welcome! Glad to be of value.

[@ememnkamare]

Thank you! I have searched hard for an easy way to learn this, was just about to pay someone for it but you simplified it for free. I am grateful!

[@segunakiode]

@Emem Nkamare - wow, this is so encouraging to read. 😊

[@jacksonjackson4532]

@@segunakiode This man is so Grateful OOH God bless you

[@ndiprecious2572]

You make the whole process of HR journey so easy to navigate. I've downloaded all your videos and hoping to discover helpful insights to help me as a newbie HR personnel. Thank you for giving value.

[@segunakiode]

Glad to be of value!

[@reema8635]

👌👌 amazing this channel is very helpful for me ,i waching 1 st vidio

[@segunakiode]

Glad to hear that!

[@hishamelbadawy6893]

Thank you so much, Greetings from Egypt

[@segunakiode]

So nice of you! Thanks 🙂

[@Basmaaat]

I had to do this for a project and I was very nervous as I didn't know how to do it. Thanks to you it was easy. Much appreciated

[@segunakiode]

Great to hear!

[@IbrahimIdowu-n8i]

Thank you @Segun Akiode for this.. God bless and increase your wealth of skills

[@segunakiode]

Thank you!

[@syedasfandshah7806]

Your videos are awesome. Keep up the good work.

[@segunakiode]

Glad you like them!

[@nabibadakhsh183]

great man. very great information, clear explanation. really making my L&D job easier now. salut

[@segunakiode]

Great to hear! 🙂

[@ayobamiotitoju7455]

wow... you are good sir. thank you for this piece

[@segunakiode]

Thank you too!

[@muliyechuula9098]

Very grateful down here in Zambia 🇿🇲👏

[@segunakiode]

@Muliye Chuula - much love from Nigeria 🇳🇬 🙂

[@azeezadeola1356]

Oh God. I can't begin to thank you. You are the best.

[@segunakiode]

Glad it helped!

[@damilolaagbelusi6868]

Thank you for all you do Segun

[@segunakiode]

@Damilola Agbelusi - thank you for your kind words. 🙂

[@segunakiode]

📌Remember to drop your comment and to subscribe to my channel for more videos. 😀 📌Download the FREE HR Dashboard here - segunakiode.com/download

[@udochukwunwoha8974]

Super impactful. Thank you very much

[@segunakiode]

Glad it was helpful!

[@jacksonjackson4532]

Finally You help me to hit my target🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@segunakiode]

I'm glad you found the video valuable!

[@jacksonjackson4532]

@@segunakiode 👍 👍 👍

[@kzakundi1]

Much appreciated! Thank You

[@segunakiode]

You're welcome!

[@jijoshmohan7356]

U are Awesome Great Inputs rendered

[@segunakiode]

Glad you think so!

[@lorenzotyler456]

Incredible tutorial!

[@segunakiode]

Glad it was helpful!

[@samantmh]

You just refreshed my pivot table knowledge. Great job, thank you. Now only if the info would update in real time. Lol

[@segunakiode]

Glad it was helpful!

[@thapelomokgweetsi4396]

wooow.... well explained

[@segunakiode]

Glad it was helpful!

[@gemmakatrina7986]

Amazing! This was super helpful, much appreciated

[@segunakiode]

Glad to know!

[@dkkids9779]

Thanks for the sharing Sir!

[@segunakiode]

@DK KIDs - thanks 🙂

[@emmanuelemakhu6081]

Wow. This is awesome. Much thanks to you, you're always on point

[@segunakiode]

@Emmanuel Emakhu - glad to be value. Thanks 😊

[@bozenaewertowska2203]

Thank you.

[@segunakiode]

You're welcome!

[@elizabethmwangi5720]

wow. very interesting.

[@segunakiode]

Glad to know. Thanks!

[@botolbekas6399]

Thanks man. Really appreciate it

[@segunakiode]

Glad it helped!

[@only_nene1]

This channel is my HR school no cap😂😂. Thank you my Prof. Keep it coming pls🙏 my question is can this be used in replace mental of a HRIS software for a small company with head count of 20.

[@segunakiode]

Thank you for your kind words! Yes, this can be a temporary solution for an HRIS.

[@rodgersowoko]

Hi Segun. totally enjoying your videos. Unable to access the proactice file.

[@segunakiode]

Glad you enjoyed the videos. Kindly access the practice file here - segunakiode.com/download

[@adunolaaboaba6415]

Thank you so much

[@segunakiode]

@Adunila Aboaba - You're most welcome!

[@JaszMusiccFienn]

Hi, I am looking for the sample data set to follow along please ?

[@segunakiode]

📌Download the Sample Data and FREE HR Dashboard here - segunakiode.com/download

[@ragheids]

Very good

[@segunakiode]

@Ragheid Saaeid - thanks! 🙂

[@oluchianene8702]

great tutorial, Pls how do i access the dataset for learning. the current link isn't working

[@segunakiode]

Kindly check the download link in the video description.

[@rubyruby7370]

Really appreciate Support all the way

[@segunakiode]

You are welcome!

[@remialliu4385]

Hi, pls do you train on HRIS, Pls i am interested.

[@segunakiode]

I do not offer such training at the moment.

[@ashag5989]

Please provide heat map chart by hr

[@segunakiode]

I will add this to my video content calendar.

[@macramecottage1151]

Is it possible/ how could you add a sliver by date/month?

[@segunakiode]

Use the "Insert Slicer" option under PivotTable Analyse Tab.

[@piyushdayama6718]

what actual analysis is done in hr like correlation, regression or anova , will you explain the toolpack which is in excel in data analysis,........................................dashboard creation is easy but what to do if we need more analysis of a particular data

[@segunakiode]

@Piyush Dayama - Thank you for your suggestion. I will cover the Excel Analysis Toolpak for HR Analytics in a later video.

[@piyushdayama6718]

@@segunakiode please do it soon.....................eagerly waiting for a proper analysis video ....tool pack analysis for HR or if there is any other tool please do share, thank you for your contents but its only beginner level do you provide any advance level analysis.......

[@segunakiode]

@Piyush Dayama would do! 🙂

[@xlwatcher8885]

Where will the link to the sample data be sent? I don't have it in downloads or in my email.

[@segunakiode]

📌Download the Sample Dataset for the HR Dashboard here - segunakiode.com/download

[@segunakiode]

The instructions to download the dataset will be sent to your email.

[@xlwatcher8885]

@@segunakiode thank you!

[@RaasiUpadhyay]

hie segun, In my Excel I can't find the option pivot analyze and slicer both options What to do please help

[@segunakiode]

Which version of Excel are you using please?

[@RaasiUpadhyay]

@@segunakiode Microsoft excel 2007

[@segunakiode]

The video was done using Microsoft 365. Hence, the interphase is different from Excel 2007.

[@emmanuelnyanful1433]

Good work Sir. I can't find the the dataset.

[@segunakiode]

@Emmanuel Nyanful - thanks! You can download the FREE HR Dashboard here - segunakiode.com/download

[@macramecottage1151]

How do you add a date slicer?

[@segunakiode]

Use the "Insert Slicer" option under PivotTable Analyse Tab.

[@j.kelvinfallah]

Great work, brother. What app or camera do you use for your presentation?

[@segunakiode]

@J Kelvin Fallah - thanks 😊 To your question: for this video I used a Canon M50 with OBS Studio.

[@j.kelvinfallah]

It looks great. You are doing a great job. Thanks

[@segunakiode]

@@j.kelvinfallah thank you for your kind words. 🙂

[@nicheoftruth1]

How to use this dashboard always shows in desktop? Can u explain this?

[@segunakiode]

Your question is unclear. Can you rephrase?

[@yaminispuranik5281]

hi Iam unable to download the practice file

[@segunakiode]

You can download the FREE HR Dashboard here - segunakiode.com/download

[@gabrielbusari2211]

I can't find the sample dataset

[@segunakiode]

Kindly access it here - segunakiode.com/download

[@seyioladapo422]

👏👏👏👏👏👏👏

[@segunakiode]

Thanks!

[@jacksonjackson4532]

HELLOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO

[@segunakiode]

Hi

[@vanessaybanez6152]

I tried to confirm if no. of Baby Boomers is 4. Upon checking, using filter at Employee Data Sheet, Baby Boomers is actually 8, including female.

[@segunakiode]

I am not sure I get your question?

[@olawuyiadedayo3312]

PSeges you too much

[@segunakiode]

Thanks!