New to HR? Discover How Excel Can Simplify Your Data Management and Reporting Tasks

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

Hi Akshita,

I am attaching a document that would help you. Hope it helps! :)

Regards,
Raghav V

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

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

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

Hi,

Attached are documents on Excel shortcuts.

Cheers :D

Mansi

Hi,

This is Sindhu. Just a month back, I joined this group. Very helpful postings by Raghav, thanks a lot. It helped me a lot in my reports.

Regards,
Sindhu

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.

Dear,

EXCEL is not rocket science; you just need to know important formulas and practice them.

Regards,
Dipti

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

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

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

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

Apologies, I was unable to add the presentation. Please find it attached here.

Hi,

Find attached the file which comprises almost all the functions in Excel.

Thank you.

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

Hey,

The Excel file is not opening. Can you forward it or provide your email ID? I will send you an email.

Please reply.

Mitali

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.

Hi Raghav,

Could you please email me information on how Excel is used in HR functions? I am having trouble opening it.

Thanks in advance.