excel.advanced.course - Pivit tables

Hello NAME,
Hope you enjoyed your Excel training last week.

Open the workbook where you want to create the PivotTable report

If you are basing the report on an Excel list or database, click a cell in the list or database.

On the Data menu, click PivotTable and PivotChart Report.

In step 1 of the PivotTable and PivotChart Wizard, follow the instructions, and click PivotTable under What kind of report do you want to create?

Follow the instructions in step 2 of the wizard.

Follow the instructions in step 3 of the wizard, and then decide whether to lay out the report onscreen or in the wizard.

Usually you can lay out the report onscreen, and this method is recommended. Use the wizard to lay out the report only if you expect retrieval from a large external data source to be slow, or you need to set page fields to retrieve data one page at a time. If you aren't sure, try laying out the report onscreen. You can return to the wizard if necessary.

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 Excel question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer