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

Pivot Table

ResolvedVersion 2003

Mon 3 Nov 2008, 16:32 Delegate Nina said...

Nina has attended:
Excel Introduction course
Excel Intermediate course

Pivot Table

What is the main function of the pivot table?

Mon 10 Nov 2008, 21:55 Trainer Simon said...

RE: Pivot Table

Hi Nina,

Thank you for your question.

A pivot table is used to analyse data fom an excel list or external data source such as Access.

You create a Pivot table by assigning a Page field, row headings and column headings. Where the rows and columns meet or intersect, you assign a data field such as salary information.

I hope this answers your question.

Regards

Simon

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips

Pivot Table

Pivot Table

RE: Pivot Table

Excel articles

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines