pivot tavle

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

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

Pivot tavle

resolvedResolved · Low Priority · Version 2007

Henry has attended:
Excel Intermediate course

Pivot tavle

what is a pivot table

Edited on Tue 17 Feb 2009, 16:17

RE: pivot table

Hi Henry

Pivot tables allow you to look at data in several dimensions. For example, sales by region, sales by sales rep, sales by product.

To create a Pivot table:

Select a cell in the target table

Click Data / Pivot table and Pivot chart report

Follow the steps in the Wizard

Hope this helps

Carlos

Tue 24 Feb 2009: Automatically marked as resolved.


 

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips


Server loaded in 0.08 secs.