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 and how to draw border and Formatting in Excel
Akshita
From India, Chandigarh
Akshita
From India, Chandigarh
Hi Akshita, Attaching a document that would help you. Hope it helps :) Regards, ~Raghav V
From India, Kochi
From India, Kochi
Hi Akshita,
Without Excel it would be very difficult to survive in HR. Lot of your day to day activities would include trackers which are excel sheets.
Some of the things that you should be thorough with to maintain data in excel.
1. Formatting - Very important to manage data sheet neatly. Creates an impression!
2. Formula's you need to be thorough with:
1. SUM Function
2. COUNT Function
3. DATE AND TIME FUNCTION
4. Logical Statements like IF and OR
5. VLOOKUP
3. Data Sorting
4. Data Validation
Cheers,
Mallet
From India, Hyderabad
Without Excel it would be very difficult to survive in HR. Lot of your day to day activities would include trackers which are excel sheets.
Some of the things that you should be thorough with to maintain data in excel.
1. Formatting - Very important to manage data sheet neatly. Creates an impression!
2. Formula's you need to be thorough with:
1. SUM Function
2. COUNT Function
3. DATE AND TIME FUNCTION
4. Logical Statements like IF and OR
5. VLOOKUP
3. Data Sorting
4. Data Validation
Cheers,
Mallet
From India, Hyderabad
Always welcome Ms. Niveditha. Please make use of the "Downloads Search" in the top of the page for any queries. Regards, ~Raghav V
From India, Kochi
From India, Kochi
Hi Mr Rahgav,
I am Riyaz from Karnataka Hubli pursuing MBA(HR) final sem from IGNOU I really liked your Article on Excel for HR functions and found it to be very informative.
Thanks a lot Mr Raghav.
Regards
Riyaz
From India, Bangalore
I am Riyaz from Karnataka Hubli pursuing MBA(HR) final sem from IGNOU I really liked your Article on Excel for HR functions and found it to be very informative.
Thanks a lot Mr Raghav.
Regards
Riyaz
From India, Bangalore
Hi Akshita,
Excel is a powerful tool mostly used for the database. Looking to the HR functions like recruitment, training & development, perfomance management, compensation & benefits management, payroll management etc, everywhere we need to maintain,analyse data. How Excel will help is depends upon what the role you currently handling.
You can maintain database in Excel which will help you to do your day today work more comfirtable, easy, accurate and time saving..
How Excel will help in the HR Functions?.
Recruitment:
- Recruitment schedule & status
- Offer & appointment letters
- Confirmation letter
- Extension of probation period
- CTC calculation / comparision
like this in each HR function you can maintain the data in excel. If you need any help in excel please feel free to contact on <nileshs73@gmail.com>
Regards..Nilesh
Excel is a powerful tool mostly used for the database. Looking to the HR functions like recruitment, training & development, perfomance management, compensation & benefits management, payroll management etc, everywhere we need to maintain,analyse data. How Excel will help is depends upon what the role you currently handling.
You can maintain database in Excel which will help you to do your day today work more comfirtable, easy, accurate and time saving..
How Excel will help in the HR Functions?.
Recruitment:
- Recruitment schedule & status
- Offer & appointment letters
- Confirmation letter
- Extension of probation period
- CTC calculation / comparision
like this in each HR function you can maintain the data in excel. If you need any help in excel please feel free to contact on <nileshs73@gmail.com>
Regards..Nilesh
Hi Akshita,
I am a corporate trainer in MS Excel if you want to learn from scratch then please visit this website www.exceltips.com i hope it will help your needs...
Regards,
Gururaj
From India
I am a corporate trainer in MS Excel if you want to learn from scratch then please visit this website www.exceltips.com i hope it will help your needs...
Regards,
Gururaj
From India
Hey hi, This is Sindhu. Jus a month back i joined this group. very helpful postings by Raghav, thanx a lot. It helped me a lot in my reports. Regards, Sindhu
From India, Bangalore
From India, Bangalore
Normally in every department MIS is very important for making MIS reports Excel is the most helpful tool and to find the salary rates and the pay roll can also be generated in excel and we compare the statements and preparing summary reports by using pivot table and V-Lookup options so if we are wellversed with with excel we can prepare MIS faster it will gives good impression.
Raghunath Deepala.
From India, Visakhapatnam
Raghunath Deepala.
From India, Visakhapatnam
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.