122,719 views 344 on YTPak
300 15

Published on 16 Apr 2015 | about 1 year ago

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 forumal and easy ways.

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 purpose , excel for sheet,math formula & many other office related usage most popular Access for database & power point 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: Convence Attendance x $1=daily convance
10: Gross Salary+House rent+ Convance = Gross
11: Income text If gross grater then symbol 10000,Gross x 5%=I.Text
12: GP fund Gross x 8.33%= Gpfund
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 qustion about this tutorial so you can ask in comment box Thanks

Loading related videos...