dear all, This is devang. can anyone through light on USE OF PIVOT TABLE IN HR? Waiting for reply............ Thanking you, devansh
From India, Vadodara
Acknowledge(0)
Amend(0)
7From India, Vadodara
Acknowledge(0)Amend(0)
Dear Devanash,
Greetings!
We would use a Pivot Table to produce meaningful information from a table of information. Imagine you have a table of data that contains names, addresses, ages, occupations, phone numbers, postcodes, etc. With a Pivot Table, we could very easily and quickly find out:
1. How many people have the same names.
2. How many postcodes are the same.
3. A count of a particular occupation.
4. See only people that match a particular occupation.
5. Find out the addresses of people that match a postcode.
Perhaps the biggest advantage of using Pivot Tables is the fact that we can generate and extract meaningful information from a large table of information within a matter of minutes. Or perhaps it is because they will not use up a lot of memory from your PC. In a lot of cases, we could get the same results from a table of data by using Excel's built-in functions, but this would take more time and use far more memory. On top of this, if we wanted some new information we can simply drag-and-drop (pivot). We can also opt to have our information update each time we open the Workbook and/or by clicking refresh.
From India, Madras
Acknowledge(0)Amend(0)
Greetings!
We would use a Pivot Table to produce meaningful information from a table of information. Imagine you have a table of data that contains names, addresses, ages, occupations, phone numbers, postcodes, etc. With a Pivot Table, we could very easily and quickly find out:
1. How many people have the same names.
2. How many postcodes are the same.
3. A count of a particular occupation.
4. See only people that match a particular occupation.
5. Find out the addresses of people that match a postcode.
Perhaps the biggest advantage of using Pivot Tables is the fact that we can generate and extract meaningful information from a large table of information within a matter of minutes. Or perhaps it is because they will not use up a lot of memory from your PC. In a lot of cases, we could get the same results from a table of data by using Excel's built-in functions, but this would take more time and use far more memory. On top of this, if we wanted some new information we can simply drag-and-drop (pivot). We can also opt to have our information update each time we open the Workbook and/or by clicking refresh.
From India, Madras
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Excel Pivot Table Secrets.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip