Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel pivot tables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel / Pivot tables

Excel / Pivot tables

ResolvedVersion 2007

Fenian has attended:
Excel Introduction course
Excel Intermediate course

Excel / Pivot tables

what are pivot tables used for?

RE: Excel / Pivot tables

Hi Fenian,

Thank your for your post, welcome to the forum;

In answer to your question, a Pivot Table is an interactive worksheet table that can summarise large amounts of data using the views and permutations that you choose. It is called a Pivot Table because you can rotate its row and column headings around the core data to give you different views of the source data. As the source data changes you can update the pivot table, a pivot table can be used as a source for a pivot chart.

regards Pete

Excel tip:

Manually rotating a 3D chart

To manually rotate a 3D chart;
Select the chart (edit mode) and click on one corner of the chart display area. A selection border will appear, using the left mouse button on one of the chart's "corners" (mouse pointer changes to a cross) drag the image which becomes a line representation of the chart (as you begin to drag) and rotate the chart to a view of your choice.
If you dont get it right first time, dont worry, the manoeuver is a little bit tricky.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.