Tag Archives: pivot

Excel Pivot Tables: Manipulation, Averages & More

This question about Pivot Tables came my way recently:

I have to add anywhere between 30-100 items to the values area on a series of worksheets. Is there a quick way to add these items (other than drag & drop/right-click on each one)? Once on my table, I want to display the average of the columns of data (as opposed to the default Sum). Is there an easy way to convert them to averages?

Due to security restrictions, I am unable to download software and/or custom add-ins. Continue reading