How to create AUTOMATED PAYSLIP in Excel

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

КОМЕНТАРІ •

  • @85MA
    @85MA Рік тому +1

    "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!"

  • @baekhyunbyun7665
    @baekhyunbyun7665 5 років тому +6

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

  • @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🙏

  • @msannalyndy
    @msannalyndy 4 роки тому +2

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

  • @kem965
    @kem965 4 роки тому +1

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

  • @IbrahimKhalil-ms1kf
    @IbrahimKhalil-ms1kf 6 років тому +1

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

  • @jerlienbontilao5263
    @jerlienbontilao5263 2 роки тому

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

  • @MechMiko
    @MechMiko 5 років тому +14

    Business man be making naruto references : D

  • @dilekanishara9481
    @dilekanishara9481 3 роки тому

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

  • @jdstv6914
    @jdstv6914 Рік тому

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

  • @engr.9137
    @engr.9137 6 років тому +2

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

  • @yehlenalcantara8412
    @yehlenalcantara8412 3 роки тому

    Super big help. 😊 THANK YOU.

  • @rheaedeleon
    @rheaedeleon 4 роки тому

    Such a big help! Thank you Cris Minas!

  • @krishnamoorthy5953
    @krishnamoorthy5953 2 роки тому

    Thanks for your valuable support and update sir

  • @mahmudtaged6992
    @mahmudtaged6992 3 роки тому

    Thanks a lot. . . Thanks 😊😊😊😊

  • @wahidabdul6828
    @wahidabdul6828 5 років тому +1

    Very nice easy to learn thanks

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

    Thank you so much for this

  • @simplycomplex81
    @simplycomplex81 3 роки тому

    Dude - Very very cool!

  • @gorkhadiary
    @gorkhadiary 5 років тому

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

  • @tengkumusali9527
    @tengkumusali9527 5 років тому

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

  • @lakisatish01
    @lakisatish01 6 років тому +2

    excellent video... my word is really eased

  • @jackmeoff7381
    @jackmeoff7381 5 років тому

    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!

  • @snihc3583
    @snihc3583 7 років тому

    Superb, Excellent and Amazing

  • @josedossantosl.6833
    @josedossantosl.6833 4 роки тому

    Cris; you're great

  • @anviesdreamland8354
    @anviesdreamland8354 5 років тому

    Awesome Video, helped me a lot

  • @glitterworldcreation
    @glitterworldcreation 6 років тому

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

  • @afcryn__
    @afcryn__ 3 роки тому

    This is really helpful. Thank you!

  • @RamKumar-ds9te
    @RamKumar-ds9te 6 років тому

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

  • @infoonyx3797
    @infoonyx3797 Рік тому

    lmao Konoha payroll. Perfection!

  • @muhammadafzal3491
    @muhammadafzal3491 6 років тому

    Very helpful...excellent work

  • @sharmainemiroy2857
    @sharmainemiroy2857 Рік тому

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

  • @aaniutaa86
    @aaniutaa86 6 років тому +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

  • @nenielherediano3878
    @nenielherediano3878 4 роки тому

    thank you po
    malaking tulong ,

  • @normadbensurto3751
    @normadbensurto3751 5 років тому

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

  • @candykatigbak4144
    @candykatigbak4144 2 роки тому

    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?

  • @BasicStudyClasses22
    @BasicStudyClasses22 6 років тому +1

    Thank you so much for this video

  • @김지훈-m9b3d
    @김지훈-m9b3d 5 років тому

    Thanks a lot ! very fantastic!!

  • @spinBazz
    @spinBazz 7 років тому

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

  • @riansetiawan4591
    @riansetiawan4591 6 років тому

    thank you for very detail tutorial!

  • @silentsteps642
    @silentsteps642 4 роки тому

    Thanks you so much for this :D

  • @edmarlibardo7596
    @edmarlibardo7596 5 років тому

    Ang galing :)

  • @wahidabdul6828
    @wahidabdul6828 5 років тому +1

    How about monthly basis? Can you make one?

  • @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?

  • @jonzsantos6542
    @jonzsantos6542 3 роки тому

    ang galing nyu po salamat po

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

    2:25 Index and Match Function

  • @BhadriShashikanth
    @BhadriShashikanth 6 років тому +1

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

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

  • @Mukthadir
    @Mukthadir 3 роки тому

    thank you man!

  • @swapnil32
    @swapnil32 4 роки тому

    how did you make the Payslip template and also Payroll slide

  • @onalleratv3629
    @onalleratv3629 5 років тому

    Wow.. Amazing nice vid

  • @maryjanesemblante5759
    @maryjanesemblante5759 6 років тому +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

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

  • @kennethdizon8747
    @kennethdizon8747 Рік тому

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

  • @snihc3583
    @snihc3583 7 років тому

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

  • @prathip007prathip
    @prathip007prathip 5 років тому

    very nice and thanks

  • @deangelodeangelo2604
    @deangelodeangelo2604 5 років тому

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

  • @axiebenggoy6917
    @axiebenggoy6917 3 роки тому

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

  • @floryquerubin-filart5981
    @floryquerubin-filart5981 4 роки тому

    Do you have payroll excell?

  • @mysuperjekie
    @mysuperjekie 5 років тому

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

  • @jorosaconstruction3550
    @jorosaconstruction3550 6 років тому

    Awesome!! you are a blessing

  • @shinlanten
    @shinlanten 4 роки тому

    Ahh the Excel pre-ribbon days

  • @rioucab2735
    @rioucab2735 4 роки тому

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

  • @real_michael
    @real_michael 4 роки тому

    I love how there's Naruto references

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

  • @vlfmedicalclinic8010
    @vlfmedicalclinic8010 6 років тому

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

  • @ericar4179
    @ericar4179 5 років тому

    Do you have a video to create the payslip?

  • @Hanesy
    @Hanesy 6 років тому

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

  • @deepak07041979
    @deepak07041979 7 років тому +1

    Jhakas
    Means Fabulous

  • @casper3842
    @casper3842 5 років тому

    Salamat po kabayan!!!

  • @lakhanitractors960
    @lakhanitractors960 5 років тому

    Superb

  • @awesomemich8530
    @awesomemich8530 6 років тому

    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  6 років тому

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

  • @rachelleocho2992
    @rachelleocho2992 3 роки тому

    I can't access the file 😢

  • @MrIskehe
    @MrIskehe 4 роки тому

    Thanks for this

  • @KeepThingzBazic
    @KeepThingzBazic 5 років тому

    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!

  • @Multi4funonly
    @Multi4funonly 6 років тому +1

    Love this👍 thanks!

  • @ralphroda8980
    @ralphroda8980 6 років тому

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

  • @puteraalfarizqi2045
    @puteraalfarizqi2045 6 років тому

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

  • @OpenCirclesArts
    @OpenCirclesArts 4 роки тому

    Does anyone have a monthly version?

  • @Cybercredible
    @Cybercredible 2 роки тому

    Tbh I came to my email from Credible Cyber with good income calculation

  • @graham11545
    @graham11545 6 років тому +1

    Hi if i wanted to match not only the employee number but the payslip period as well from the same payroll is that possible?

    • @graham11545
      @graham11545 6 років тому

      this is given i added a column that has the period

    • @graham11545
      @graham11545 6 років тому

      Found out how if you want my copy of it in how I did it am glad to share

    • @stellanatalia27
      @stellanatalia27 6 років тому

      Hi, i would like to know how to do if i want to match the payslip period as well. Thankyou

  • @criscurray
    @criscurray 5 років тому

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

  • @amateruss
    @amateruss 6 років тому +3

    Nice one fellow Pinoy.

  • @marlogne
    @marlogne 2 роки тому

    Salamat!!!

  • @abdulmaliksaeed2225
    @abdulmaliksaeed2225 5 років тому

    I think Tsunade will just gamble with all that money

  • @gladlyfernando9172
    @gladlyfernando9172 3 роки тому

    thanj you very much.

  • @IbrahimKhalil-ms1kf
    @IbrahimKhalil-ms1kf 6 років тому

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

  • @axiebenggoy6917
    @axiebenggoy6917 3 роки тому

    Hi sir. Ask ko lang po pag nagdagdag po ng employee, yung mga naka bold na sa payslip po like gross salary,net salary, yung mga amount po is nawawala pagka bold letters nila then hindi po malakihan, bumabalik sa maliit. paano po gagawin

  • @asmrindia
    @asmrindia 6 років тому +3

    EXCELLENT

  • @walterelemino
    @walterelemino 6 років тому

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

  • @sandytilo9573
    @sandytilo9573 5 років тому

    What about your payroll hihi thanks

  • @CardiBJepsen
    @CardiBJepsen 4 роки тому

    may format ka po pang kinsenas?

  • @AjayKumar-uu1bj
    @AjayKumar-uu1bj 6 років тому

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

  • @nathaliekhriss5295
    @nathaliekhriss5295 7 років тому +1

    can I do it by 15days?

    • @CrisMinas
      @CrisMinas  7 років тому +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)

  • @welcomephotobook4106
    @welcomephotobook4106 5 років тому

    How to contact you?

  • @virginiaexodus6318
    @virginiaexodus6318 4 роки тому

    thanks a lot!!

  • @essamfahim749
    @essamfahim749 7 років тому +1

    great job

    • @CrisMinas
      @CrisMinas  7 років тому

      +Essam Fahim thank you

  • @shizenwesteria4199
    @shizenwesteria4199 4 роки тому

    Hi, pwede ka bang mka gawa ng video about sa Automated Attendance to payroll?

  • @forktrader7870
    @forktrader7870 5 років тому

    pano i-update yung wtax sa train law saka new sss table?

  • @qwertomtv1621
    @qwertomtv1621 5 років тому

    Sir, tanong ko lang sana. kung pwede pa ito madagdagan yung lalagyan siya ng SSS table and Vlook din po ang gagawin?

  • @jdt333
    @jdt333 4 роки тому

    BOSS bakit paggagawa na ako ng table ayaw na? cant overlap another table daw.
    salamat