Hi Prativa,
Please help me understand how Excel is used in HR functions. I am new to HR and do not know how Excel is utilized in HR functions. What is its purpose and how can we effectively use it for our work?
I understand that Excel is used for maintaining data and for creating management information system (MIS) reports, but I would appreciate a deeper understanding of its applications in HR.
Thank you for your help.
Best regards,
Prativa
From India, New Delhi
Acknowledge(0)
Amend(0)
2Please help me understand how Excel is used in HR functions. I am new to HR and do not know how Excel is utilized in HR functions. What is its purpose and how can we effectively use it for our work?
I understand that Excel is used for maintaining data and for creating management information system (MIS) reports, but I would appreciate a deeper understanding of its applications in HR.
Thank you for your help.
Best regards,
Prativa
From India, New Delhi
Acknowledge(0)Amend(0)
Hi,
Excel can be used for the maintenance of a database. It can also be used to store all the details of the employees, such as date of joining, designation, personal details, company ID, employee code, etc. Excel can also be used for the maintenance of leave, including the number of casual and sick leaves taken, as well as the number of loss of pay, etc.
Thanks
From India, Bangalore
Acknowledge(0)Amend(0)
Excel can be used for the maintenance of a database. It can also be used to store all the details of the employees, such as date of joining, designation, personal details, company ID, employee code, etc. Excel can also be used for the maintenance of leave, including the number of casual and sick leaves taken, as well as the number of loss of pay, etc.
Thanks
From India, Bangalore
Acknowledge(0)Amend(0)
Hi Prativa,
Shilpa is very much correct regarding the use of Excel in HR functions. You can get a quick view of all the relevant information of an employee if you become familiar with the uses of Excel. It's really a very useful application to keep all the data in a mannered way.
Regards,
Amit Seth
From India, Ahmadabad
Acknowledge(0)Amend(0)
Shilpa is very much correct regarding the use of Excel in HR functions. You can get a quick view of all the relevant information of an employee if you become familiar with the uses of Excel. It's really a very useful application to keep all the data in a mannered way.
Regards,
Amit Seth
From India, Ahmadabad
Acknowledge(0)Amend(0)
Hi Prativa :D,
I agree with Mr. Amit and Ms. Shilpa. You can create an Excel sheet related to workmen and their employment history, background, reports, returns, leave encashment, etc.
It's important and necessary to generate letters in Word. For example, if you want to display vertical data in Word, you can convert Excel data into a Word file using Merge Mail. This function helps you save time on data entry, preparing appointment letters, vertical data (employment history), and more.
Regards,
Sanjeev D
From India, Nasik
Acknowledge(0)Amend(0)
I agree with Mr. Amit and Ms. Shilpa. You can create an Excel sheet related to workmen and their employment history, background, reports, returns, leave encashment, etc.
It's important and necessary to generate letters in Word. For example, if you want to display vertical data in Word, you can convert Excel data into a Word file using Merge Mail. This function helps you save time on data entry, preparing appointment letters, vertical data (employment history), and more.
Regards,
Sanjeev D
From India, Nasik
Acknowledge(0)Amend(0)
Hi You can process salary through excel. Its very easy to process. V look Up and Pivot table are also very useful. Chetan
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Pivot Tables- 10114927.pdf
HR Job Functions.doc