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.