Sr.manager Hr & Legal
Human Resources
Rakesh Ku.
Hr Executive Operations

what are the important parts in pivot table/ chart/, V Lookup and H Lookup that a HR fresher should know.
Dear, Please confirm in details (with complete example in a excel) how to work on pivot table.
Dear Rakesh,
Pivot Table, V Lookup and H Lookup is most important Tools for every HR or say Every Employee in a organization.
These tools help you to deliver very fast result of work/assignments.
Most of these tools are used in to summarized the data. Compilation of data and analysis reports.
Dear Sir, Exactly i want to know what are the areas in Excel, Look up, Pivot table/ chart are to be kept in knowledge so that it would be easy for me to develop my skills in my professional carer.
Dear Rakesh,
It depends upon what type of work you have allotted.
If you have allotted analysis work.. than it is very useful. and one more thing, It can not be exampled in words, if you have facing difficulties in any area. Let us know your problem to direct mail. i will solve in a second.
Dear Rakesh,
Excel have everything you need. If you need prepare monthly, daily MIS, analysis, employee master etc.., you will need excel & many of its functions. do not bother to segregate. Knowledge in excel is requisite for any office staff. Keep your mind open and learn all you can by using it constantly.
All you want is genuine interest, you will find yourself updated everyday.
All the best !!
V lookup , once you understood ,it is very easy. Plan in your mind , put on a paper study your ideas. Then go to V lookup formulae. V Lookup is excellent condtional application. This will be like this... if turn left I need this .. if right this ... Example: If you have some names is 1st sheet. In second sheet you will write some information. Now you can write any thing in Vlookup formulae in second sheet with conditions.. You give any problem. I can give you good line of application.
Dear Rakesh ji, Please see the attachment samples, every hr professional should understand the " Pivot Table, V Look up and H Look up is most important Tools". Regards, PBS KUMAR

Attached Files
Membership is required for download. Create An Account First
File Type: zip PIVOT TABLE SAMPLE.zip (1.56 MB, 810 views)

Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.

Prime Sponsor: TALENTEDGE - Premium Professional Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™