In this tutorial you 'll learn: How to Make Salary Sheet Using Microsoft Excel, this is Excel Advance tutorial training in Urdu and Hindi language which is all about how to make a salary sheet with easy a formula and easy way.
Watch Microsoft Office All Urdu/Hindi Training Tutorials: bit.ly/2eH5crM
What is Ms office?
Ms office is an application program which is using for different purpose like Ms word using for application, form & letter use, excel for sheet, math formula & many other offices related usage most popular Access for database & powerpoint for presentation, etc.
How to create Salary sheet ? for those people who didn't understand Urdu/Hindi language
First of all open Excel program & type following value in each cell.
1: E no Serial number like 1,2,3,4
2: Name Worker name
3: Designation Manger, CEO, etc
4: Department Name of Department
5: Basic Put basic salary like $1000
6: Attendance How much attendance of employ in month
7: Salary Basic x attendance/30)= salary
8: House Rent Basic x 45%=house rent
9: Convince Attendance x $1=daily convince
10: Gross Salary+House rent+ Convince = Gross
11: Income text If gross grater then symbols 10000, GpfundGross x 5%=I.Text
12: GP fund Gross x 8GP fund
13: Total Deduction Income text+ Gp fund=T Deduction
14: Net salary Gross - Total deduction=Net salary
Please subscribe on "Urdu/Hindi Tutorials" Channel for more update tutorials: bit.ly/2dtgDQO
Join Our Facebook Helping Group: bit.ly/2dbZxaK
Like Our Urdu/Hindi Tutorials Official Facebook Page and update yourself: bit.ly/2f051V2
Note: if you have any question about this tutorial so you can ask in comment box Thanks