sandeepmore_finance Started The Discussion:
I am very glad to post my first assignment on CiteHR. I have use this site more than 4 months and I am very happy with this site which give me large information on Admin, HR, Accounts and Management. Specially I like management, personality development and motivating presentations.
Now it is my turn, So I am attaching this excel sheet. I am confident that you good people will really admire my work.
I have made this excel sheet using Vlookup command and other commands and I assure that these commands will definately help you how to use Vlookup command in excel and its benefits.
I have highlighted some cells in yellow, you just put necessary information in that cell.
You just put attendance in Attadance sheet and it will create Salary Sheet, Pay slip, Bank List, PF ESIC Deduction List and PT summary.
I am eagerly waiting for your response and suggestions. Also I am waiting for new assignments from you.
I will update this excel file time to time and post it on this site.
PASSWORD FOR FILE IS - 090909
:)Thanks & Regards,
(My email ID is )
Found This Useful? +Vote Up This Page Via Google.
Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
Explore Topical Knowledge Areas
Topic Categories >> professional tax personality development pf esic salary break up salary sheet salary attendance pay slip gujarat professional tax Location-India-Mumbai tax calculation general hr Complete List Of Categories
Interesting Relevant Discussions