what are the important parts in pivot table/ chart/, V Lookup and H Lookup that a HR fresher should know.
From India, Bangalore
2From India, Bangalore
Dear, Please confirm in details (with complete example in a excel) how to work on pivot table.
From India, Bangalore
From India, Bangalore
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.
Thanks
From India, Jaipur
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.
Thanks
From India, Jaipur
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.
From India, Bangalore
From India, Bangalore
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.
Thanks
From India, Jaipur
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.
Thanks
From India, Jaipur
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 !!
From India, Gurgaon
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 !!
From India, Gurgaon
Hi,
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.
Hrkpati
From India, Guwahati
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.
Hrkpati
From India, Guwahati
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.
Pivot Table.pdf
Pivot table.doc
Sample Pivot Table -Timesheet.xls