How to make Salary Sheet using Microsoft excel (Excel Advance Urdu Hindi)

Title : How to make Salary Sheet using Microsoft excel (Excel Advance Urdu Hindi)
Duration : 20:30
Channel : Urdu Hindi Tutorials
Label : How to make Salary Sheet using Microsoft excel, Excel, Urdu, Hindi, tutorial, in free, How to, (Excel Advance Urdu Hindi), Urdu Hindi tutorials, How to create sheet in excel, microsoft, excel 2007, 2003, 2010, 2015, 2014, 2013, 2016, 2009, 2001, 2000, ms excel, ms office, salary sheet, in excel, daily salary sheet im ms office, ms office program

How to make Salary Sheet using Microsoft excel (Excel Advance Urdu Hindi)

In this tutorial you 'll learn: How to make Salary Sheet using Microsoft excel, this is Excel Advance tutorial in Urdu and Hindi language. Urdu & Hindi training by: www.MickeyTuts.com 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 -------------------------------------------------------------------------------------- Note: if you have any qustion about this tutorial so you can ask in comment box Thanks

Download Video How to make Salary Sheet using Microsoft excel (Excel Advance Urdu Hindi)