Can anybody help me in managing the Employee Data (Record) in MS-Excel?
I have a raw data containing following fields :-
1) Employee ID
2) Employee Name
3) Date of Birth
4) Date of Joining
5) Date of Retirement - Mannually feed (How to Calculate in Excel)
6) Contact No.
7) Blood Group
8) Qualification
Which reports I can generate using the above data?
(e.g. Total Service, Remaining Service, Service Period in a particular Branch etc.)
Any suggessions from yourside?...
In any plz. Mail me on :
From India, Pune
I have a raw data containing following fields :-
1) Employee ID
2) Employee Name
3) Date of Birth
4) Date of Joining
5) Date of Retirement - Mannually feed (How to Calculate in Excel)
6) Contact No.
7) Blood Group
8) Qualification
Which reports I can generate using the above data?
(e.g. Total Service, Remaining Service, Service Period in a particular Branch etc.)
Any suggessions from yourside?...
In any plz. Mail me on :
From India, Pune
Hello Pradeep,
Based on the data given by you, I have just done a rough work in attached excel sheet.
Not clear on what you mean by service period in particular branch. if you have the joining date for a branch, you can use the same formula i.e. =datedif()
Hope this is help for your learning.
Regards
UKmitra
From Saudi Arabia, Riyadh
296Based on the data given by you, I have just done a rough work in attached excel sheet.
Not clear on what you mean by service period in particular branch. if you have the joining date for a branch, you can use the same formula i.e. =datedif()
Hope this is help for your learning.
Regards
UKmitra
From Saudi Arabia, Riyadh
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.
EMPLOYEE RECORD.doc