Hi, Can anyone help me with vlookup formula and pivot tables in excel....can i get an example of how to use it and in what situations it can be used better Thanks, Tanu
From India, Hyderabad
Acknowledge(0)
Amend(0)
2From India, Hyderabad
Acknowledge(0)Amend(0)
Hi, it's my pleasure to try to answer you. A pivot table is used to classify objects. For example, when you have an Excel sheet with many columns like age, ID, name, and salary, you can classify them based on age only, or by those who have the same ID or the same name. Then, you can analyze the output data as you wish. I hope this explanation can help you.
From Jordan, Amman
Acknowledge(0)Amend(0)
From Jordan, Amman
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.
Excel Pivot Tables- 10114927.pdf