Hi, I am Saroj, doing my MBA specializing in HR. I want to know how Excel is used in HR work, as I do not have any practical experience in HR; currently, I am in administration. Could you please help me so that I am prepared when I join a position in this field?
Thank you.
From India, Faridabad
Acknowledge(1)
Amend(0)
1Thank you.
From India, Faridabad
Acknowledge(1)Amend(0)
you should know the basics as well as features as Vlook up etc. In HR excel is used to store data and analyse it,so be up with that
From India, Patna
Acknowledge(1)Amend(0)
From India, Patna
Acknowledge(1)Amend(0)
Dear Saroj,
I have prepared a small presentation on how to get all calculations at once. Please see the attachment which includes the following calculations: Mean, Standard Error, Median, Mode, Standard Deviation, Sample Variance, Kurtosis, Skewness, Range, Minimum, Maximum, and Sum.
Wasantha Mendries
From Sri Lanka, Ratnapura
Acknowledge(0)Amend(0)
I have prepared a small presentation on how to get all calculations at once. Please see the attachment which includes the following calculations: Mean, Standard Error, Median, Mode, Standard Deviation, Sample Variance, Kurtosis, Skewness, Range, Minimum, Maximum, and Sum.
Wasantha Mendries
From Sri Lanka, Ratnapura
Acknowledge(0)Amend(0)
You need to have a good command of Excel. It is a very useful software, especially for tracking the categories of staff, such as the number of technicians, porters, drivers, kitchen staff, and their salaries. Additionally, it is useful for creating monthly reports for hiring and firing, tracking salary progress, reporting on new hires and terminated staff. In my opinion, the best function to use is VLOOKUP, as it can solve many problems. I recommend learning how to use VLOOKUP by searching for tutorials online.
Regards,
Qasim
Saudi Arabia
Madinah
From Saudi Arabia, Jiddah
Acknowledge(0)Amend(0)
Regards,
Qasim
Saudi Arabia
Madinah
From Saudi Arabia, Jiddah
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.
Excel Functions Dictionary.xls
10 ways to format Excel data.pdf
HR policy excel.doc