how to make ms excel attendance sheet

 how to make microsoft excel attendance sheet free online

 how to make microsoft excel attendance sheet free offline

 how to make microsoft excel attendance sheet free withe ms excel

Today I am going to tell you the exel attendance sheet.

Ms excel is known as mostly used software/database system.

It is the product of Microsoft (Bill gates).

Now ms excel widely used in all offices of all world 🌎  regions.

Now come to the topic

It is an easy way to use excel formulas for making sheet more efficient.

All institutes are required to maintain the record of employee’s daily routines but there came fault by the officer/fourman/supervisor. Now a days excel made the easy task let’s  take some steps and practical yourself.

The supervisor does not need to worry about making bills of salary to the employee .

Just put some formulas in excel and enjoy, save time, have fun also.

Step1:

Open the excel sheet.

Step2:

Create new excel file/sheet.

Enter the names of employers with their designation.

Like

1	Azhar	officer
2	Nazar	owner
3	Mazhar	admin
4	Aalia	admin

 

Step3:

Now put the month’s days in excel sheet. you can  also search for Microsoft excel online , Microsoft office excel online for the work or Offline.

Step4

Put the word “p” for present before every employee date entery, “a” for Absent and “s” for Sunday. Now the sheet will as follows.

attendance sheet
s.no	employee name	designation	1	2	3	4	5	6	7
			sun	mon	tue	wed	thu	fri	sat
1	azhar	Officer	S	p	a	p	p	p	p
2	nazar	owner	S	p	a	p	p	p	p
3	mazhar	admin	S	p	p	a	p	p	p
4	Aalia	admin	S	p	A	A	p	a	a

 

Step5:

Now come to the main point,  you have to enter the formula “Countif(range,criteria)”.for example if we want the attendance details of employee  namely Azhar we will put the formula at the end of azhar like =COUNTIF(D4:K4,"P") it means that we selected the range from D3 column to J3 column and select the criteria “P” for present,”A” for absent and S for Sunday (if you pay the employees Sunday leave then add it to the present creteria) result will shown as follows:

Present	Absent	Sunday leave
0
6	1	1
6	1	0
6	1	1
6

Now the total attendance of employees have been calculated you have to multiply the salary of an employee to the working days. The total salary will be the result.

Like 6 working days and each daly salary is 150 simply enter the Microsoft excel formula, ms excel formula for =L3*150 in any column ( L is the Present entery cell, 150 is daily wage of employee)  of your active ms excel sheet, similary drag the formula below this entery. All employees salary result will be there with the single click ms excel. This is the result

 

daily wage salay of an employee	150
azhar's weekly salary	900
nazar's weekly salary	900
mazhar's weekly salary	900
aalia weekly salary	900

 

This is the entry with the formulas: the L4 is total present entry and D11 is the daily wage. You can also drag the formula to lower cells by pressing F4 function key 🗝 for locking the D11 same wage of every employee.

daily wage salay of an employee	150
azhar's weekly salary	=L4*D11
nazar's weekly salary	=L5*D11
mazhar's weekly salary	=L6*D11
aalia weekly salary	=L7*D11

 

Ms excel is very important in every field of like. Learn ms excel free online. Online Microsoft excel free. Excel for beginners in hindi.