advanced excel course - 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 » advanced excel course - Pivot tables

advanced excel course - Pivot tables

resolvedResolved · Low Priority · Version Standard

Claire has attended:
Excel Intermediate course

Pivot tables

How do you set up a pivot table?

RE: Pivot tables

Dear Claire:

To create Pivot tables you have to ensure that you have selected any cell within the table!!

- From the Menu bar select Data > Pivot Tables and Pivot charts Report
- Click Finish if you want to keep the default settings
- Once you have a new sheet simply drag and drop the relevant fields from the Pivot table Field List box in to teh blue bordered area.

For hands on experience of this you might want to Book for Excel Advanced course which will cover this and many more topics that you will require to carry out your day to day activities!!

Please copy and paste the following following link and see when is our next Advanced course is scheduled:

https://www.stl-training.co.uk/order/pricing_availability.php



 

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips


Server loaded in 0.1 secs.