Pivot

Resolved · Low Priority · Version 2010

Wed 3 May 2017, 16:33 Delegate Lisa said...

Lisa has attended:
Excel Intermediate course

Pivot

Generate pivot tables from raw data

Thu 4 May 2017, 09:31 Trainer Jens said...

RE: Pivot

Hi Lisa,

Thank you for the forum question.

PivotTables are very powerful to analyse data.

If you want to create a PivotTable click inside the row data click the Insert tab and Click PivotTables in the Table group. Excel will now create the PivotTable in a new sheet. You will now need to tick the headings in the PivotTable fields list you want to analyse in the PivotTable.

You have a lot of options working with PivotTables. We actually have a whole day PivotTable course where we get around in all the options.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

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