98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version 2007
Tue 10 Mar 2009, 15:31Delegate Martin said...
Wed 11 Mar 2009, 14:25Trainer Rajeev said...
RE: 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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Deleting a range of cells using the autofill handleFirstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted. |
