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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Pivot Table

microsoft-excel-courses - Pivot Table

ResolvedVersion Standard

Fri 18 Jan 2008, 10:04 Delegate Merline said...

Merline has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Pivot Table

How do I create a pivot table?

Mon 21 Jan 2008, 15:24 Trainer Katie said...

RE: Pivot Table

Dear Merline,

Thank you for your question.

In order to build PIVOT TABLES, you will need to locate the data source table first:

Click anywhere within your data table
From the DATA menu > click PivotTable & PivotChart Report
Press NEXT, Confirm Data region, Press NEXT again.
Choose either generating the table on a new sheet or on the same sheet
click on FINISH

See if this helps.

Regards,

Katie

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

microsoft-excel-courses - Pivot Table

Pivot Table

RE: Pivot Table

Excel articles

Excel tip:

Quickly insert a function