Pivot tables

Hello Johanne,

Hope you enjoyed your Microsoft Excelcourse with BEST Training.
Thank you for your question regarding Pivots.

To create a Pivot, click anywhere inside your data list in excel, then from the Insert Tab (ribbon), the first button on the left is Pivottable, Click this, then from the dialog that appears click OK (no need to change anything here).

A new sheet with an empty pivot tale will appear. On the Left will be a list of all the headings from your data table. You can drag these into the pivot into the relevant area. The pivot will be created automatically.



I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer