Moving Avergage in Data Analysis

The UK's most regular instructor-led training courses.
Training information: excel consultants · Advanced.excel · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2007

5 posts

ReplyFri 26 Jun 2009, 14:16Delegate Rees said...

Rees has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course

Moving Avergage in Data Analysis

What is the significance of the "Interval" selection when producing the Moving Average chart through the Data Analysis Function.

Thanks

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Fri 19 Mar 2010	Bloomsbury	0	FULL
2003	Wed 24 Mar 2010	Limehouse	7		£212	£217
2007	Fri 26 Mar 2010	Rochester (Hoo)	0	FULL
2007	Mon 29 Mar 2010	Bloomsbury	2		£235	£240
2003	Wed 31 Mar 2010	Southwark	7		£219	£224
2007	Tue 6 Apr 2010	Limehouse	5		£235	£240
Full Schedule: See all 70 Excel Advanced course dates. Bookings currently available until 22nd December 2010.

2,024 posts

ReplyMon 29 Jun 2009, 14:24Trainer Amanda said...

RE: Moving Avergage in Data Analysis

Hello Rees

Thank you for your question and welcome to the forum.

The following article on the Microsoft web site discussed the Moving Average analysis tool, although the article mentions Excel 2003 I'm assuming the functionality of this is the same in 2007.

Kind regards
Amanda

2,024 posts

ReplyMon 29 Jun 2009, 14:25Trainer Amanda said...

RE: Moving Avergage in Data Analysis

Hello Rees

Sorry, I forgot to add the link to the article in my last post:
http://office.microsoft.com/en-gb/excel/HA010864801033.aspx

Kind regards
Amanda

Mon 6 Jul 2009: Automatically marked as resolved.

· Microsoft Excel Training - Numerical excellence for all
· Tips for Transitioning to Excel 2007
· How to start using Excel 2007 Functions
· So Why Are There So Many File Types In Excel 2007?
· Which Is Better, Excel Or Access?

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

Excel tip:

Sum Up All the Values in A Column

If you want to quickly calculate the Summed values of all cells in a column in Excel 2003 normally you would use the SUM formula. (eg if you wanted to calculate the values in Column C rows 10 to 25) the formula would be:

=SUM(C10:C25)

However, if you keep adding values to column C you would keep having to modify the above SUM formula which can get quite annoying.

To get around this you can sum all the values in a column using the following formula:

=SUM(COLUMN:COLUMN)

Which, in our example, would be:

=SUM(C:C)

NOTE You cannot place this formula in column C, or else Excel 2003 will show a circular reference error.

The formula must be placed in any other column, EXCEPT the one being calculated.