Hi, please help me understand how Excel is used in HR functions. As I am new to HR, I don't know the specific usage of Excel in HR functions. I understand that we use Excel for maintaining data and for creating MIS reports, but I would appreciate a deeper explanation on its use and how to utilize features such as drawing borders and formatting in Excel.
Thank you,
Akshita
From India, Chandigarh
Thank you,
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. A 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 a good impression!
2. Formulas you need to be thorough with:
- SUM Function
- COUNT Function
- DATE AND TIME FUNCTIONS
- Logical Statements like IF and OR
- VLOOKUP
3. Data Sorting
4. Data Validation
Cheers,
Mallet
From India, Hyderabad
Without Excel, it would be very difficult to survive in HR. A 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 a good impression!
2. Formulas you need to be thorough with:
- SUM Function
- COUNT Function
- DATE AND TIME FUNCTIONS
- Logical Statements like IF and OR
- 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. Raghav,
I am Riyaz from Karnataka, Hubli, pursuing MBA (HR) final semester 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 semester 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 at the HR functions like recruitment, training & development, performance management, compensation & benefits management, payroll management, etc., we need to maintain and analyze data everywhere. How Excel will help depends on the role you are currently handling.
You can maintain a database in Excel, which will help you do your day-to-day work more comfortably, easily, accurately, and time-saving. How will Excel help in HR functions?
Recruitment:
- Recruitment schedule & status
- Offer & appointment letters
- Confirmation letter
- Extension of probation period
- CTC calculation/comparison
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 at nileshs73@gmail.com.
Regards,
Nilesh
Excel is a powerful tool mostly used for the database. Looking at the HR functions like recruitment, training & development, performance management, compensation & benefits management, payroll management, etc., we need to maintain and analyze data everywhere. How Excel will help depends on the role you are currently handling.
You can maintain a database in Excel, which will help you do your day-to-day work more comfortably, easily, accurately, and time-saving. How will Excel help in HR functions?
Recruitment:
- Recruitment schedule & status
- Offer & appointment letters
- Confirmation letter
- Extension of probation period
- CTC calculation/comparison
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 at nileshs73@gmail.com.
Regards,
Nilesh
Hi Akshita,
I am a corporate trainer in MS Excel. If you want to learn from scratch, please visit this website www.exceltips.com. I hope it will meet your needs.
Regards,
Gururaj
From India
I am a corporate trainer in MS Excel. If you want to learn from scratch, please visit this website www.exceltips.com. I hope it will meet 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, Management Information System (MIS) is very important for creating MIS reports. Excel is the most helpful tool for finding salary rates and generating payroll. We can also compare statements and prepare summary reports using pivot tables and V-Lookup options. Therefore, being well-versed with Excel enables us to prepare MIS faster, leaving a good impression.
Raghunath Deepala.
From India, Visakhapatnam
Raghunath Deepala.
From India, Visakhapatnam
hai........ Download and use this file.This is my own preparation I think it is usefull to you. if any doubt plz contact:9786859279 by V.L.N.Perumal Puducherry.
From India, Madras
From India, Madras
Dear, EXCEL is not a rocket science...u just need to know imp formula’s & practice it. Regards, Dipti
From India, Mumbai
From India, Mumbai
Hi Raghav 😂 and Malet 😂!
Well, thank you a lot for providing information on important parts of Excel. I would like to thank Raghav for providing books on Excel. I think this book will be valuable to all members, and I'll be able to learn Excel with the help of this book.
So thanks again 😊
Akshita 😜
From India, Chandigarh
Well, thank you a lot for providing information on important parts of Excel. I would like to thank Raghav for providing books on Excel. I think this book will be valuable to all members, and I'll be able to learn Excel with the help of this book.
So thanks again 😊
Akshita 😜
From India, Chandigarh
Respected ma'am,
As you are new, you might not be aware, but with this gift of an executable file, you can perform mail merge during the performance appraisal. Additionally, you can handle your payroll and employee details as well.
With regards,
Shobhit Dwivedi
From India, Mumbai
As you are new, you might not be aware, but with this gift of an executable file, you can perform mail merge during the performance appraisal. Additionally, you can handle your payroll and employee details as well.
With regards,
Shobhit Dwivedi
From India, Mumbai
Dear Akshita,
There are so many formulas and functions in Excel that you can use for data processing. Please let me know where you are facing problems.
Regards,
Nagaraj Sutar Officer HR Rajashree Cement Aditya Birla Group
From India
There are so many formulas and functions in Excel that you can use for data processing. Please let me know where you are facing problems.
Regards,
Nagaraj Sutar Officer HR Rajashree Cement Aditya Birla Group
From India
Hello Nagaraj Sir!!
Well, I really have difficulty in drawing borders in Excel and also how to use formulas. Actually, I haven't worked on Excel, so can you provide me with some guidelines on how to use Excel with examples? Please help me in learning Excel.
Thanks,
Akshita
From India, Chandigarh
Well, I really have difficulty in drawing borders in Excel and also how to use formulas. Actually, I haven't worked on Excel, so can you provide me with some guidelines on how to use Excel with examples? Please help me in learning Excel.
Thanks,
Akshita
From India, Chandigarh
Hi Akshita,
Please find here the PowerPoint presentation for Excel. I hope it will help you!
Don't worry, dear. It is not as tough as you are thinking. You will be comfortable with Excel only by using it. First, start using it, don't get panicked. OK.
Thanks & Regards,
Shweta G
From India, Mumbai
Please find here the PowerPoint presentation for Excel. I hope it will help you!
Don't worry, dear. It is not as tough as you are thinking. You will be comfortable with Excel only by using it. First, start using it, don't get panicked. OK.
Thanks & Regards,
Shweta G
From India, Mumbai
Hi,
Excel is very useful in HR. You can fill PF challans, ESIC challans, and a lot of other functions automatically. For small industries, it helps in processing salary. You can learn it by using it and taking help provided in it.
Regards,
Vaibhav
From India, Mumbai
Excel is very useful in HR. You can fill PF challans, ESIC challans, and a lot of other functions automatically. For small industries, it helps in processing salary. You can learn it by using it and taking help provided in it.
Regards,
Vaibhav
From India, Mumbai
hey the excel is not opening can u reforwrd it or give ur email id i wil put a mail to u plz reply mitali
From India, Mumbai
From India, Mumbai
Dear Seniors & Friends,
I am an MBA in HR (2007 graduate) from Chennai. My passion is to work in the HR domain and acquire a good knowledge of all HR functions. Unfortunately, I had to join as a Tech Support Executive during the 4th project semester of my MBA to help my family situation. I have been working as a TSE for about 1.5 years in a reputed BPO.
Now, after being exhausted from night shifts, I think it's high time to start my career. I have started searching for HR jobs, preferably in the IT/Telecom sectors, but have not found one suitable as companies ask for 6 months to 1 year of experience from candidates, pushing back my candidacy.
1) I want to know if my experience is valuable? [I was truly one of the best performers at my job]. I definitely do not want my 1.5 years of experience to go to waste!
2) Also, can anyone tell me: Am I late to pursue an HR job as a fresher candidate in corporates? Or should I try consultancy firms and gain experience there for 6 months to 1 year, which I don't mind, as long as it is beneficial.
Please guide me, Gurus!
Thank you.
From India, Madras
I am an MBA in HR (2007 graduate) from Chennai. My passion is to work in the HR domain and acquire a good knowledge of all HR functions. Unfortunately, I had to join as a Tech Support Executive during the 4th project semester of my MBA to help my family situation. I have been working as a TSE for about 1.5 years in a reputed BPO.
Now, after being exhausted from night shifts, I think it's high time to start my career. I have started searching for HR jobs, preferably in the IT/Telecom sectors, but have not found one suitable as companies ask for 6 months to 1 year of experience from candidates, pushing back my candidacy.
1) I want to know if my experience is valuable? [I was truly one of the best performers at my job]. I definitely do not want my 1.5 years of experience to go to waste!
2) Also, can anyone tell me: Am I late to pursue an HR job as a fresher candidate in corporates? Or should I try consultancy firms and gain experience there for 6 months to 1 year, which I don't mind, as long as it is beneficial.
Please guide me, Gurus!
Thank you.
From India, Madras
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.