No Tags Found!

devansh
7

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
raajz_johnny
57

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 to 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 Excels 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
Anu_Hr
17

Dear Devansh, I cannot help you with the details of the usage of pivot table. but i would like to share with you this Xcel Sheet, refer Tab no 6...maight help u. Regards, Anu_HR
From India, Pune
Attached Files (Download Requires Membership)
File Type: xls XL_Shortcut_keys.xls (58.5 KB, 472 views)

rsali2
Hi Devansh,
PFA a document on how to start using pivot ...hope this helps.
Also, visit this link to form an understanding of how to usr pivot for various functions.
Using Pivot Tables and Pivot Charts in Microsoft Excel

From India, Delhi
Attached Files (Download Requires Membership)
File Type: pdf ExcelPivotTables.pdf (935.0 KB, 454 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.