Excel

Dear Martin

Thank you for attending Excel 2007 Intermediate course!! I hope you enjoyed the course and benefited from it.

I am assuming you are proficient in creating Pivot tables so I won't go into explaining how to create Pivot tables in Excel.

Once the Pivot table has been created you should be able to see Sum of X ( x being the field you have performed the calculation on)

If you double-click on the Sum of x you will notice hat a dialogue box appears where you can choose your relevanet function i.e. Average, Max, MIn, etc...

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT