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

Excel

ResolvedVersion Standard

Thu 13 Sep 2007, 14:45 Delegate Paul said...

Paul has attended:
Excel Intermediate course
Excel Advanced course

Excel

how do I make I pivot table?

Tue 25 Sep 2007, 16:00 Trainer Katie said...

RE: Excel

Hi Paul,

Thanks for your question.

1) click anywhere within the list table in Excel
2) Data menu > PivotTable & Pivot Chart Report
3) Confirm cell range in next step
4) Press Finish
5) Drag fields to appropriate row / column headings
6) (Optional) Drag fields to Page Headings if you need data to be filtered.

Hope this helps.

Katie

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Excel

Excel

RE: Excel

Excel articles

Excel tip:

Difference between Two Dates