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)
Dear Prativa, I am sending you a ppt on excel tips. I hope it may help you. Regards Sameer
From India, Calcutta
Acknowledge(0)Amend(0)
From India, Calcutta
Acknowledge(0)Amend(0)
hey, i know excel is very important in HR, but why do we do pivoting? and what exactly is it and how do we do it? i find it so confusing...
From India, Pune
Acknowledge(0)Amend(0)
From India, Pune
Acknowledge(0)Amend(0)
Dear ZSK 85,
What is your name? Are you from the robotic age?
To understand pivot tables, please type or paste the following link into your internet browser: http://office.microsoft.com/training/training.aspx? AssetID=RC010136191033
Sameer
From India, Calcutta
Acknowledge(0)Amend(0)
What is your name? Are you from the robotic age?
To understand pivot tables, please type or paste the following link into your internet browser: http://office.microsoft.com/training/training.aspx? AssetID=RC010136191033
Sameer
From India, Calcutta
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.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
MS-EXCEL - INTRODUCTION TO PIVOT TABLES.pdf