Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

pivit tables

ResolvedVersion 2010

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

Excel tip:

Get back to active cell

If you have scrolled away from the active celland want to get back t it quicly you can Ctrl and Backspace to get back

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.