microsoft+excel+training+london - Excel training

Hi Jaclyn

Thank you for your question.

To create a pivot table, first ensure that all the data you wish to include in the pivot table is continuous, i.e. there are no whole blank rows or columns within the data area that you want to create the pivot table from.

Then:
1. Select a cell in the data area.
2. Go to Data - PivotTable and PivotChart report.
3. Follow through the Wizard.
4. You will now have a pivottable area and a pivottable field list showing on your screen. To add a field to the pivot table, select it with your mouse from the pivottable field list and drag it into the pivot table area where you want it positioned. The only real rule of thumb is that numerical values should go into the Data Items area.

To remove an item from the pivot table area, select the grey box representing the field in the pivot table area and drag it with your mouse outside of the pivot table area.

I hope this helps.
Amanda