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

pivot tables

ResolvedVersion 2007

Matthew has attended:
Excel Intermediate course

Pivot Tables

How do I use Pivot Tables?

RE: Pivot Tables

Hello Matthew,

Hope you enjoyed your Microsoft Excel Intermediate course with Best STL.

Thank you for your question regarding how to use Pivot Tables. This topic is covered in our Advanced Excel training course where you will learn what a Pivot Table is, how to create one and how to use one.

Our forum has numerous pages covering the topic of Pivot Tables and to see these simply type Pivot Tables into the search box and take a look at whichever ones catch your attention.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Wed 22 Feb 2012: Automatically marked as resolved.

Excel tip:

Pivot table grouping

If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

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.