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