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

pivot tables

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

Jumping Between Sheets in a Book

PgDn and PgUp keys scrolls up and down a screen page in most applications.

Ctrl+PgDn and Ctrl+PgUp keys jump from one sheet in your workbook to the next, up or down through the pages.

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