Employee Record Management In Ms-excel - XLS Download

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 : [Login to view]

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