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+training - Pivot tables
excel+training - Pivot tables
Resolved · Low Priority · Version Standard
Fri 14 Dec 2007, 17:54Delegate Scott said...
Mon 17 Dec 2007, 11:10Trainer Sandy said...
RE: Pivot tables
Hi Scott
It was great to meet you on Friday on my course. Hope you had a great weekend.
To create a Pivot table:
1. Click anywhere on your data on worksheet.
2. Select Data menu, Pivot Table and Pivot Chart Table Report
3. At Step 3 of the Wizard, click on Layout button to construct the layout of your Pivot table.
4. Click Finish to generate a new Pivot Table.
Hpe this helps
Sandy
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:Autonumber in ExcelTo create an autonumber field, can use the Offset() function. |
