Make a Salary Slip in Excel | Automatic Salary Pay Slip in 5 Minutes

Sdílet
Vložit
  • čas přidán 20. 01. 2022
  • Download free Invoice Templates: bit.ly/3Fo2fak
    In this video you will learn about how to create an automatic salary pay slip in Microsoft Excel. I tried to use some excel function to make this salary slip automatic. The main functions I used are Xlookup and Spellnumber.
    Make a Salary Slip in Excel | Automatic Salary Pay Slip in 5 Minutes
    Excel Spell Number Function
    • How to Automatically C...
    Excel Xlookup Function Explained
    • Excel Xlookup Explaine...
    Do Subscribe our Channel for more educational videos...!
    #Salaryslip #Makesalaryslip #Createsalarypayslip

Komentáře • 146

  • @LearnforFuture
    @LearnforFuture  Před 9 měsíci +10

    Download free Invoice Templates: bit.ly/3Fo2fak

  • @irynasavchenko91
    @irynasavchenko91 Před rokem +7

    Thank you!!! This is a really excellent tutorial. Clear and concise. Many thanks!

  • @balajimudaliyar2537
    @balajimudaliyar2537 Před 7 měsíci +1

    Thank you so much Bro, it helped me a lot. God bless you, please don't stop making videos.😎💞

  • @julietchaur5497
    @julietchaur5497 Před 2 lety +4

    Thank you, It's quite simple and helpful.
    GOD Bless you always.

  • @jesudara
    @jesudara Před rokem +5

    Thanks so much for this. How can I display all the payslip for all the employees at once so I can print them all out at once.

  • @brightfuture2293
    @brightfuture2293 Před rokem

    Thank you for sharing with us and its very easy.

  • @user-ex5pt6fo9f
    @user-ex5pt6fo9f Před rokem +2

    Thank you.Great work.

  • @komalshankaran8458
    @komalshankaran8458 Před rokem +1

    Great work, thank u brother, keep going...

  • @jessielynfrilles3757
    @jessielynfrilles3757 Před 2 lety +2

    I love youuuuu. Thank you so much for this video its a great help!❤❤❤

  • @manojkumarn3314
    @manojkumarn3314 Před rokem +3

    hii in this video i can see only manual dropdown but if we wanted like automatic sheets should be created as no. of employees .. example if we link source data to the sheet it should create as many as employees pay slips in different different sheets . i hope u got my point . help me on it if possible...

  • @DawnImani
    @DawnImani Před rokem +8

    This is exactly what I needed. Making an allowance salary sheet for my kids.

  • @DylanajibChannel
    @DylanajibChannel Před rokem +1

    Thank you so much its so easiest my works

  • @krishnamoorthy5953
    @krishnamoorthy5953 Před 2 lety +2

    Very useful information video. Thanks for your valuable support and update sir.

    • @LearnforFuture
      @LearnforFuture  Před 2 lety

      Happy to hear that.. Keep supporting

    • @mr_yjie_468
      @mr_yjie_468 Před 7 měsíci +1

      Hi I just want to ask about why I use developer, insert the check box why my excel column have check beside the cash in the cash column ?

  • @srikantjena6078
    @srikantjena6078 Před rokem +1

    You make it very very fast 👍🏽

  • @GALDILE.
    @GALDILE. Před 2 lety

    Thnk u brthr YOU MAKE IT one video PERFECT excel plz brthr step py step🙏🙏🙏

  • @RS_Marketing
    @RS_Marketing Před 7 měsíci

    Excellent Information

  • @sekakiven647
    @sekakiven647 Před 2 lety

    This is Great

  • @user-hm5qx3pd1f
    @user-hm5qx3pd1f Před 7 měsíci

    অনেক কিছু শিখতে পারলাম ভাই

  • @henryjohn9748
    @henryjohn9748 Před 4 měsíci

    Thanks for this video. From the beginning was easy to understand but from when you began to include the xlookup function it wasn't clear anymore and also you kept mute and became faster than before at the ending part of the video. Very helpful though thanks

  • @SNSolutions-hf1mz
    @SNSolutions-hf1mz Před rokem

    Thanks!

  • @surajit.worlds
    @surajit.worlds Před 8 měsíci +1

    bro thanks for this help but if I want to print in one page a minimum of three employee salary slip details then how would I print them, please help

  • @aliekabba547
    @aliekabba547 Před rokem

    Thanks u so much

  • @enochmensah4660
    @enochmensah4660 Před 2 měsíci

    This was really helpful, thank you 😊

  • @user-gl5rr2qq6y
    @user-gl5rr2qq6y Před 11 měsíci

    Great one

  • @shrutijoshi4444
    @shrutijoshi4444 Před měsícem +1

    This is very useful thank you.

  • @kranthikumar6474
    @kranthikumar6474 Před rokem

    Earnings side what should we add for seed processing company

  • @abodisom_official
    @abodisom_official Před 6 měsíci

    Nice video👍👍

  • @manikdas4096
    @manikdas4096 Před rokem

    Excellent

  • @vibsvibs2510
    @vibsvibs2510 Před rokem

    I subscribe as I like❤❤

  • @Mohammedshoaib1441
    @Mohammedshoaib1441 Před 2 měsíci

    Thanks so much for this.! Can you please Make a easy and simple way Salary Sheet

  • @kaykay59870
    @kaykay59870 Před 5 měsíci

    Is there a way to print them all without having to change emp ID and print one individually?

  • @cooldude7170
    @cooldude7170 Před 5 měsíci

    Thanks. It was very helpful. Can we copy paste and apply it for every month? Or there is any other method?

    • @cooldude7170
      @cooldude7170 Před 5 měsíci

      Is there any method to generate a pay slip with the help of pivot table?

  • @arkhan4932
    @arkhan4932 Před rokem

    Thank you

  • @khushbookumari-yc5bd
    @khushbookumari-yc5bd Před rokem

    if i will add new salary data in sheet 2, will it come in sheet 1?

  • @IrfanAhmad-up2vi
    @IrfanAhmad-up2vi Před 2 měsíci

    Can we use it with multiple invoice?

  • @benjaminadigbo3062
    @benjaminadigbo3062 Před rokem +1

    please kindly send all the youtube videos as text or writing so that I can practise thank you

  • @wonderful9223
    @wonderful9223 Před rokem

    Why I can't get the same column width.. Is it I need to change " to cm?

  • @ermiassyum3291
    @ermiassyum3291 Před 2 lety

    its great bro now can tell me how to add a developer tab to my ribbons

    • @LearnforFuture
      @LearnforFuture  Před 2 lety

      On the File tab, go to Options > Customize Ribbon.
      Under Customize the Ribbon and under Main Tabs, select the Developer check box

    • @winstonchangawa720
      @winstonchangawa720 Před rokem

      @@LearnforFuture Thanks for to show up

  • @noufalshaji
    @noufalshaji Před 7 měsíci

    Good ...but need to know how to make it all employees payslip together without changing the employee number one bye one'
    Is there any posibilitt?

  • @constechz
    @constechz Před rokem

    How do you write a VBA code to print them one by one boss??

  • @adjienomoto5728
    @adjienomoto5728 Před rokem

    How can I get a soft copy?

  • @Billy-dl1hi
    @Billy-dl1hi Před 2 měsíci

    Thank you 🎉

  • @AbdurRehmankhattak-ARK
    @AbdurRehmankhattak-ARK Před 11 měsíci

    how you deleted the g h i j colums kindly help

  • @bhaskar3471
    @bhaskar3471 Před 2 lety

    trying to enter the data validation but it can't source the salary sheet bro....

  • @moeedkhan3696
    @moeedkhan3696 Před 3 měsíci +6

    Its not for the first timers

  • @officialdau4279
    @officialdau4279 Před 2 měsíci

    I’m an employee. I received my salary in cash only. Can I create a payslip showing the salary I receive, ssnit payment and taxes

  • @jiyasaad5872
    @jiyasaad5872 Před měsícem

    Plz tell me if we make three slips on one page when how it's fill

  • @aneesambalavan9373
    @aneesambalavan9373 Před rokem

    Good

  • @pasuphoenix1321
    @pasuphoenix1321 Před rokem

    Bro while inserting check box nearby showing text like check.

  • @pallaviagarwal7541
    @pallaviagarwal7541 Před 3 měsíci

    Thanks you sir and link please .

  • @cheatdayz1957
    @cheatdayz1957 Před 2 lety

    where is link for salary data sheet tutorial?

  • @srikantjena6078
    @srikantjena6078 Před rokem +17

    Somebody not understand when visiting first time 🙏🏽

  • @itsankit13
    @itsankit13 Před měsícem

    bro u have explained salary sheet in very good way .but u have not explianed about the number to word conversion in easier way

  • @MGTransportServices
    @MGTransportServices Před 2 měsíci

    very informative

  • @gamingchannel3274
    @gamingchannel3274 Před 2 lety

    Sir please help me to create salary slip I will give all my details

  • @Hurainchanel
    @Hurainchanel Před 10 měsíci

    Which cell you put everywhere E7 ???

  • @joykjoy4799
    @joykjoy4799 Před rokem

    How to put signature line?

  • @rajendradeshpande3540
    @rajendradeshpande3540 Před 8 měsíci

    If we want salary slip 3 or 4 nos on a page then how to do?

  • @sekakiven647
    @sekakiven647 Před 2 lety

    Can you help me out with mine?

  • @neiljohntolentino6365
    @neiljohntolentino6365 Před 4 měsíci

    What xcel is compatible for xlookup?

  • @ApaWhale
    @ApaWhale Před 8 měsíci

    How can I get soft copy?

  • @essameltahan5948
    @essameltahan5948 Před 2 měsíci

    Can I get the sheet?
    Is there a link?

  • @sounderraj6001
    @sounderraj6001 Před 10 měsíci

    How to send the payslip through mail id in automation

  • @alavusalim6928
    @alavusalim6928 Před 10 měsíci

    how can we add company logo in the pay slip

  • @bezatigabu174
    @bezatigabu174 Před rokem

    How we can install spell number?

  • @sachinmajotra9665
    @sachinmajotra9665 Před 4 měsíci

    bro can u add that link again , please

  • @jenniferreynolds5143
    @jenniferreynolds5143 Před 6 měsíci

    how do we do this for hourly employee so that we have 52 pay periods per year

  • @vinaykhatri4360
    @vinaykhatri4360 Před rokem

    How to print all salary slip on one to go

  • @romardsable
    @romardsable Před rokem

    i cannot open the xlookup? how ?

  • @sotiofoebenaya253
    @sotiofoebenaya253 Před 3 měsíci

    Please need the automated pay in slips in excel

  • @user-bx4wj3tq8e
    @user-bx4wj3tq8e Před rokem

    how to get xlookup add in ?

  • @user-nt4cm5qg2l
    @user-nt4cm5qg2l Před 4 měsíci

    please send this excel file to download thanks

  • @beautyfull5045
    @beautyfull5045 Před 4 měsíci

    How to Link attendance sheet with this

  • @agnisiantar
    @agnisiantar Před měsícem

    How to move this table into a list?

  • @shivamshukla9649
    @shivamshukla9649 Před rokem

    How i can print 10 or 20 payslip in one go

  • @kl86boy
    @kl86boy Před rokem

    🥰🥰🥰

  • @fourienaude2717
    @fourienaude2717 Před 5 měsíci

    Is the column widths units in cm

  • @beautifulworld9920
    @beautifulworld9920 Před rokem

    Bhai app ye xl file 🗃️ hi upload kr do Jo ap ne benai he

  • @davidn-jc8wb
    @davidn-jc8wb Před 4 měsíci

    How to add company logo

  • @aa--brothers9292
    @aa--brothers9292 Před 10 měsíci

    brother can you help us more in 1 thing

  • @gicyonline4921
    @gicyonline4921 Před 9 měsíci +1

    Is it possible to write a macro to create pdf files for the above process. Want to create the pdf files for all the employees in click.

  • @divclogs397
    @divclogs397 Před rokem

    Yee format share krr doh link mein

  • @mspearl8002
    @mspearl8002 Před 3 měsíci

    Hi, may i know what version of excel is this? Thanks

  • @DeepanjaliParida-vq5bf
    @DeepanjaliParida-vq5bf Před měsícem

    how to generate pdf for each invoice in one shot
    ??

  • @beautifulworld9920
    @beautifulworld9920 Před rokem

    Bhai mujhe ko Bank main apni selery slip jama krwani he Koi mujhe ko selery slip Bena de Maherbani ho gi

  • @nadeemstudio2303
    @nadeemstudio2303 Před rokem

    To kis trha bnaon

  • @guzailiayiabulizi1121

    Thank you, how do I download the individual pay slip in pdf format 🙏🏼

  • @aminkhairo4925
    @aminkhairo4925 Před 10 měsíci

    how about tax ?

  • @nadeemstudio2303
    @nadeemstudio2303 Před rokem

    Hi Bahi main saodi arb m hon

  • @ClouieRemollena
    @ClouieRemollena Před 2 měsíci

    How to save it??

  • @rupalisingh1000
    @rupalisingh1000 Před 11 měsíci

    Can you please provide the link of this salary receipt

  • @Favouriteonetoo74
    @Favouriteonetoo74 Před 9 měsíci

    does this really worked

  • @Entertainment.vedios_
    @Entertainment.vedios_ Před 4 měsíci

    Xlookup not showing in my laptop

  • @GiannisPkTrade
    @GiannisPkTrade Před rokem

    Hey man can you send me the form

  • @bunmi4164
    @bunmi4164 Před rokem

    Please kindly be be slowing down

  • @vinaykhatri4360
    @vinaykhatri4360 Před rokem

    Pdf format

  • @kuyz246
    @kuyz246 Před rokem

    ok

  • @harjyotimedhi1822
    @harjyotimedhi1822 Před rokem

    Picture not clear

  • @DJSONUALAM
    @DJSONUALAM Před 3 měsíci

    download nahi ho raha hai

  • @muhammadsultan2709
    @muhammadsultan2709 Před rokem

    Bro what's your Ms office virsion please replay 😢