Confused about Excel? |
Once you learn what you are doing, Excel will make your business life so much easier. Formulas in Excel can be very helpful. To make a formula type an equals sign in your cell. Then simply tell the computer what formula you want to perform. For example, if you want the sum of cell A1 and cell B1, in another cell type =A1+B1. Excel will do the calculation for you. If you want to do this function for multiple cells, you can drag to copy the formula to other cells too. Excel follows the order of operations. The order in which it performs calculations is parentheses, exponents, multiplication, division, addition, and then subtraction. Excel also has functions. Some of the more common Excel functions are AVERAGE, MIN, MAX, COUNT, and SUM. In a cell click the equals sign, select one of these functions, and then select a range of data. Learning how to work in Excel can really be beneficial.