No Tags Found!


pradeep_9226776920
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
ukmitra
296

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
Attached Files (Download Requires Membership)
File Type: xls pradeep.xls (21.5 KB, 3695 views)

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.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.