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
Business Development, Employee Relations,
Dtp, Diploma In Computer Operations

Use factoHR and automate your HR processes

Mobile-first hire to retire HR and Payroll software that automates all HR operations and works as a catalysts for your organisational growth.


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.

From Saudi Arabia, Riyadh

Attached Files (Download Requires Membership)
File Type: xls pradeep.xls (21.5 KB, 3667 views)

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2022 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server