Dev7700
Mis & Marketing
Prabhatk349
Data Entry Operator
+4 Others

PRIME SPONSOR - FACTOHR - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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.
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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

Attached Files
Membership is required for download. Create An Account First
File Type: ppt excel.ppt (2.62 MB, 2580 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

Attached Files
Membership is required for download. Create An Account First
File Type: ppt All Calculaton can get by three clicking.ppt (794.0 KB, 1531 views)

Find it for doing your needful

Attached Files
Membership is required for download. Create An Account First
File Type: xls EXCEL_Formulae01.xls (1.48 MB, 1843 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
Qasim
Saudi Arab
Madina
Hi, What if i do not have Data Analysis option under tools menu

Attached Files
Membership is required for download. Create An Account First
File Type: xls Data Analysis.xls (92.5 KB, 1880 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.

Attached Files
Membership is required for download. Create An Account First
File Type: pdf Exceltips[1].pdf (270.5 KB, 930 views)
File Type: doc Create Currencey converter in excel.doc (25.5 KB, 940 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
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™