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
2
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
From India, Madras
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
From India, Madras
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.
From India
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.
From India
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.
From India, Visakhapatnam
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.
From India, Visakhapatnam
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.
Excel Pivot Table Secrets.pdf
PIVOT TABLE SAMPLE.zip