Hi,
plz help me how Excel is used in HR Function.
As I am new in HR,I don't know the usage of Excel in HR Function
For what we use it and how we use it to do our work properly...
As I know for maintaining data we use Excel,for MIS we use Excel,
but plz help me to go deeper in this..
Prativa
From India, New Delhi
plz help me how Excel is used in HR Function.
As I am new in HR,I don't know the usage of Excel in HR Function
For what we use it and how we use it to do our work properly...
As I know for maintaining data we use Excel,for MIS we use Excel,
but plz help me to go deeper in this..
Prativa
From India, New Delhi
Hi,
Excel can be used for the maintainance of data base,
it can also be used to store all the details of the employees, like date of joining, designation, personal details, company id, employee code etc
Excel can also be used for the maintainance of leave, number of casual, sick leaves taken, number of loss of pay etc
Thanks
From India, Bangalore
Excel can be used for the maintainance of data base,
it can also be used to store all the details of the employees, like date of joining, designation, personal details, company id, employee code etc
Excel can also be used for the maintainance of leave, number of casual, sick leaves taken, number of loss of pay etc
Thanks
From India, Bangalore
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 informations of an employee if you become familiar with teh uses of Excel. Its really a very useful application to keep all the data in a mannered way..
Regards,
Amit Seth.
From India, Ahmadabad
Shilpa is very much correct regarding the use of Excel in Hr functions..
You can get a quick view of all the relevant informations of an employee if you become familiar with teh uses of Excel. Its really a very useful application to keep all the data in a mannered way..
Regards,
Amit Seth.
From India, Ahmadabad
Hi Prativa
:D I agree with Mr. Amit & Ms. Shilpa
you can make a sheet in excel related workmen and their employment history, background, reports and returns leave incashment etc.
it's important and necessary to make letters in word i.e. suppose you want vertical data in word you can convert excel data in word file through Merge Mail. Due to this function, you can save your time for Feeding data, preparing Appoinment letter, Vertical Data (Employment History) etc.
regards
Sanjeev d
From India, Nasik
:D I agree with Mr. Amit & Ms. Shilpa
you can make a sheet in excel related workmen and their employment history, background, reports and returns leave incashment etc.
it's important and necessary to make letters in word i.e. suppose you want vertical data in word you can convert excel data in word file through Merge Mail. Due to this function, you can save your time for Feeding data, preparing Appoinment letter, Vertical Data (Employment History) etc.
regards
Sanjeev d
From India, Nasik
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
From India, Mumbai
Dear Prativa, I am sending you a ppt on excel tips. I hope it may help you. Regards Sameer
From India, Calcutta
From India, Calcutta
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
From India, Pune
Dear ZSK 85,
what is your? name are you from robotic age?
To understand pivot table pl type or paste the following link on your internet browser.
http://office.microsoft.com/training/training.aspx? AssetID=RC010136191033
Sameer
From India, Calcutta
what is your? name are you from robotic age?
To understand pivot table pl type or paste the following link on your internet browser.
http://office.microsoft.com/training/training.aspx? AssetID=RC010136191033
Sameer
From India, Calcutta
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.