microsoft-excel-courses - Pivot Table

Resolved · Low Priority · Version 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:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips

microsoft-excel-courses - Pivot Table

Pivot Table

RE: Pivot Table

Excel articles

Excel tip:

Customize the toolbar in Excel 2010