excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 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:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips


Server loaded in 0.08 secs.