No Tags Found!


Hi Everyone, Can any one help me with the format of Recruitment MIS (Spreadsheet with required formula’s). This is little urgent and will be a great help. Regards, Bhaskar :?
From India, Bangalore
Acknowledge(0)
Amend(0)

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

From India, New Delhi
Acknowledge(0)
Amend(0)

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

From India, New Delhi
Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.