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 » Pivot Tables
Pivot Tables
Resolved · Medium Priority · Version 2007
Tue 11 Dec 2012, 16:35Delegate Heather said...
Heather has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course
Pivot Tables
how to consolidate sheets of data into one to create a pivot table. i.e. creating a pivot table from 52 weeks of data all on seperate tabs
Thu 13 Dec 2012, 10:43Trainer Cindy said...
RE: Pivot Tables
Hello Heather,
Thank you for your question regarding consolidation and pivot tables.
The steps for consolidation are on page 19 of the manual you were given on the course (you are also able to download the manual from our website once you have logged in).
Once the data has been consolidated you turn it into a pivot table by clicking on the Pivot Table button which you will find on the Insert ribbon and in the Table group.
I hope this answers your question but if it does not please reply with more details so I can give a more accurate response.
Kind regards
Cindy
Microsoft Office Trainer
Thu 13 Dec 2012, 10:44Trainer Cindy said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Thu 20 Dec 2012: Automatically marked as resolved.
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:Display pictures on Chart Data PointReplacing a single chart data point bar with a picture. |
