pivot tables

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

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

Pivot tables

resolvedResolved · Low Priority · Version 2003

Jedd has attended:
Excel Introduction course
Excel Intermediate course

Pivot tables

What are pivot tables?

RE: Pivot tables

Hi Jedd,

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 row headings and column headings. Where the two sets of headings meet or intersect, you assign a data field such as salary information.

I hope this answers your question.

Regards

Simon


 

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips


Server loaded in 0.08 secs.