Excel - Ppt Download

Hi,
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.

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

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

Find it for doing your needful

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
Qasim
Saudi Arab
Madina

Hi, What if i do not have Data Analysis option under tools menu

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.

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