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(1)
Amend(0)
5Thank you,
Akshita
From India, Chandigarh
Acknowledge(1)Amend(0)
Hi Akshita, Attaching a document that would help you. Hope it helps :) Regards, ~Raghav V
From India, Kochi
Acknowledge(8)
Amend(0)
From India, Kochi
Acknowledge(8)+3 more
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(5)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(5)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(3)
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(3)Amend(0)
Hi Attached are documents on excel shortcuts........ Cheers :D Mansi
From India, Delhi
Acknowledge(5)Amend(0)
From India, Delhi
Acknowledge(5)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)
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)
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(1)
Amend(0)
Acknowledge(1)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(1)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(1)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)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
HR policy excel.doc