saroj gupta
1

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.

From India, Faridabad
s.prerna
1

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, 2682 views)

Wasantha
2

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, 1581 views)

dev7700
2

Find it for doing your needful
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls EXCEL_Formulae01.xls (1.48 MB, 1942 views)

lovekhusi786
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

From Saudi Arabia, Jiddah
navpritsingh
1

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, 2242 views)

dev7700
2

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, 973 views)
File Type: doc Create Currencey converter in excel.doc (25.5 KB, 984 views)

prabhatk349
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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.