tinaignu
1

What all information is necessary to be filled in the employee Muster file so that every information is available on just opening an excel sheet
These i think would be necessary
First Name
Second Name
Surname
Gender
Date of Birth
Age
Education
Previous employers
Date of Joining
Date of Confirmation
Date of leaving
Increment of the employee sub titles Salary Date Designation
PF. No,
ESIC No,
Pan No
If there is any other information that i will have to gather in order to make the muster file pls help me

From India, Mumbai
aravind karanth
6

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
Attached Files (Download Requires Membership)
File Type: xls MASTER DATA-citeHR1.xls (18.5 KB, 3532 views)

tinaignu
1

Dear Aravind,
Went thru the excel and was really helpful and would like to know what kind of functions can be used in a master file is auto filter the best way of filtering employees who have left the company
Or there is way we can pull those employees currently employeed with us into another worksheet in the same excel book

From India, Mumbai
aravind karanth
6

Dear Tina... It can be done either way as both options can be used according to our conveience. i am using alternative work sheet for maintaing left employees details.further options in this is not explored by me till now.
regards
Aravind

From India, Bangalore
sujivd2003
3

Hi Tina,
Master files can be mentioned in 2 formates
1. Existing Employees data-Department wise ( for easy search)
2. Ex-Employee data-Department wise ( for easy search )
the contents u mentioned are fine,add 2 more options for that formate for better one
1. Contact number of the employee for passing any information.
2. Employee Company Email-ID for official mails.

From India, Hyderabad
tinaignu
1

I am rt now using aravind format with a little change since we dont have salary structure but still would like to know how to pull the current employee's list from the master employee do you think Vlook up will help in this and how do we use this comand anyone ready to help me on this
From India, Mumbai
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.