Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel training - Pivot Tables

advanced excel training - Pivot Tables

ResolvedVersion Standard

Wed 18 Apr 2007, 09:56 Delegate Ian said...

Ian has attended:
Excel Advanced course

Pivot Tables

How do I use pivot tables as a way to efficiently analyse / produce a data report for a large workbook?

Wed 18 Apr 2007, 10:33 Trainer David said...

RE: Pivot Tables

Ian

From your data list, choose the headings carefully as you drag them into the page fields and column row fields, in the data field, experiment by dragging text and numbers fields into this area, and see how excel responds.

hope this answers your ?

regards

david

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010

Here's how to move or copy sheets between workbooks in Excel 2010:

Open the sheet you want to move or copy then on the Ribbon click the Home tab. Click Format. Under Organize Sheets, select the option Move or Copy Sheet and then choose where you want the sheet to be moved/copied to.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

advanced excel training - Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Moving or Copying Sheets Between Workbooks in Excel 2010