Forum home » Delegate support and help forum » Microsoft Office general help » Excel

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Excel

Resolved · Low Priority · Version 2007

Reply Tue 17 Feb 2009, 17:08Delegate Pete said...

Pete has attended:
Upgrade to Office 2007 course

Excel

How can I total figures in a grid by associated months i.e. aggregate revenue by month?

For upcoming training course dates see: Pricing & availability

Reply Wed 18 Feb 2009, 10:44Trainer Amanda said...

RE: Excel

Hello Pete

Thank you for your question and welcome to the forum.

I'm unsure of your reference to a grid; however if your data is arranged in a series of columns, where each column has a heading (like a database), you should be able to use either use subtotals or a pivot table to be able to do this.

Kind regards
Amanda

Tue 24 Feb 2009: Automatically marked as resolved.

Microsoft Office articles

· How To Recover Unsaved Files In Office 2010
· Microsoft Office And Its Impact On Others
· How To Use The New Screen Clipping Tool In Office 2010
· Make Access More Accessible With A Top Quality Training Course
· Planning Projects With Microsoft Office

Please browse our web site to find out more about
ms office training and other Microsoft training courses.

Microsoft office tip:

Fine Tuning for AutoShapes

The Windows drawing tools are generally labelled lines, rectangles, oval, etc. Similarly in the Office Suite.

To regulate any shape, straight line, square, circle, stars, smiley faces, etc ... hold down the Shift key while you draw the shape. Remember to release the mouse button before releasing the Shift key.

View all Microsoft Office hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy