Employee Performance Rating Card and Dashboard in Excel

[@chalkycloud893]

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.

[@pandharinathjoshi6565]

Sir superb sir Very unique voice sir Very neat explanation in details sir Sir make more like dashboard videos sir Excellent…Excellent sir💐💐💐💐

[@PKAnExcelExpert]

Thanks and sure

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

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.

[@yunablu6241]

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

[@PKAnExcelExpert]

You are very welcome

[@Luciano_mp]

Nice dashboard, useful! Thank you.

[@PKAnExcelExpert]

Glad you like it!

[@sumardjo]

Thanks for tutorial with a sample file easy to follow thanks

[@PKAnExcelExpert]

Glad it was helpful!

[@smr8854]

Excellent and easy way explained,🙏

[@PKAnExcelExpert]

Thanks 🙏

[@stevenmalcoun]

amazing job PK

[@PKAnExcelExpert]

Most welcome

[@nktrendings816]

Nice 👍

[@PKAnExcelExpert]

Thanks ✌

[@PauleenSevillano]

Thanks for the tutorial, it helped me a lot 😊

[@PKAnExcelExpert]

Most welcome

[@dinahany233]

thanks for the best project tutorial .. god bless u

[@PKAnExcelExpert]

Most welcome

[@abdullahquhtani4247]

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

[@PKAnExcelExpert]

Thank you, I will try to create

[@SyedMuzammilMahasanShahi]

Thanks for the share.

[@PKAnExcelExpert]

Our pleasure!

[@khristianaldana8449]

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

[@PKAnExcelExpert]

Thanks 🙏

[@aminaghosh3075]

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

[@BlackThor15]

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?

[@__nbviews__9873]

Same question..Need yearly dashboard

[@SKumarvlog-wr1kq]

Very nice

[@PKAnExcelExpert]

Thanks

[@uroobaahmed7937]

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

[@nadag.youssef1719]

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

[@spanchal9911]

thanks

[@PKAnExcelExpert]

Welcome

[@CFA9188thAve]

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!

[@prachigosavi-p8d]

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

[@sanjeevfernandes8280]

Super! I have appraisal for around 100 employees. Is it possible to make the same for 100 employees too?

[@PKAnExcelExpert]

Yes

[@sanjeevfernandes8280]

@@PKAnExcelExpert Why the formula not working

[@sanjeevfernandes8280]

If I give you the data for the appraisal, can you make one for me? I shall pay for that.

[@GaneshSingh-lt8yv]

Sir i have tried multiple time but the formaula for perfomance score is not applying getting e😢rror

[@sanjeevfernandes8280]

Finally, I bought this dashboard file by paying. But I want to see the dashboard in full screen in the computer. How?

[@purvijain9179]

Plz, provide us also bro

[@nitronik5038]

How can I teach from you, this useful dashboard

[@yasmin.ilyas30]

I have tried to do this in the excel, but in the performance score, when i type the formula, them#value? appears. Can somebody please tell me that why does it happens? although I am following each and every step

[@falepitricahyadi8056]

F2 CTRL+SHIFT ENTER

[@safdarqaiyum5355]

PUT the formula then press CTRL+Shift Enter together

[@ndutumbella5981]

Please how do I buy your template?

[@PKAnExcelExpert]

Link is given in video's description box or email us at [e-mail]

[@ndutumbella5981]

@@PKAnExcelExpert Please, am getting a message that the email address is wrong.

[@sanjeevfernandes8280]

I tried several times but the formula is not working

[@Ravinder.Dhingra]

I tried but can’t download any of the files..

[@eingyinnsue]

performace score formula is not working. how can work? give me giude line.pls

[@safdarqaiyum5355]

Value error is showing in performance score please help

[@dom8929]

is there another payment method except paypal?

[@PKAnExcelExpert]

Please email us at [e-mail]

[@hrahmanali2610]

Can you plz share

[@abderrahmanebedir9857]

this template file is not FREE ?????

[@arif72658]

why my performance score is #value!

It shows $1.99 to download the template

[@betterMG]

IT'S NOT FREEEE

[@anjumdixit3474]

Sir transpose wale formula me #value error aaraha hai....

[@sanjeevfernandes8280]

=SUM( IF(Table1[@[Job competence]:[Adoptability]]=grid!$K$2, TRANSPOSE(Score))) This is the formula I made as you explained but does not work!

[@ssquare3085]

cltr+shift+enter

[@TracyEdes]

@@ssquare3085 it is still not working and I’m stuck because of it.

[@mudaues6831]

I tried too, not working, m using MacBook, please assist

[@purvijain9179]

Yes, I also tried but not working🥲

[@hsworld3063]

Yes not working