If you need to learn some basic functions in Excel, you need an Excel formula cheat sheet. Excel can perform various calculations which can be as simple as addition or as complex as multivariate statistics. Many Excel functions are very complex and are outside the scope of this cheat sheet. Fortunately, most people only need to learn about the basic functions available in Excel, so if you need to know about how to compute addition, subtraction or central tendancy formulas in Excel, here is an Excel formula cheet sheet:
- Addition. Addition is one of the most basic formulas to use in Excel. To begin, you need to have the numbers you want to add entered into your Excel workbook. You can use an addition formula by selecting the Autosum symbol from the toolbar menu or selecting "AVERAGE" from the functions menu.The second way to use the Excel addition formula is to select the cell in which you want the sum displayed and enter the range of cells you want to add. "=SUM" (first cell number:last cell number). For example, if you wanted at add cells A1 though A10, you would enter the Excel formula "=SUM(A1:A10)."
- Subtraction. Subtraction is even easier than addition in Excel. If you already have negative numbers entered in your Excel workbook, you can use the addition formula since adding negative numbers is the same as subtraction. If you are not starting off with negative numbers, start by selecting the cell that you want the result displayed in. Enter the "=" operator and then enter the cells that you would like to subtract. "=first cell – second cell." For example, if you want to subtract the numbers in cell C1 and C2, you would enter the formula "=C1-C2."
- Multiplication. Multiplication is another commonly used formula in Excel. If you only want to multiply the values in two cells, just enter the "=" operator and the first cell * the second cell. For example, if you want to multiply the values in cells A1 and cells A2, you would enter the formula "=A1*A2." If you want to multiply a range of cells, the cheat sheet formula is slightly different. You would enter the "=" operator, then the word "PRODUCT," then then range of cells. For example, if you wanted to multiply all of the cells in A1 through A10, you would enter the formula "=PRODUCT(A1:A10)."
- Division. Division can be a simple Excel function. As always, you will start with the equal sign "=" operator. Next enter the cell that you want to be the numerator, then a forward slash "/" followed by the cell that you want to be the denomenator. For example, if you want to divde cell A1 by cell A2, you would enter the formula "=A1/A2."