Question about Microsoft Office Standard for PC

1 Answer

Excel I need to enter a formula to calculate a moving annual average on a spreadsheet. Helpppppp

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 2 Answers
Re: Excel

The Data Analysis Add-in has a Moving Average fuction and wizard. Moving Average

Posted on Aug 31, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

2 Answers

What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

1 Answer

What is excel

What is Excel blankxl_250.jpg
Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis.

Dec 15, 2010 | Microsoft Office Excel 2003 for PC

2 Answers

What is the function of Microsoft excel?

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!



Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

Need help with excel formula

The solution would be to have an input column(e.g. A) that is separate to the hours and overtime columns. Then in the hours column enter =IF(A1<40,A1,40) and in the overtime column =IF(A1<41,0,A1-40)

Oct 28, 2009 | Microsoft Excel for PC

3 Answers


Try this. If any of the cells are zero (or blank), the word 'zero' will be displayed. Substitute anything you want for the text including blank ""


Aug 26, 2009 | Microsoft Office Excel 2007

2 Answers

I need a running balance in a column for a petty cash spreadsheet

In the first row of numbers, assume row 3 for example (leaving 2 rows for titles, put in cell E3: =C3+D3. In the next row (assuming row 4, put in cell E4: =C4+D4+E3. Use fill down to populate this formula all the way down.

Jun 18, 2009 | Microsoft Excel for PC

4 Answers

I want the excel compound interest formula


Dec 02, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Quaterly IRR

if your analysis is based annually, yes. if it is based quarterly, then you have to raise the derived irr to the 4th power (4 consecutive quarters) to arrive at the annualized irr.

Jul 04, 2008 | Microsoft Excel for PC

1 Answer

Average handle time

I have created a spreadsheet for you to a) use and b) to learn from.

It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

It also allows you to calculate a Part Month average.

I have displayed it as it was CONSTRUCTED and as it would be USED.

The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

I have uploaded the file to here:

Hope this gives you the push to really start using Excel.

Apr 04, 2008 | Microsoft Excel for PC

1 Answer

Excel Formulas

Get on Excel web sight and look at Excel Tutorial close to bottom of page. Follow the instructions.

Sep 17, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

135 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18257 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides