How Is Excel Used in HR? Seeking Practical Insights for a Future Role

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.

You should know the basics as well as features such as VLOOKUP, etc. In HR, Excel is used to store data and analyze it, so be familiar with that.

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

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

I think I've covered everything here. You have to use your brain. Anyway, I would like to post now on how to convert numeric to words, as well as basic Excel tips that could help beginners.