Averaging in Microsoft Excel is easy, until you start excluding specific values. Here are three ways to average a data set when giving special consideration to the highest and lowest values.

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

If you think Excel is only for number crunchers, you're missing out.Here are ways the average person can use the spreadsheet ...

Open Microsoft Excel. Enter you data down column A. Enter "=AVERAGE(A:A)" in cell B1. This configuration looks for all data points in column A so when you add data to the column, it is included in ...

Returning the average value for a set of values in Microsoft Excel is as easy as dropping in an AVERAGE() function—most of the time. As long as you want to consider every value in the data range ...

To calculate this weighted average, first input the two values for the number of shares outstanding into adjacent cells. In our example, during January, there were 150,000 shares, so this value is ...

How to calculate average stock returns in Excel. In the following example, I'll calculate the returns for Microsoft stock using historical prices and dividends. The first step is to get organized.