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

pivot tavle

ResolvedVersion 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:

Charts

Select the data and press the function key F11 and the chart will be created on a separate worksheet.

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.