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

excel

ResolvedVersion 2007

Martine has attended:
Excel Intermediate course

Excel

How do I use Pivot Tables?

RE: Excel

Hi Martine

Thanks for the post

A pivot table is used to summarise data from a list and display the data by field in a way that can be moved around aswell as being sorted and filtered within the pivot table

You can also create charts from pivot tables that can also be filter by fields from the lists - to learn more about these i would recommend you sit on an advanced course

Make sure you start this off from the insert ribbon and you are in the data i would recommend you put yout pivot on a new sheet

Hope trhis make things clear for you, if not just reply to this post

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Tue 9 Dec 2008: Automatically marked as resolved.

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

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.11 secs.