To ensure that all necessary information is readily available upon opening the employee Muster file in Excel, the following details should be included:
- First Name
- Second Name
- Surname
- Gender
- Date of Birth
- Age
- Education
- Previous Employers
- Date of Joining
- Date of Confirmation
- Date of Leaving
- Salary Increment
- Designation
- PF No.
- ESIC No.
- PAN No.
If there are any other pieces of information that need to be gathered for the Muster file, please provide guidance on what else should be included.
From India, Mumbai
Acknowledge(1)
Amend(0)
1- First Name
- Second Name
- Surname
- Gender
- Date of Birth
- Age
- Education
- Previous Employers
- Date of Joining
- Date of Confirmation
- Date of Leaving
- Salary Increment
- Designation
- PF No.
- ESIC No.
- PAN No.
If there are any other pieces of information that need to be gathered for the Muster file, please provide guidance on what else should be included.
From India, Mumbai
Acknowledge(1)Amend(0)
hi..... Atached is the Master Data format whcih may be useful to you.... (some cells contains formula which needs to taken care) have a nice day... regards Aravind
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Dear Aravind,
I went through the Excel file and found it really helpful. I would like to know what kind of functions can be used in a master file. Is auto filter the best way to filter employees who have left the company? Or is there a way we can pull those employees currently employed with us into another worksheet in the same Excel book?
Thank you.
From India, Mumbai
Acknowledge(0)Amend(0)
I went through the Excel file and found it really helpful. I would like to know what kind of functions can be used in a master file. Is auto filter the best way to filter employees who have left the company? Or is there a way we can pull those employees currently employed with us into another worksheet in the same Excel book?
Thank you.
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Tina,
It can be done either way as both options can be used according to our convenience. I am using an alternative worksheet for maintaining the details of employees who have left. Further options in this have not been explored by me until now.
Regards,
Aravind
From India, Bangalore
Acknowledge(0)Amend(0)
It can be done either way as both options can be used according to our convenience. I am using an alternative worksheet for maintaining the details of employees who have left. Further options in this have not been explored by me until now.
Regards,
Aravind
From India, Bangalore
Acknowledge(0)Amend(0)
Hi Tina,
Master files can be mentioned in 2 formats:
1. Existing Employee data - Department wise (for easy search).
2. Ex-Employee data - Department wise (for easy search).
The contents you mentioned are fine; add 2 more options for that format for a better one:
1. Contact number of the employee for passing any information.
2. Employee Company Email-ID for official mails.
From India, Hyderabad
Acknowledge(0)Amend(0)
Master files can be mentioned in 2 formats:
1. Existing Employee data - Department wise (for easy search).
2. Ex-Employee data - Department wise (for easy search).
The contents you mentioned are fine; add 2 more options for that format for a better one:
1. Contact number of the employee for passing any information.
2. Employee Company Email-ID for official mails.
From India, Hyderabad
Acknowledge(0)Amend(0)
I am currently using Aravind format with a little change since we don't have a salary structure. However, I would still like to know how to pull the current employees' list from the master employee database. Do you think VLOOKUP will help with this? If so, how do we use this command? Is anyone ready to help me with this?
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
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.
Employee Data - Format.xls
10 ways to format Excel data.pdf