Usage Of Excel In Hr Function - Pps Download

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
4th June 2007 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
4th June 2007 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.
4th June 2007 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
5th June 2007 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
5th June 2007 From India, Mumbai

Dear Prativa, I am sending you a ppt on excel tips. I hope it may help you. Regards Sameer
7th June 2007 From India, Calcutta

Attached Files (Download Requires Membership)

excel_tips_154.pps (428.5 KB, 2888 views)

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...
7th June 2007 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
7th June 2007 From India, Calcutta