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

Get Empowered With Critical Leadership Skills That Drive Change →
Promoted: XLRI Leadership & Change Management
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 (Download Requires Membership)
File Type: ppt excel.ppt (2.62 MB, 2628 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 (Download Requires Membership)
File Type: ppt All Calculaton can get by three clicking.ppt (794.0 KB, 1552 views)

Find it for doing your needful
From India, Delhi

Attached Files (Download Requires Membership)
File Type: xls EXCEL_Formulae01.xls (1.48 MB, 1883 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 (Download Requires Membership)
File Type: xls Data Analysis.xls (92.5 KB, 1987 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 (Download Requires Membership)
File Type: pdf Exceltips[1].pdf (270.5 KB, 944 views)
File Type: doc Create Currencey converter in excel.doc (25.5 KB, 953 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

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply →

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server