Pivot Table

This query is : Resolved

Satyanarayanan (Querist)
Follow

25 April 2010 Can anyone plz. explain me
1.what is pivot table( in MS-Excel), what are its uses in a corporate and how to put pivot table.
2.Whats V look up and H look up how to put those and what are its uses.
3. Is there any other function or tools which will be helpful for decision making available in MS-Excel

Nischint Kumar Somani

Nischint Kumar Somani (Expert)
Follow

25 April 2010 pivot table is used to extract the dat from a mass scale of data in the desired format, for example you are having a list of products sold in 10 different states further there are different products and having different prices and many other criteria. and u want to check about a particular product than pivot table is useful.

V lookup is used to extract the data from 2 similar data, but different on some aspect,