Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course london - Pivot tables

microsoft excel course london - Pivot tables

ResolvedVersion Standard

Mon 21 Jan 2008, 17:04 Delegate Ranyi said...

Ranyi has attended:
Excel Intermediate course

Pivot tables

When is it appropriate to use pivot tables?

Fri 25 Jan 2008, 19:13 Trainer Katie said...

RE: Pivot tables

Hi Ranyi,

Hope you enjoyed your Excel training and thank you for your question.

Have a look at the following steps to make a PIVOT TABLE:
[list]1) Click any cell within your data table
2) Click on DATA menu > PivotTable & PivotChart Report
3) Click NEXT > confirm the Data range
4) Click NEXT again.
5) Select where you want the new Pivot Table
6) Click FINISH

Hope this is useful.

Regards,

Katie

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Turn off AutoComplete in Excel

You may have noticed when typing into your spreadsheets that if you start to enter labels that begin with the same letters as a label that has been previously entered in the same spreadsheet, Excel will try and automatically complete the text for you. This feature is called AutoComplete.

If you find this feature more annoying than useful, you can turn it off by:

1. Going to Tools - Options.

2. Select the Edit tab.

3. Remove the tick from next to the "Enable AutoComplete for cell values" option.

4. Click OK.

View all Excel hints and tips

microsoft excel course london - Pivot tables

Pivot tables

RE: Pivot tables

Excel articles

Excel tip:

Turn off AutoComplete in Excel