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
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,
CAclubindia
