Mis & Marketing
Data Entry Operator
+4 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
I am Saroj , doing my MBA specializing in HR. I want to know, in Hr how excel is used for their work, as I do not have any practical experience in HR, as I am in admin now. Please could you help me, so that I am prepared with it before I join any where for this position.

From India, Faridabad
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

Attached Files
File Type: ppt excel.ppt (2.62 MB, 2606 views)

Dear Saroj,
I have prepared small presentation , how to get all calculation at once. please see the attachment.
(Mean , Standard Error, Median, Mode, Standard Deviation, Sample Variance, Kurtosis, Skew ness, Range, Minimum, Maximum, Sum),
Wasantha Mendries

From Sri Lanka, Ratnapura

Attached Files
File Type: ppt All Calculaton can get by three clicking.ppt (794.0 KB, 1542 views)

Find it for doing your needful
From India, Delhi

Attached Files
File Type: xls EXCEL_Formulae01.xls (1.48 MB, 1861 views)

You need to know good command in excel, it is very useful software, especially to track the category of staff , like how many technican, porter, driver, kitchen staff, and their salary, also to make montly report for hire and fire, then making report for salary progress report, report for new hire and terminated staff, for me best command is Vlookup, it solves many problems, hence try to learn vlookup thru googling. regards
Saudi Arab

From Saudi Arabia, Jiddah
Hi, What if i do not have Data Analysis option under tools menu
From India, Pune

Attached Files
File Type: xls Data Analysis.xls (92.5 KB, 1928 views)

I think I’ve cover everything there. You have to use your brain. Anyway, I would like to post now how to convert numeric to word as well as basic excel tips could help it to beginners.
From India, Delhi

Attached Files
File Type: pdf Exceltips[1].pdf (270.5 KB, 934 views)
File Type: doc Create Currencey converter in excel.doc (25.5 KB, 946 views)

how to convert text into number as= Sixty Six Million Three Hundred Sixty Four Thousand Three Hundred Thirty Four dollars and twenty two cents = 63364334.22
From India, New Delhi
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™