Hi Friends, I want to have a grip on Payroll methods...in my company i am looking after the payrolls, but all i do is manually, as my company strength is not too much so i do not face any problem as such, but i hv to know the methods as well..... I heard that there is Vlook up method for the calculation of payroll which big companys use........Do you have any example,or is their any other methods which people normally use?
From India, Delhi
Hi Members, Can anybody share how v & h lookup functions are used in payroll with an example. Also how is pivot table useful in HR job. Thanks & Regards, rakhi krishnakumar
From India, Bangalore
Please note that Vlookup is a formula in excel that helps you to find the data in a particular cell from another cell range.
For instance you have your attendance in sheet1 and the payroll details in sheet2, through vlookup you do not have to manually enter the present days from sheet1 to sheet2. You can check in excel help for more details on the same.
Hope this helps.

From India, Mumbai
thanks for your input dev.....i went through some examples in excel through google.I understood the concept but still not satisfied with its practical application ....can anyone share any worksheet where v-hlook up is used in HR perspective?. Thanks in advance.
Thanks & Regards,
rakhi krishnakumar

From India, Bangalore
Hi Rakhi, Attached herewith is the dummy file. Kindly note that the cells marked in yellow are the cells where I’ve used Vlookup. Regards, "D"
From India, Mumbai

Attached Files
File Type: xls Sample.xls (240.5 KB, 4080 views)

Dear All
Hi !!
I am attaching herewith the Format for Candidates Evaluation Sheet for Personal Interview, we are using in our Company presently. I need some suggestion to revised the same.
Thanks & regards
Sanjay Debnath
Sr. Exctv - HR

From India, Hyderabad

Attached Files
File Type: xls Candidates Evaluation Form.xls (25.5 KB, 3449 views)

Hi Dev, The excel sheet that you have attached is really very useful....I am now able to relate its application into HR function. Million thanks to you:).... Thanks & Regards, rakhi
From India, Bangalore
Hi, We are hiring for our company in Delhi. Best time to call 12pm to 4pm. You can also sms your query. Thanks and Regards, Sandeep Kumar NEw Delhi 9313147924
From India, Mumbai

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 Cite.Co™