Prativa
2

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
shilpa.u
9

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
Amitmhrm
496

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
sanjeev d
3

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
Chetan W
4

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
Sameeroflko
7

Dear Prativa, I am sending you a ppt on excel tips. I hope it may help you. Regards Sameer
From India, Calcutta
Attached Files (Download Requires Membership)
File Type: pps excel_tips_154.pps (428.5 KB, 2890 views)

zsk85
11

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
Sameeroflko
7

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
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.