Excel

Resolved · Low Priority · Version 2003

Mon 8 Dec 2008, 16:26 Delegate Hari said...

Hari has attended:
Excel Intermediate course
Excel Advanced course

Excel

What is a pivot table?

Tue 9 Dec 2008, 10:28 Trainer Pete said...

RE: Excel

Hi Hari,
Thank you for your question;
In answer--- though I can see you will be finding out on the 19th December when you attend the Excel Advanced Course...
A Pivot table is simply a table of data which is created from a larger table and displays a summarisation of the fields.
The Pivot name comes from the ability to view the summarisation from different dimensions, by moving fields and pivoting the data to allow you to view different perspectives in the way the data is displayed and calculated. I hope that has helped ...Pete

Mon 15 Dec 2008: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips