320,917 views 529 on YTPak
1,007 82

Published on 16 Apr 2015 | over 2 years 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 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
Customize Your Hybrid Embed Video Player!

6-digit hexadecimal color code without # symbol.

 

Report video function is under development.

 


Loading related videos...