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
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