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