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

microsoft excel training - pivat tables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Pivat tables

microsoft excel training - Pivat tables

ResolvedVersion Standard

Carly has attended:
Excel Advanced course

Pivat tables

How to do a pivat table?

RE: Pivat tables

Hi Carly

Thank you for your question; and apologies for the delay in response.

In summary, to create a pivot table:
1. Select the data you would like to include in the pivot table.
2. Go to Data - Pivot Table & Chart Report.
3. Follow through the three step wizard.

I hope this helps.
Amanda

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

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.1 secs.