Need Urgent Help with Recruitment MIS Spreadsheet Format and Formulas!

Hi Everyone,

Can anyone help me with the format of Recruitment MIS (spreadsheet with required formulas)? This is a little urgent and will be a great help.

Regards,
Bhaskar

Hi,

I don't have the format with me, but I can guide you on the theoretical aspects that will help you create a new format according to your specifications. I am defining the contents sheet-wise.

First Sheet - Details of Employee:
a. E. Code
b. Name of Employee
c. Date of Birth
d. Designation
e. CTC
f. Address for Communication
g. Permanent Address
h. Contact Number
i. Blood Group
j. Maximum Qualification
k. Extra Qualification
l. Total Experience

Second Sheet - Salary Structure:
In this sheet, write down the complete salary structure and create a column for salary after any revision.

Third Sheet - New Joinees:
In this sheet, write down the names of new joiners of that month with details like CTC, Designation, DOB, etc.

Fourth Sheet - Resigned Employees:
In this sheet, write the names of employees who resigned during that particular month with details like name, designation, date of joining, date of resignation, last working day.

Fifth Sheet - Attrition Rate.

Regards,
HR_Pro

Hi,
I don't have the format with me, but I can guide you on the theoretical aspects that will help you to create a new format according to your specifications. I am defining the contents sheet-wise.

First Sheet - Details of employee:
a. E.Code
b. Name of employee
c. Date of birth
d. Designation
e. CTC
f. Address for communication
g. Permanent address
h. Contact number
i. Blood group
j. Maximum qualification
k. Extra qualification
l. Total Experience

Second Sheet - Salary structure:
In this sheet, write down the complete salary structure and create a column for the salary after any revision.

Third Sheet - New Joinees:
In this sheet, write down the names of new joiners of that month with details like CTC, Designation, DOB, etc.

Fourth Sheet - Resigned employees:
In this sheet, write the names of employees who resigned during that particular month with details like name, designation, date of joining, date of resignation, and last working day.

Fifth Sheet - Attrition rate.

Regards,
Hr_pro