Employee Performance Rating Card and Dashboard in Excel

#exceltemplates #exceldashboardstutorial #exceldashboard
Hello Friends,

Welcome to our step-by-step tutorial on how to create and use an Employee Performance Rating Card and Dashboard in Excel. If you're a manager, HR professional, or a small business owner, this video is your ultimate guide to simplifying and enhancing your performance evaluation process.

Explore our exclusive collection of premium digital products:

Our Course of Excel Pivot Tables for Data Analysis: Basic to Advanced:

Download this template file from below link:

00:22 Employee Performance Rating Card and Dashboard
02:23 How to Refresh dashboard.
02:59 Create Grid Sheet
03:19 Create Score Card Sheet
05:53 How to add Drop-down list for ✔and ✖
07:24 How to use conditional Formatting for ✔and ✖
08:35 How to create formula for Score and Rating
09:37 Create Pivot Tables in Pivot Sheet
12:07 Creating the Dashboard Sheet
18:28 Wrap UP

Subscribe our new YouTube Channel:

Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

LinkedIn:

Twitter:

Instagram:

Visit our Amazon Store

[payalkaswate]

Can you please explain the performance score formula it's showing error, kindly update, if you are providing a detailed video than also make sure to update the formula base correctly if their is anything missing or we can't help it out, you should suggest us. That's the real knowledge Sir, all of the above things are really brilliant, let us know the formula that could be used by many people❤

[سُندٍسٌ-ود]

Just followed this guide to create my own dashboard. I've also been trying out the Astirna New Tab extension, which helps me keep everything in one place. Definitely worth checking out.

[aminaghosh]

Rating isn't coming correctly, rest all I did following your guidance from this video, can you please suggest or advise where I may be making mistake. Thank you

[pandharinathjoshi]

Sir superb sir

Very unique voice sir
Very neat explanation in details sir

Sir make more like dashboard videos sir

Excellent…Excellent sir💐💐💐💐

[chalkycloud]

Hi. Please make a playlist of all HR related tools and videos so i can watch together. Your videos are very informative and easy to understand and explained in an easy way.

[yunablu]

you are so good at what you do..thank you sir for sharing..

[abdullahquhtani]

Great 👍🏼. I hope you could do report like this for ZkTeco attendance management report that most companies use.
Thank you

[sumardjo]

Thanks for tutorial
with a sample file
easy to follow
thanks

[cherryloubermas]

What formula should be used in the performance rating

[brittokhan]

8:43 I have doubt in the if formula and sum . It is confusing. Is this formula different in power pivo?
Does it work like sumproduct formula in excel

[dawarrior]

Nice Job Sir, keep up the good work 👍👍👍

[khristianaldana]

It's not free. But I gladly paid the $2.99. Is going to sabe me a lot of time. Thanks!

[dinahany]

thanks for the best project tutorial .. god bless u

[BlackThor]

Amazing, thank you for sharing! Do you have any video for the same kind of table but for a whole year but Month by Month?

[PauleenSevillano]

Thanks for the tutorial, it helped me a lot 😊

[uroobaahmed]

There's an error showing in my performance score formula😒

[prachigosavi-pd]

Hi, I followed the steps exactly, but the performance score formula is showing as incorrect. Can you provide a solution?

[nadag.youssef]

Thank you so much, but how do that for all months in one excel file?

[CFAthAve]

My question is this, there is a grading card for the supervisors but I would like to do is have a sheet pulling the average of the ratings for each employee by the supervisors and the comments each supervisor leaves. I was thinking the best function would be Vlookup? Am I wrong?

[karuqaster]

Hi, great video ! I am unable to download the template from the link provided. Please help!