98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel in courses - Pivot tables
excel in courses - Pivot tables
Resolved · Low Priority · Version Standard
RE: The use of Pivot Tables
Hi Amy,
Thank you for your question.
For creating a PIVOT TABLE, you will need to locate the data source table first:
- 1. Click anywhere within your data table
2. From the DATA menu > click PivotTable & PivotChart Report
3. Press NEXT, Confirm Data region, Press NEXT again.
4. Choose either generating the table on a new sheet or on the same sheet
5. Click on FINISH
Once you have the Pivot Table grid appear, you can drag in any field titles into the grid (PageField, RowField, ColumnField, DataField) to view your data in your preferred arrangement.
See if this helps.
Regards,
Katie Woo
Microsoft Certified Trainer
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 rows using the keyboardCTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal |