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
Acknowledge(0)
Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
306Based 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
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
EMPLOYEE RECORD.doc