pivot tables

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 tables

Pivot tables

resolvedResolved · Low Priority · Version 2003

Sharon has attended:
Excel Advanced course

Pivot tables

how do you make a pivot table

Edited on Thu 4 Sep 2008, 11:53

RE: pivot tables

Hi Sharon

Sorry for the delay in answering this question.

To create a pivot table in Excel do the following:

1. Click on the data to be pivoted. (Make sure the data range does not have whole blank rows or columns in it.

2. Select the Data menu and click [b]PivotTable and PivotChart Report


 

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips


Server loaded in 0.09 secs.