training courses in excel - 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 » training courses in excel - Pivot tables

training courses in excel - Pivot tables

resolvedResolved · Low Priority · Version Standard

Matthew has attended:
Excel Intermediate course

Pivot tables

Knowing exactly which field puts what data where has always been an issue for me

RE: Pivot tables

Hello Matthew,
Hope you enjoyed your Excel training this week.

Regarding placing the fields in a Pivot Table, read through the following to get an idea of how it works.

From the PivotTable Field List window, drag the fields with data that you want to display in rows to the drop area labeled Drop Row Fields Here.
If you don't see the field list, click within the outlines of the PivotTable drop areas, and make sure Show Field List is pressed in on the toolbar.

To see what levels of detail are available in fields that have levels, the click the + next to the field.

Drag fields with data that you want to display across columns to the drop area labeled Drop Column Fields Here.
Drag fields that contain the data that you want to summarize to the area labeled Drop Data Items Here.

If you add more than one data field, arrange these fields in the order you want: Right-click a data field, point to Order on the shortcut menu, and use the commands on the Order menu to move the field.

Drag fields that you want to use as page fields to the area labeled Drop Page Fields Here.
To rearrange fields, drag them from one area to another. To remove a field, drag it out of the PivotTable report.
To hide the drop area outlines, click a cell outside the PivotTable report.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft APPLICATION question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer


 

Excel tip:

Create a hyperlink navigation sheet

In large files, it is often useful to have a front sheet with hyperlinks to the key databases and summary calculations in your spreadsheet. Hyperlinks can save you and (more importantly) those less familiar with your spreadsheet a great deal of pointless scrolling between and within sheets.



Hyperlinks appear as underlined text and can jump to any cell or range name in your file. You can also use hyperlinks to jump to other files.



To create a hyperlink to a location in the active workbook: (1) Select the cell that contains the text you want to use as the hyperlink and choose Insert|Hyperlink.(2)Click Place in this document.(3)Choose the sheet you want to link to or the range name from the list of "Defined Names".(4)If necessary, type the cell reference in the Type in the cell reference box. (5) Click OK.

View all Excel hints and tips


Server loaded in 0.08 secs.