98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel visual basic training - Pivot tables
excel visual basic training - Pivot tables
Resolved · Low Priority · Version Standard
Wed 10 Oct 2007, 16:08Delegate Sarah said...
Thu 11 Oct 2007, 12:20Trainer Sandy said...
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hiding and unhiding columns using the keyboardCTRL + 0 hides your columns and CTRL + SHIFT + ) unhides them although you would need to highlight the column letters either side as per normal |
