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
Acknowledge(0)
Amend(0)
5Thank you,
Akshita
From India, Chandigarh
Acknowledge(0)Amend(0)
Hi Akshita, Attaching a document that would help you. Hope it helps :) Regards, ~Raghav V
From India, Kochi
Acknowledge(0)Amend(0)
From India, Kochi
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Kochi
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
Hi Attached are documents on excel shortcuts........ Cheers :D Mansi
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
Raghunath Deepala.
From India, Visakhapatnam
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Madras
Acknowledge(0)Amend(0)
Dear, EXCEL is not a rocket science...u just need to know imp formula’s & practice it. Regards, Dipti
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
hi find attached the file which has a comprises of almost all the functions in excel..
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)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.
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
HR policy excel.doc
Excel References in Cite HR.pptx