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

[@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!

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

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

[@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!

[@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!

[@nabibadakhsh183]

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

[@segunakiode]

Great to hear! 🙂

[@muliyechuula9098]

Very grateful down here in Zambia 🇿🇲👏

[@segunakiode]

@Muliye Chuula - much love from Nigeria 🇳🇬 🙂

[@IbrahimIdowu-n8i]

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

[@segunakiode]

Thank you!

[@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. 🙂

[@hishamelbadawy6893]

Thank you so much, Greetings from Egypt

[@segunakiode]

So nice of you! Thanks 🙂

[@syedasfandshah7806]

Your videos are awesome. Keep up the good work.

[@segunakiode]

Glad you like them!

[@ayobamiotitoju7455]

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

[@segunakiode]

Thank you too!

[@lorenzotyler456]

Incredible tutorial!

[@segunakiode]

Glad it was helpful!

[@emmanuelemakhu6081]

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

[@segunakiode]

@Emmanuel Emakhu - glad to be value. Thanks 😊

[@gemmakatrina7986]

Amazing! This was super helpful, much appreciated

[@segunakiode]

Glad to know!

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

[@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!

[@dkkids9779]

Thanks for the sharing Sir!

[@segunakiode]

@DK KIDs - thanks 🙂

[@reema8635]

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

[@segunakiode]

Glad to hear that!

[@jijoshmohan7356]

U are Awesome Great Inputs rendered

[@segunakiode]

Glad you think so!

[@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!

[@botolbekas6399]

Thanks man. Really appreciate it

[@segunakiode]

Glad it helped!

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

[@rubyruby7370]

Really appreciate Support all the way

[@segunakiode]

You are welcome!

[@thapelomokgweetsi4396]

wooow.... well explained

[@segunakiode]

Glad it was helpful!

[@bozenaewertowska2203]

Thank you.

[@segunakiode]

You're welcome!

[@adunolaaboaba6415]

Thank you so much

[@segunakiode]

@Adunila Aboaba - You're most welcome!

[@elizabethmwangi5720]

wow. very interesting.

[@segunakiode]

Glad to know. Thanks!

[@ashag5989]

Please provide heat map chart by hr

[@segunakiode]

I will add this to my video content calendar.

[@remialliu4385]

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

[@segunakiode]

I do not offer such training at the moment.

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

[@ragheids]

Very good

[@segunakiode]

@Ragheid Saaeid - thanks! 🙂

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

[@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. 🙂

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

[@segunakiode]

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

[@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! 🙂

[@gabrielbusari2211]

I can't find the sample dataset

[@segunakiode]

Kindly access it here - segunakiode.com/download

[@yaminispuranik5281]

hi Iam unable to download the practice file

[@segunakiode]

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.

[@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!

[@nicheoftruth1]

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

[@segunakiode]

Your question is unclear. Can you rephrase?

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

[@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!