what are the important parts in pivot table/ chart/, V Lookup and H Lookup that a HR fresher should know.
From India, Bangalore
Acknowledge(0)
Amend(0)
2From India, Bangalore
Acknowledge(0)Amend(0)
Dear, Please confirm in details (with complete example in a excel) how to work on pivot table.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Dear Rakesh,
Pivot Table, VLOOKUP, and HLOOKUP are the most important tools for every HR or every employee in an organization. These tools help you deliver very fast results for work assignments. Most of these tools are used to summarize the data, compile data, and analyze reports.
Thanks
From India, Jaipur
Acknowledge(0)Amend(0)
Pivot Table, VLOOKUP, and HLOOKUP are the most important tools for every HR or every employee in an organization. These tools help you deliver very fast results for work assignments. Most of these tools are used to summarize the data, compile data, and analyze reports.
Thanks
From India, Jaipur
Acknowledge(0)Amend(0)
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
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Dear Rakesh,
It depends on the type of work you have been assigned. If you have been given analysis work, then it is very useful. Additionally, it cannot be explained in words if you are facing difficulties in any area. Please let us know your problem via direct mail, and I will solve it in a second.
Thanks
From India, Jaipur
Acknowledge(0)Amend(0)
It depends on the type of work you have been assigned. If you have been given analysis work, then it is very useful. Additionally, it cannot be explained in words if you are facing difficulties in any area. Please let us know your problem via direct mail, and I will solve it in a second.
Thanks
From India, Jaipur
Acknowledge(0)Amend(0)
Dear Rakesh,
Excel has everything you need. If you need to prepare monthly, daily MIS, analysis, employee master, etc., you will need Excel and many of its functions. Do not bother to segregate. Knowledge in Excel is a requisite for any office staff. Keep your mind open and learn all you can by using it constantly. All you need is genuine interest, and you will find yourself updated every day.
All the best!
From India, Gurgaon
Acknowledge(0)Amend(0)
Excel has everything you need. If you need to prepare monthly, daily MIS, analysis, employee master, etc., you will need Excel and many of its functions. Do not bother to segregate. Knowledge in Excel is a requisite for any office staff. Keep your mind open and learn all you can by using it constantly. All you need is genuine interest, and you will find yourself updated every day.
All the best!
From India, Gurgaon
Acknowledge(0)Amend(0)
Hi,
VLOOKUP, once you understand it, is very easy. Plan in your mind, put it on paper, study your ideas, and then go to the VLOOKUP formulas. VLOOKUP is an excellent conditional application. It will be like this: if you turn left, you need this; if you turn right, you need this.
For example, if you have some names in the first sheet and in the second sheet you write some information, you can use VLOOKUP formulas in the second sheet with conditions. If you encounter any problems, I can provide you with a good line of application.
Hrkpati
From India, Guwahati
Acknowledge(0)Amend(0)
VLOOKUP, once you understand it, is very easy. Plan in your mind, put it on paper, study your ideas, and then go to the VLOOKUP formulas. VLOOKUP is an excellent conditional application. It will be like this: if you turn left, you need this; if you turn right, you need this.
For example, if you have some names in the first sheet and in the second sheet you write some information, you can use VLOOKUP formulas in the second sheet with conditions. If you encounter any problems, I can provide you with a good line of application.
Hrkpati
From India, Guwahati
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Pivot Table.pdf
Pivot table.doc
Sample Pivot Table -Timesheet.xls