Microsoft Excel is a helpful program to organise large amounts of data. It can also help remove some mundane tasks, such as performing accounting functions by hand. Instead of adding up a series of numbers and then dividing by another number manually, you can enter an Excel formula into a spreadsheet cell to do the task for you. Whenever the amounts are updates, Excel will automatically calculate the new figure. Excel formulas are preceded in a cell by the "=" sign; when you type the "=" sign in a cell first, Excel knows to expect a formula.
- Skill level:
Other People Are Reading
Things you need
- Microsoft Excel
Click on an empty cell in your spreadsheet.
Type an "=" sign.
Type the following formula into the cell: UM(A1:A10).
Replace "A1:A10" with the cell locations of the numbers you want to add. In this example, the series of numbers is in cells A1 through A10.
Type a division sign "/" followed by the number you want to divide by. For example, if you wanted to divide the total of cells A1 to A10 by 3, type "/3."
Press the "Enter" key; Excel will perform the calculation.
Tips and warnings
- Instead of typing SUM(A1:A10), you can get Excel to Autosum the cells for you and insert the formula. Highlight the cells you want to sum by left clicking at the top left of the cells and then dragging the cursor to the bottom right. Click on the "Home" tab, then press the Autosum symbol, "'."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for