akshita_ashu Started The Discussion:
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
Member Opinions In This Discussion
Akshita_ashu
India, Chandigarh
Hr.
Raghudeepala
India, Visakhapatnam
Employee
Perpectuals
India, Selam
Mallet
India, Hyderabad
Senior Analyst - Talent Management
Raghav
India, Kochi
State Hr Manager
Dgshah
India, Vadodara
Service In Engg. Group Having 4 Units As
Shweta_G
India, Mumbai
Asst. Manager Hr
Mansipahwa
India, Delhi
Manager - Hr
V.lakshminarayana Perumal
India, Madras
Staff
Vhemant7
India, Madras
Hr
Nileshs
Service
Tal_vaibhav
India, Mumbai
Company Service
Kunal
India, Hyderabad
Employee
Nagarajsutar
India
Student
Sindhu Rudraiah
India, Bangalore
Executive Hr
Gururajp
India
N/a
Shobhit
India, Mumbai
Hr Executive
Rizu_as1
India, Bangalore
Asst Hr
VRAJSUNDARI
India, Mumbai
Service
Priteshbamania
India, Mumbai
Campus Recruiter
Mitalipatel
India, Mumbai
Hr
+2 Others

Raghav 
Hi Akshita, Attaching a document that would help you. Hope it helps :) Regards, ~Raghav V
Attached FilesProvided by community member Raghav. Register to join your network of peers.
File Type: pdf excel_book_1__134.pdf (478.7 KB, 12092 views)
mallet 
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
Raghav 
Always welcome Ms. Niveditha. Please make use of the "Downloads Search" in the top of the page for any queries. Regards, ~Raghav V
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
Raghav 
My Pleasure Riyaz. And I just posted what i downloaded from this site LONG TIME BACK. All thanks goes to the original author.
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
kunal 
Hello Raghav its a good posting and very much helpful. keep posting this type of inputs thanks and regards krunal mehta pkunalmehta@gmail.com
Hi Attached are documents on excel shortcuts........ Cheers :D Mansi
Attached FilesProvided by community member mansipahwa. Register to join your network of peers.
File Type: xls excel_formula_1_122.xls (60.0 KB, 3770 views)
File Type: pdf excel_shortcuts_148.pdf (17.9 KB, 1699 views)
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






 
 
 
 





Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network