excel.advanced.course - pivit tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.advanced.course - Pivit tables

excel.advanced.course - Pivit tables

resolvedResolved · Low Priority · Version Standard

Kristy-lea has attended:
Excel Advanced course

Pivit tables

how to enter and form

RE: 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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Apply currency format quickly in Excel

To quickly apply the currency format to cell in your spreadsheet, select (highlight) the cells you wish to apply currency format to, then use Ctrl + Shift + $

This will apply a pounds symbol even though the $ key is pressed.

View all Excel hints and tips


Server loaded in 0.08 secs.