Tag Archives: Free Learn Microsoft Excel 2013

Microsoft Excel Exercise 4 Payroll

In this video learning tutorial you can learn How to Create a Pay Roll of Employees, Basic Pay, Medical Allowance, House Rent, Gross Pay, TAX, Net Pay and Grade in Microsoft Excel 2013 in Urdu and Hindi Language By Sir Muhammad Niaz. Payroll Pay Roll of Employees Name Basic Pay Medical Allowance House Rent Gross Pay Tax Net Pay Grade Javed …

Read More »

Microsoft Excel Exercise 3 Marksheet

In this Video Learning tutorial you can learn How to Create Marks Certificate,  use the SUM( ) Functions to find out the total marks of each student, Calculate the Percentage of each Student and Using IF Functions to assign the Grade in Microsoft Excel 2013 in Urdu and Hindi Language By Sir Muhammad Niaz. Marksheet Marks Certificate Name Math Physics Urdu …

Read More »

Microsoft Excel Exercise 2 COUNTIF

In this video Learning tutorial you can learn how to Create attendance sheet in Microsoft Excel 2013 in Urdu and Hindi Language and you can also learn How to Calculate Total Attendance using COUNTIF Function, How to Calculate Percentage and Calculate Eligible and Not Eligible using IF Function. COUNTIF 5 DAYS ATTENDENCE PAGE Roll No. Name 1 2 3 4 5 Total Attendance % age …

Read More »

Microsoft Excel Exercise 1 Function

In this video Learning Tutorial you can Learn how to use Function (SUM, Average, Minimum, Maximum) in Microsoft Excel 2013 in Urdu and Hindi Language By Sir Muhammad Niaz.  Function Pakistan Printing Press (Expenditures 2013)             Department 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Total Engineering 25676 45451 54533 65651 191,311.00 Marketing 67567 43434 66554 54545 232,100.00 Computer …

Read More »