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 » Pivit tables
Pivit tables
Resolved · Medium Priority · Version 2010
Mon 16 Jul 2012, 11:31Delegate Ro said...
Ro has attended:
Excel Intermediate course
Excel Advanced course
Pivit tables
Hi - this is a question for Anthony who tool the Advanced Excel course on July 10th.
On the course we were looking at pivot tables and you did something which got each region separated out on a different tab which would be really useful - but I've already forgotten how to do this and was obviously so astounded by it I didn't write it down! Please can you let me know how to do this?
Also where can I access the course content slides?
Thanks
Ro
Mon 16 Jul 2012, 14:33Trainer Anthony said...
RE: Pivit tables
Hi Ro, good to hear from you. If you want to separate the Regions into separate tabs, make sure the "Region" field is dropped into the Report Filter Field. Then on the Options tab, choose the Options drop down on the left hand side and choose "Show Report Filter Pages". The rest should be obvious!
The course material should be accessible via your delegate account, so have a nose around at the top of the screen (look for "Downloads") when you log in. If you have any other problems drop info@stl-training.co.uk an email and they will assist.
All the best,
Anthony
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:Select Single Data MarkerTo select a single data marker in a chart, ie line, bar or column; |
