Can anybody help me in managing the Employee Data (Record) in MS-Excel?
I have raw data containing the following fields:
1) Employee ID
2) Employee Name
3) Date of Birth
4) Date of Joining
5) Date of Retirement - Manually feed (How to Calculate in Excel)
6) Contact No.
7) Blood Group
8) Qualification
Which reports can I generate using the above data?
(e.g. Total Service, Remaining Service, Service Period in a particular Branch, etc.)
Any suggestions from your side?
In any case, please email me at: pradeep_9226776920@rediffmail.com
From India, Pune
Acknowledge(0)
Amend(0)
I have raw data containing the following fields:
1) Employee ID
2) Employee Name
3) Date of Birth
4) Date of Joining
5) Date of Retirement - Manually feed (How to Calculate in Excel)
6) Contact No.
7) Blood Group
8) Qualification
Which reports can I generate using the above data?
(e.g. Total Service, Remaining Service, Service Period in a particular Branch, etc.)
Any suggestions from your side?
In any case, please email me at: pradeep_9226776920@rediffmail.com
From India, Pune
Acknowledge(0)Amend(0)
Hello Pradeep,
Based on the data provided by you, I have just completed some initial work in the attached Excel sheet. I am unclear on what you mean by "service period in a particular branch." If you have the joining date for a branch, you can use the same formula, i.e. =DATEDIF().
I hope this is helpful for your learning.
Regards,
UKmitra
From Saudi Arabia, Riyadh
Acknowledge(0)Amend(0)
297Based on the data provided by you, I have just completed some initial work in the attached Excel sheet. I am unclear on what you mean by "service period in a particular branch." If you have the joining date for a branch, you can use the same formula, i.e. =DATEDIF().
I hope this is helpful for your learning.
Regards,
UKmitra
From Saudi Arabia, Riyadh
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.