The average function on Excel allows you to find the average of a list of numbers, named ranges, arrays or cell references. This project takes just a few minutes and requires only a computer with Microsoft Excel and the ... More »

Find a list of all the formulas and functions for the spreadsheet program Microsoft Excel on sites such as TechOnTheNet.com, PCWorld.com, Office.com and Dummies.com, as of 2015. Each site includes the exact command to ex... More »

Find various cheat sheets for formulas and functions in Microsoft Excel 2003 and newer versions on websites such as Dummies.com and the TechTarget section of WhatIs.com. An illustrated cheat sheet for Microsoft Excel can... More »

In Excel, the mean function is used to calculate the average of a set of numbers. The numbers used can come from any cell in an Excel spreadsheet by listing the cells involved into the average function box. More »

To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cells, or use the SUM function with negative numbers. Excel does not ... More »

The weighted average function in Excel calculates the average of a group of numbers with one or more of the numbers given more weight or a higher level of importance. For example, when averaging grades together, a teache... More »

Standard deviation is calculated in Excel by using the formula SDEV(ARRAY), where ARRAY represents the range of numbers for which the standard deviation is being determined. This range is either a row or a column of cell... More »