Employee Performance Rating Card and Dashboard in Excel

Поділитися
Вставка
  • Опубліковано 30 січ 2025

КОМЕНТАРІ • 72

  • @سُندٍسٌ-و4د
    @سُندٍسٌ-و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.

  • @pandharinathjoshi6565
    @pandharinathjoshi6565 Рік тому +1

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

  • @chalkycloud893
    @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.

  • @yunablu6241
    @yunablu6241 Рік тому +1

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

  • @abdullahquhtani4247
    @abdullahquhtani4247 Рік тому +1

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

  • @aminaghosh3075
    @aminaghosh3075 10 місяців тому +4

    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

  • @smr8854
    @smr8854 Рік тому +1

    Excellent and easy way explained,🙏

  • @Luciano_mp
    @Luciano_mp Рік тому +1

    Nice dashboard, useful! Thank you.

  • @sumardjo
    @sumardjo Рік тому +1

    Thanks for tutorial
    with a sample file
    easy to follow
    thanks

  • @PauleenSevillano
    @PauleenSevillano 8 місяців тому +1

    Thanks for the tutorial, it helped me a lot 😊

  • @nktrendings816
    @nktrendings816 Рік тому +2

    Nice 👍

  • @stevenmalcoun
    @stevenmalcoun 2 місяці тому +1

    amazing job PK

  • @dinahany233
    @dinahany233 7 місяців тому +1

    thanks for the best project tutorial .. god bless u

  • @brittokhan5278
    @brittokhan5278 13 днів тому

    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

  • @BlackThor15
    @BlackThor15 11 місяців тому

    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
      @__nbviews__9873 8 місяців тому +1

      Same question..Need yearly dashboard

  • @uroobaahmed7937
    @uroobaahmed7937 Рік тому +3

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

  • @khristianaldana8449
    @khristianaldana8449 5 місяців тому +1

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

  • @SyedMuzammilMahasanShahi
    @SyedMuzammilMahasanShahi Рік тому +1

    Thanks for the share.

  • @CFA9188thAve
    @CFA9188thAve 3 місяці тому

    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?

  • @MichellePompili-j1r
    @MichellePompili-j1r 9 днів тому

    Is it worth purchasing?

  • @nadag.youssef1719
    @nadag.youssef1719 7 місяців тому

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

  • @karuqaster
    @karuqaster 4 місяці тому

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

  • @prachigosavi-p8d
    @prachigosavi-p8d 6 місяців тому +1

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

  • @SKumarvlog-wr1kq
    @SKumarvlog-wr1kq 9 місяців тому +1

    Very nice

  • @GaneshSingh-lt8yv
    @GaneshSingh-lt8yv Місяць тому

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

  • @spanchal9911
    @spanchal9911 2 місяці тому +1

    thanks

  • @yasmin.ilyas30
    @yasmin.ilyas30 6 місяців тому +1

    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

  • @sanjeevfernandes8280
    @sanjeevfernandes8280 8 місяців тому +1

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

  • @ndutumbella5981
    @ndutumbella5981 6 місяців тому

    Please how do I buy your template?

    • @PKAnExcelExpert
      @PKAnExcelExpert  6 місяців тому

      Link is given in video's description box or email us at info@PK-AnExcelExpert.Com

    • @ndutumbella5981
      @ndutumbella5981 6 місяців тому

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

  • @sanjeevfernandes8280
    @sanjeevfernandes8280 8 місяців тому +1

    I tried several times but the formula is not working

  • @Ravinder.Dhingra
    @Ravinder.Dhingra 11 місяців тому

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

  • @eingyinnsue
    @eingyinnsue 8 місяців тому

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

  • @nitronik5038
    @nitronik5038 10 місяців тому

    How can I teach from you, this useful dashboard

  • @dom8929
    @dom8929 5 місяців тому

    is there another payment method except paypal?

    • @PKAnExcelExpert
      @PKAnExcelExpert  4 місяці тому

      Please email us at info@PK-AnExcelExpert.Com

  • @sanjeevfernandes8280
    @sanjeevfernandes8280 8 місяців тому

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

  • @safdarqaiyum5355
    @safdarqaiyum5355 3 місяці тому

    Value error is showing in performance score please help

  • @abderrahmanebedir9857
    @abderrahmanebedir9857 10 місяців тому

    this template file is not FREE ?????

  • @hrahmanali2610
    @hrahmanali2610 6 місяців тому

    Can you plz share

  • @arif72658
    @arif72658 3 місяці тому

    why my performance score is #value!

  •  10 місяців тому

    It shows $1.99 to download the template

  • @betterMG
    @betterMG 6 місяців тому +1

    IT'S NOT FREEEE

  • @anjumdixit3474
    @anjumdixit3474 2 місяці тому

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

  • @sanjeevfernandes8280
    @sanjeevfernandes8280 8 місяців тому +5

    =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
      @ssquare3085 5 місяців тому

      cltr+shift+enter

    • @TracyEdes
      @TracyEdes 4 місяці тому

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

    • @mudaues6831
      @mudaues6831 2 місяці тому

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

    • @purvijain9179
      @purvijain9179 2 місяці тому

      Yes, I also tried but not working🥲

    • @hsworld3063
      @hsworld3063 Місяць тому

      Yes not working