what are the important parts in pivot table/ chart/, V Lookup and H Lookup that a HR fresher should know.
From India, Bangalore
Acknowledge(1)
Amend(0)
2From India, Bangalore
Acknowledge(1)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(2)
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(2)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)
Understanding VLOOKUP: A Simple Guide
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.
Regards,
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.
Regards,
Hrkpati
From India, Guwahati
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
23_excel funaction and data analysis tool.pdf
Payroll Data Format in Excel.xls