Pivot Table (Lalit Sharma)

[Guest]

R/Sir,

What is a pivot table and what are it's uses in the MS-excel and what are
the benefits using pivot table in MS-excel.

I mean what is pivot table and why it is used in MS-Excel?

Please make me understand about this issue.


Thanks & Regards,

Lalit Sharma

 

[Roger Govier]

Take a look at the following sites
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

http://www.datapigtechnologies.com/flashfiles/pivot1.html

http://www.edferrero.com/Tutorials.aspx

 

[Guest]

Sharma gi,

How much u know in excel. as per my experience Pivot table is one of best
option in Excel, you can sort the list, with the help of pivot table. you
can make the report
as per u r requiremtn. its very good option.

better u mail me i will give the proper details.
i can give u some links from there u can get video teaching abt pivot table
and other excel related opotions.

the following options are very useful in excel
PIVOT TABLE, V LOOK UP, VALIDATION, CONSOLIDATION, GOAL SEEK, SCENARIOS,
if u know well abt this option then u will be 80% perfect in excel, still
add-ins are there.
contact : (e-mail address removed)

 

[Guest]

Hi,

Since it is very important to know about Pivot Table, I do not want to
discourage you. although they appear to be simple. It is an Advanced topic in
Microsoft Excel.

Note: Excel PivotTable feature is used to : organizes, summarizes, and
analyzes your data.

Kindly refer to the following links:

1. http://office.microsoft.com/training/training.aspx?AssetID=RC010136191033.
2.
http://office.microsoft.com/en-us/excel/HA011989031033.aspx?pid=CL100570551033
3. refer to "Troubleshoot PivotTable reports" in the On-line help.

Challa Prabhu