Create an Excel 2007 Pivot Table and Show Averages
This example is based on the Work Orders workbook, used in my book, "Beginning PivotTables in Excel 2007." If you're working through the book, this video shows the steps outlined starting on page 46.
In the video, we create a pivot table that's based on a formatted Excel Table. Then, the Values field is changed from SUM to AVERAGE, and the numbers are formatted so they're easy to read and understand.
If there are other sections of "Beginning Pivot Tables in Excel 2007" that you'd like to see in a video, please let me know in the comments. Thanks!
___________________
I have dates to be summarised on pivot tables, but I want to summerize by Months and Years. How do I change the column settings to specify months?
@David, you can group the dates by months and years, as described on this page on my Contextures website: http://www.contextures.com/xlPivot07.html
Thanks so much for your reply – all sorted now, as I needed to firstly ungroup several levels.