excel visual basic training - pivot 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 visual basic training - Pivot tables

excel visual basic training - Pivot tables

resolvedResolved · Low Priority · Version Standard

Sarah has attended:
Excel Advanced course

Pivot tables

How to create a pivot table?

RE: Pivot tables

Hi Sarah

1) Click on your data on your Excel worksheet and select Data menu, PivotTable and PivotChart Report.

2) Follow the wizard from Step 1 to 3.

Please note on Step 3 you will need to click on the Layout Button to enable you to construct the Pivot Table by dragging the field buttons on the right to the diagram on the left.

Hope this helps.

 

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:

Hiding and unhiding columns using the keyboard

CTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal

View all Excel hints and tips


Server loaded in 0.09 secs.