Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature to quickly …

You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and …

Learn how to use the percentage formula in Excel to find the percentage of a total and the percentage of change between two numbers. Try it now!

Excel provides a variety of ways to find the average of a set of numbers. For example, you can use function to calculate a simple average, a weighted average, or an average that excludes specific values.

If you use a lot of complex formulas in your Excel spreadsheet, you should learn about recalculation options, iteration (calculating repeatedly), and precision.

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, select AutoSum on the Home tab, press Enter, and you're done.

Let's say that you need to add two different time values together to get a total, or you need to subtract one time value from another to get the total time spent working on a project. As you'll see in the …

Give it a try If you want to play around with our sample data, here’s some data to use. You can see how the SUM function works by copying the following table into a worksheet and pasting it into cell A1.

You can use a running total to watch the values of items in cells add up as you enter new items and values over time. To calculate a running total, use the following procedure.

If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the AVERAGEA function. If you want to calculate the average of only the values that …