excel

AutoSum has features that enable you to calculate the SUM, COUNT, AVERAGE, MIN, or MAX quickly. To calculate a SUM, choose the Home tab and then click the AutoSum button. To calculate a COUNT, AVERAGE, MIN, or MAX, choose the Home tab; click the down arrow next to the AutoSum button; then click Count, Average,

Functions are predefined formulas that you can use to perform calculations quickly. Microsoft Excel has over 300 built in functions and you can create your own. In this lesson, I will introduce you to some of the most popular functions. Click here to begin.

Array formulas enable you to make multiple calculations with a single formula. There are two types of array formulas: multi-cell and single cell. A formula that performs multiple calculations and returns multiple results is called a multi-cell formula. A formula that performs multiple calculations and returns a single result is called a single cell formula.

The Function Wizard can help you find the function you want and provide you with step-by-step guidance on how to use it. To access the Function Wizard, click the Insert Function button on the Formula Bar or click the Insert Function button on the Formulas tab. To locate the function you want, type a description

In Excel, you can use a formula to perform mathematical calculations, do comparisons, and join text. When entering a formula, you can type the entire formula, or you can type; click and drag to select cells, cell ranges, sheets, and sheet ranges; and/or use the Function Wizard. You can type formulas directly in the cell

In Excel, you can name cells, cell ranges, and constants. When creating formulas, named cells and named cell ranges are easier to remember than cell addresses and range references. For example, =Revenue-Expenses is easier to remember than =B3:B6-B9:B21. Use the Range dialog box to name cells and cell ranges. Names must follow these rules: Be

In addition to using Excel formulas to perform mathematical calculations, by using a comparison operator, you can make comparisons. Comparison operators compare two values. For example, the following formula: =B1>A1, checks to see if the value in cell B1 is greater than the value in cell A1. The > sign is the comparison operator. Comparison

Functions enable you to make many useful calculations, such as finding a sum, an average, the highest number, the lowest number, or a count of the number of numbers in a list. Microsoft Excel has over 300 functions that you can use. You can use functions alone or you can include them in a larger

In Excel, if you want to perform a mathematical calculation such as addition, subtraction, multiplication, or division, use a formula. Type the formula in the cell where you want the results to appear. The formula should start with an equal sign, and can consist of numbers, mathematical operators, references, logical values, and functions, or any combination

A cornerstone of Microsoft Excel is its ability to perform calculations. In this lesson, I will show you how to create and enter formulas. You may be surprised to find out, not only can you use formulas to perform calculations; you can also use them to join text and to make comparisons. Click here to