Pivot Tables

Hi Sanqita

thanks for your post hope you enjoyed yor training

The way you would use pivot tables is as follows - firstly make sure your data has headings and you click on a data cell - then go to the data menu and choose pivot table

then go through the steps till you get to the last step - make sure you use as new sheet click finish

what you need to do is drag and drop all the fields from the list to different parts of the pivot table when done this you can move them around, filter them and change the fields by either clicking the drop down lists or, double clicking the field names

If you need anymore help just reply to this post

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn