Step 1
Open an Excel Book of work and to enter any data you to want to to apply the functions to. This may to include a column of dollar amounts for a sales total, points you to want to average, or any other text or numerical data.
Step 2
Click in an vacuum Excel cell. chosen "Insert" of the top bar tool holder and "Function" of the drop-down menu. A list of commun run or recently used functions open. To add items, chosen the "Sum" function. To multiply, chosen "Product." Other functions such as "Average", "Sin" and much others appear. Click on a function to to learn more; a File description be shown below the box.
Step 3
Select a function by to click on it with your mouse, then to click "OK." Once you to have made your selection, a "Function arguments" box appear. This is where you can to enter any details necessary to to carry out the function. If your cursor was in a cell below a column of numbers, the numbers in that column generally be placé in the function argument automatically. You can to modify them in the arguments box.
Step 4
Learn the Excel syntax. arrangement functions require understanding how Excel sees your data. Rather that basing arguments off the numbers in your cells, Excel identify data by the place of the cell. If you to have the number 305 in a cell in column H, row 10, Excel reads that data as H10, not 305, for the goal of cell arguments. If you to want to name a range of cells, use the colon to to indicate the word "through," such as "H10:I15" for an argument use cells H10 through I15. To to indicate only those two cells and not the range of cells in between, use a comma rather that a colon.
Step 5
Manually to enter simple formulas use Excel syntax. For example, you can add a column of numbers by Type "=SUM" in a cell (without quotes). Use your mouse to culminating point the range of cells you to want to add, and then press "Enter." subsistence in spirit that the "Sum" function is used to both add and subtract. For subtraction, simply add a negative sign (-) front the number you to want to subtract. Division can be achieved by Type "=(number/number)" without quotes, substituting one or the other numbers or cells for the word "number."
Step 6
Place your cursor below a column of numbers and click the epsilon icon (it look at like a in length M or backwards 3) in your bar tool holder for a one-click sum function. You can access other quickly calculation functions by to click the black arrow afterwards to the epsilon.
