How to create AUTOMATED PAYSLIP in Excel

Поделиться
HTML-код
  • Опубликовано: 7 дек 2017
  • AUTOMATED PAYSLIP TEMPLATE SAMPLE
    DOWNLOAD HERE:
    drive.google.com/file/d/1a-94...

Комментарии • 161

  • @85MA
    @85MA 6 месяцев назад

    "You didn't speak a single word, and I didn't hear a single word, yet you explained everything, and I understood it all. Amazing! Hats off to you, Chris, for your incredible knowledge and teaching skills. God bless you for helping us learn and gain knowledge. Keep up the amazing work!"

  • @msannalyndy
    @msannalyndy 4 года назад +2

    Thank you so much Cris! You are not selfish to share your knowledge. May God bless you more 😀

  • @baekhyunbyun7665
    @baekhyunbyun7665 5 лет назад +5

    maraming salamat , using this for our small company , it's really a great help. more power po

  • @engr.9137
    @engr.9137 6 лет назад +2

    Great video. This is what I'm looking for right now. Big thanks brudah!

  • @kem965
    @kem965 4 года назад +1

    Great video thanks a lot. Applied it on our workers and it work perfectly. Thumbs up

  • @gorkhadiary
    @gorkhadiary 4 года назад

    Thank you so much Cris minas. Love the way you teach.

  • @inaumali3690
    @inaumali3690 3 года назад

    Thank you for this free download. I have employees on a weekly basis payroll and ur an Angel. God bless you dear🙏

  • @MechMiko
    @MechMiko 4 года назад +15

    Business man be making naruto references : D

  • @rheaedeleon
    @rheaedeleon 3 года назад

    Such a big help! Thank you Cris Minas!

  • @riansetiawan4591
    @riansetiawan4591 5 лет назад

    thank you for very detail tutorial!

  • @lakisatish01
    @lakisatish01 6 лет назад +2

    excellent video... my word is really eased

  • @glitterworldcreation
    @glitterworldcreation 5 лет назад

    I like ur vdo too much it's very interesting.
    Happy to get ur downloads all Woking very fine.

  • @jackmeoff7381
    @jackmeoff7381 4 года назад

    This has helped me so much! I've been looking to do this for a while however when I've googled the problem the only thing I got was excel coding which made made me through my arms in the air and give up! Thx for your help, appreciate it!

  • @afcryn__
    @afcryn__ 3 года назад

    This is really helpful. Thank you!

  • @BasicStudyClasses22
    @BasicStudyClasses22 5 лет назад +1

    Thank you so much for this video

  • @normadbensurto3751
    @normadbensurto3751 4 года назад

    i love this very helpful... thank you thank you

  • @user-dy8mw5vi9c
    @user-dy8mw5vi9c 5 лет назад

    Thanks a lot ! very fantastic!!

  • @Multi4funonly
    @Multi4funonly 5 лет назад +1

    Love this👍 thanks!

  • @silentsteps642
    @silentsteps642 4 года назад

    Thanks you so much for this :D

  • @spinBazz
    @spinBazz 6 лет назад

    Thanks for sharing. Can we print all the Payslips on one go?

  • @RamKumar-ds9te
    @RamKumar-ds9te 6 лет назад

    So much helpful......thank you so much...keep it up....

  • @dilekanishara9481
    @dilekanishara9481 2 года назад

    Truly Amazing Work.... Thanks for sharing knowledge.... 😻

  • @tengkumusali9527
    @tengkumusali9527 4 года назад

    Excellent video tutorial. Thanks Cris Minas. InShaaALLAH the Hidden Leaf Village Ninja will be more powerfull when you be the Next Hokage... :)

  • @snihc3583
    @snihc3583 6 лет назад

    Superb, Excellent and Amazing

  • @asmrindia
    @asmrindia 6 лет назад +3

    EXCELLENT

  • @aaniutaa86
    @aaniutaa86 5 лет назад +1

    Hi Cris, this is amazing example you have shared it, thanks a lot. Need your help, got stuck in selecting table, instead of showing the cells numbers A5:W15, automatically is making the table and couldnt lock, if i do it manually is giving me error N/A?,
    please advise,
    your help is most appreciated
    best regards

  • @IbrahimKhalil-ms1kf
    @IbrahimKhalil-ms1kf 5 лет назад +1

    Assalamualaikum, dear maker, Very Nice & effective video for all HRM Departments. Allah bless you.

  • @muhammadafzal3491
    @muhammadafzal3491 5 лет назад

    Very helpful...excellent work

  • @deepak07041979
    @deepak07041979 6 лет назад +1

    Jhakas
    Means Fabulous

  • @anviesdreamland8354
    @anviesdreamland8354 4 года назад

    Awesome Video, helped me a lot

  • @KeepThingzBazic
    @KeepThingzBazic 4 года назад

    Hi, really really appreciate all the postings you have. It would really be nice to keep in touch. how do we connect or something? Can I learn from you personally? Thanks so much!

  • @yehlenalcantara8412
    @yehlenalcantara8412 2 года назад

    Super big help. 😊 THANK YOU.

  • @rodelvaldez8292
    @rodelvaldez8292 Год назад +1

    Thank you so much for this

  • @onalleratv3629
    @onalleratv3629 5 лет назад

    Wow.. Amazing nice vid

  • @o.t.a.r.o9591
    @o.t.a.r.o9591 6 лет назад +3

    nice dude! This is so helpful! How about monthly basis? Can you make one?

  • @casper3842
    @casper3842 5 лет назад

    Salamat po kabayan!!!

  • @essamfahim749
    @essamfahim749 6 лет назад +1

    great job

    • @CrisMinas
      @CrisMinas  6 лет назад

      +Essam Fahim thank you

  • @candykatigbak4144
    @candykatigbak4144 Год назад

    HI CRIS. Thanks for the form. I just can't figure out how to add another row because I pay salaries every 2 weeks. Is it possible to add an extra row for the extra week?

  • @simplycomplex81
    @simplycomplex81 2 года назад

    Dude - Very very cool!

  • @infoonyx3797
    @infoonyx3797 Год назад

    lmao Konoha payroll. Perfection!

  • @edmarlibardo7596
    @edmarlibardo7596 4 года назад

    Ang galing :)

  • @thiphyo6758
    @thiphyo6758 6 лет назад

    Thanks a lot

  • @nenielherediano3878
    @nenielherediano3878 3 года назад

    thank you po
    malaking tulong ,

  • @wahidabdul6828
    @wahidabdul6828 4 года назад +1

    Very nice easy to learn thanks

  • @BhadriShashikanth
    @BhadriShashikanth 6 лет назад +1

    Please tell me, How you created slip sheet and how we can take PDF print out for each individuals?

  • @axiebenggoy6917
    @axiebenggoy6917 3 года назад

    THANK YOU SO MUCH!!!!!!!!!

  • @Mukthadir
    @Mukthadir 2 года назад

    thank you man!

  • @jerlienbontilao5263
    @jerlienbontilao5263 Год назад

    Thank u po big help po sya sa akin. .☺️

  • @Hanesy
    @Hanesy 5 лет назад

    Sir thank you. Can you please edit and make 2 weeks instead of one week because the cut off is every 15 days

  • @jdstv6914
    @jdstv6914 9 месяцев назад

    Thank you so much sir. big help to us :D

  • @krishnamoorthy5953
    @krishnamoorthy5953 2 года назад

    Thanks for your valuable support and update sir

  • @gorilla4661
    @gorilla4661 6 лет назад

    No. 1

  • @jorosaconstruction3550
    @jorosaconstruction3550 5 лет назад

    Awesome!! you are a blessing

  • @PriyaRajvanshHR
    @PriyaRajvanshHR 5 лет назад

    Best one

  • @mekonnendessie2444
    @mekonnendessie2444 6 лет назад +1

    thanks

  • @javedtamboli3127
    @javedtamboli3127 6 лет назад

    Awesome

  • @josedossantosl.6833
    @josedossantosl.6833 4 года назад

    Cris; you're great

  • @snihc3583
    @snihc3583 6 лет назад

    i noticed that this good for 1 week what good for 15 days or 1 month pay slip?

  • @amateruss
    @amateruss 6 лет назад +3

    Nice one fellow Pinoy.

  • @virginiaexodus6318
    @virginiaexodus6318 3 года назад

    thanks a lot!!

  • @pierceandre8363
    @pierceandre8363 5 лет назад +1

    Thanks

  • @IbrahimKhalil-ms1kf
    @IbrahimKhalil-ms1kf 6 лет назад

    Dear Brother lot of thanks for nice video, But i want total employees individual sheets.

  • @jonzsantos6542
    @jonzsantos6542 3 года назад

    ang galing nyu po salamat po

  • @criscurray
    @criscurray 4 года назад

    Hello po, are u using Excel 2018 for this specific tutorial? Million thanks po ❤

  • @mahmudtaged6992
    @mahmudtaged6992 3 года назад

    Thanks a lot. . . Thanks 😊😊😊😊

  • @MrIskehe
    @MrIskehe 3 года назад

    Thanks for this

  • @shinlanten
    @shinlanten 4 года назад

    Ahh the Excel pre-ribbon days

  • @sharmainemiroy2857
    @sharmainemiroy2857 7 месяцев назад

    Hello Cris...Do you have semi monthly payroll tutorial?

  • @maryjanesemblante5759
    @maryjanesemblante5759 5 лет назад +1

    hey i kinda need help after i've done the formula base on my own tables and figures it give me "#N/A" on the "NAME" part

  • @awesomemich8530
    @awesomemich8530 5 лет назад

    Hi, thank you for this tutorial, very very helpful. But, if i wanna use the employee name instead of the employee number, when i edit the formula, it doesnt seems towork. Could you help me out with that please?

    • @CrisMinas
      @CrisMinas  5 лет назад

      It would be easier if you just copy & paste the employee name into the employee number in "Payroll Sheet".

  • @wahidabdul6828
    @wahidabdul6828 4 года назад +1

    How about monthly basis? Can you make one?

  • @vlfmedicalclinic8010
    @vlfmedicalclinic8010 6 лет назад

    HI CRIS, How can i search by payroll period time not the employee number.

  • @prathip007prathip
    @prathip007prathip 5 лет назад

    very nice and thanks

  • @rioucab2735
    @rioucab2735 3 года назад

    Please make A Tutorial To Make A Certificate of Employment With Compensation

  • @real_michael
    @real_michael 3 года назад

    I love how there's Naruto references

  • @RamanKumar-rn8xl
    @RamanKumar-rn8xl 6 лет назад

    Thnx

  • @abdulmaliksaeed2225
    @abdulmaliksaeed2225 5 лет назад

    I think Tsunade will just gamble with all that money

  • @ericar4179
    @ericar4179 5 лет назад

    Do you have a video to create the payslip?

  • @deangelodeangelo2604
    @deangelodeangelo2604 4 года назад

    How do i get the blank template to start off with ?

  • @AjayKumar-uu1bj
    @AjayKumar-uu1bj 6 лет назад

    Bhai ji Apne ye formula kaise lgaya h kya AAP iske regarding ek video bnaoge

  • @zahirulislam9442
    @zahirulislam9442 3 года назад

    Hi, Thanks a lot
    I had a make pay roll sheet, all are ok but one cell N/A, how is problem?
    After Copy paste function is working but one cell is error, pls help me

  • @swapnil32
    @swapnil32 4 года назад

    how did you make the Payslip template and also Payroll slide

  • @gladlyfernando9172
    @gladlyfernando9172 3 года назад

    thanj you very much.

  • @ralphroda8980
    @ralphroda8980 5 лет назад

    hello maam do you have POS with inventory in excel? thanks in advance

  • @marlogne
    @marlogne 2 года назад

    Salamat!!!

  • @user-mq7oi4cy3m
    @user-mq7oi4cy3m 4 месяца назад

    2:25 Index and Match Function

  • @lakhanitractors960
    @lakhanitractors960 5 лет назад

    Superb

  • @mysuperjekie
    @mysuperjekie 4 года назад

    hi, is there any way to save all the payslip automatically generated payslip in PDF?

  • @kennethdizon8747
    @kennethdizon8747 9 месяцев назад

    Hello Sir! Do you have a template for semi monthly?

  • @Sunny-ri4cu
    @Sunny-ri4cu 6 лет назад

    Hi Chris, i cant find the template on google drive, can you give a new link if it is possible? thank you.

    • @CrisMinas
      @CrisMinas  6 лет назад

      Fixed, new link in the description box.

  • @floryquerubin-filart5981
    @floryquerubin-filart5981 4 года назад

    Do you have payroll excell?

  • @marizmabeza2776
    @marizmabeza2776 6 лет назад +1

    How about if the employee resigns or has ended contract?

    • @amateruss
      @amateruss 6 лет назад

      Then make another function that deals with that.

  • @puteraalfarizqi2045
    @puteraalfarizqi2045 5 лет назад

    how to change hidden leaf ninja to all pay slip and land of fire..

  • @tprabhakaran3686
    @tprabhakaran3686 6 лет назад

    instead we can go mail merge for all payslips at once

  • @refoldopalco7564
    @refoldopalco7564 3 года назад

    Thank you Cris Minas.
    08January2021

  • @walterelemino
    @walterelemino 5 лет назад

    Do you offer one on one tutorial. May gusto kasi akong gawin pero parang hindi ko kaya kung ako lang ang gagawa.

  • @welcomephotobook4106
    @welcomephotobook4106 4 года назад

    How to contact you?

  • @nathaliekhriss5295
    @nathaliekhriss5295 6 лет назад +1

    can I do it by 15days?

    • @CrisMinas
      @CrisMinas  6 лет назад +1

      +Nathalie Khriss G. Estero Yes. Just Make your salary columns 15 instead of 7.
      (If you're using my sample, insert columns inside the table only not after the blue column)

  • @OpenCirclesArts
    @OpenCirclesArts 3 года назад

    Does anyone have a monthly version?

  • @sandytilo9573
    @sandytilo9573 4 года назад

    What about your payroll hihi thanks