Make a Salary Slip in Excel | Automatic Salary Pay Slip in 5 Minutes
Вставка
- Опубліковано 20 сер 2024
- 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
Download free Invoice Templates: bit.ly/3Fo2fak
can you share this slip through link of excel file
not working brother please intiate a new link
Format dose not opening
Hi
Thank you!!! This is a really excellent tutorial. Clear and concise. Many thanks!
My Pleasure ❤️
This is exactly what I needed. Making an allowance salary sheet for my kids.
Glad it helped you
Thank you, It's quite simple and helpful.
GOD Bless you always.
Thanks Very informative and helpfull vedio.
This is very useful thank you.
Glad it was helpful!
Very helpful video.. Thank you very much for sharing 🌼
Glad it helped 😊
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.
Thank you so much Bro, it helped me a lot. God bless you, please don't stop making videos.😎💞
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
This was really helpful, thank you 😊
❤️
অনেক কিছু শিখতে পারলাম ভাই
Thank you so much its so easiest my works
Thanks so much for this.! Can you please Make a easy and simple way Salary Sheet
Thanks 🙏🏻 sure I will
Its not for the first timers
Wowww thanks ❤❤❤❤❤
❤️
Somebody not understand when visiting first time 🙏🏽
Like me
So true😂😂
I love youuuuu. Thank you so much for this video its a great help!❤❤❤
@jessielyn
I'm Glad it helped you ❤️
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...
Good job
What we do,
when we have to mentioned employee present / absence date and over time in salary slip
Very useful information video. Thanks for your valuable support and update sir.
Happy to hear that.. Keep supporting
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 ?
Thank you.Great work.
bro u have explained salary sheet in very good way .but u have not explianed about the number to word conversion in easier way
Thnk u brthr YOU MAKE IT one video PERFECT excel plz brthr step py step🙏🙏🙏
Great work, thank u brother, keep going...
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
You make it very very fast 👍🏽
Thank you for sharing with us and its very easy.
Excellent Information
very informative
Glad it was helpful!
I subscribe as I like❤❤
Thank you 🎉
❤️
Thank you you so much. May I know how to add OT hour Late minutes extra plz
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
What xcel is compatible for xlookup?
O365
Thanks. It was very helpful. Can we copy paste and apply it for every month? Or there is any other method?
Is there any method to generate a pay slip with the help of pivot table?
Nice video👍👍
please kindly send all the youtube videos as text or writing so that I can practise thank you
Thank you
its great bro now can tell me how to add a developer tab to my ribbons
On the File tab, go to Options > Customize Ribbon.
Under Customize the Ribbon and under Main Tabs, select the Developer check box
@@LearnforFuture Thanks for to show up
Plz tell me if we make three slips on one page when how it's fill
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?
Great one
Is there a way to print them all without having to change emp ID and print one individually?
Excellent
Thanks!
How to move this table into a list?
This is Great
Thanks u so much
Can we use it with multiple invoice?
If we want salary slip 3 or 4 nos on a page then how to do?
how you deleted the g h i j colums kindly help
how do we do this for hourly employee so that we have 52 pay periods per year
Thanks you sir and link please .
How to send the payslip through mail id in automation
Please need the automated pay in slips in excel
bro can u add that link again , please
Hi Bahi main saodi arb m hon
how to generate pdf for each invoice in one shot
??
if i will add new salary data in sheet 2, will it come in sheet 1?
Can I get the sheet?
Is there a link?
how can we add company logo in the pay slip
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.
How to Link attendance sheet with this
Earnings side what should we add for seed processing company
Good
How do you write a VBA code to print them one by one boss??
Xlookup not showing in my laptop
Bro while inserting check box nearby showing text like check.
brother can you help us more in 1 thing
Which cell you put everywhere E7 ???
trying to enter the data validation but it can't source the salary sheet bro....
please send this excel file to download thanks
Why I can't get the same column width.. Is it I need to change " to cm?
How to print all salary slip on one to go
Hi, may i know what version of excel is this? Thanks
O365
How i can print 10 or 20 payslip in one go
how to get xlookup add in ?
Is the column widths units in cm
Inches
i cannot open the xlookup? how ?
How to add company logo
How we can install spell number?
How can I get soft copy?
How to save it??
GOOD VIDEO BUT YOU ARE SO FAST .. HARD TO UNDERSTAND .. AND HAVE PAUSE YOUR VIDEO TIME TO TIME..
How to put signature line?
😢 In your video it's not clear view of your Excel sheet what format your are using
Sir please help me to create salary slip I will give all my details
Yee format share krr doh link mein
Bhai app ye xl file 🗃️ hi upload kr do Jo ap ne benai he
where is link for salary data sheet tutorial?
Bhai mujhe ko Bank main apni selery slip jama krwani he Koi mujhe ko selery slip Bena de Maherbani ho gi
Please kindly be be slowing down
download nahi ho raha hai
Can you help me out with mine?
does this really worked
How can I get a soft copy?
how about tax ?
To kis trha bnaon
Developer option nhi hai and Column width ka option v nahi hai
You need to enable that Developer option