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

advanced excel course - pivot tables

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel course - Pivot tables

advanced excel course - Pivot tables

ResolvedVersion 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


Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.