Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Weekly averages

	98.1 % recommend us
	More live stats...

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

Training information:

Weekly averages

Resolved · Urgent Priority · Version 2007

Reply Fri 12 Aug 2011, 11:20Delegate Maria said...

Maria has attended:
Excel Advanced course

Weekly averages

I have a set of annual data (prices) available for each working day of the week. How can I automatically calculate weekly averages base don this data?

Thanks ahead for your help

For upcoming training course dates see: Pricing & availability

Reply Fri 12 Aug 2011, 14:39Trainer Mark said...

RE: weekly averages

Hello Maria,
Thank you for your question regarding average weekly sales.

Depending on the layout of the data in your sheet, you could simply select the weekly range of cells and use the Average function found in the Formulas ribbon. It works similar to Sum.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Thu 18 Aug 2011: Automatically marked as resolved.

Excel articles

· How To Use The New Excel Web App
· How To Take Your Data Out Of The Shade
· What You Need To Know About LOOKUP Functions In Excel 2007/2010
· Tips From Excel's 'Rarely Used' File
· Save time with Microsoft Excel

Please browse our web site to find out more about
application development excel and other Microsoft training courses.

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips