Pivot Table In Excel - Xls Download

Hi,
My name is Madhu.. I need some information about Pivot tabel. What is the use of that..? & how to use that..?
Please, cna anyone help me in this matter..
thanks in advance
Madhu

Hi Madhu,
kindly check the below link
http://www.microsoft.com/dynamics/us...s_collins.mspx
my simple explanation is it is used to convert rows titles in column titles and viceversa

hi madhu,
when you have large sorce of information on excel spread sheet, pivot will help you to arrange data require to be retrieved based on headings and linked source of information, best option is take the data source work on the same.

hi madhu
you may find this excel worksheet easy to understand
and to apply in a jiffy
-vellayan

Dear madhu,
good question!!!!!!!
pivot table will use for to know the data of summary like count, sum, average
suppose u have the data regarding b tech college students wise
u want know at a time how many students in each dept like csc, civil, eee
for that u can use pivot table in excel
firstly you can select the data & go to Data Menu = Pivottable & Pivot chart Report = Pivot Table = clilck the next & take suitable options
Regards..............Bhuvana.