How to Use Excel Formulas for Beginners

Learn Excel formulas from scratch. Master basic functions like SUM, AVERAGE, and IF with step-by-step instructions for beginners.

1. Start every formula with an equals sign. Click any cell and type = to begin a formula. Excel recognizes the equals sign as the start of a calculation. Without it, Excel treats your entry as plain text. Type =5+3 and press Enter to see Excel calculate the result.
2. Reference cells instead of typing numbers. Click cell A1, type 10, then press Enter. Click cell A2, type 5, then press Enter. In cell A3, type =A1+A2 and press Enter. Excel adds the values from cells A1 and A2. When you change the number in A1 or A2, A3 updates automatically.
3. Use the SUM function to add multiple cells. Enter numbers in cells A1 through A5. Click cell A6 and type =SUM(A1:A5), then press Enter. Excel adds all values in the range. The colon creates a range from the first cell to the last cell. SUM works with any range size.
4. Calculate averages with the AVERAGE function. Using the same data from step 3, click cell A7 and type =AVERAGE(A1:A5), then press Enter. Excel calculates the mean of all values in the range. AVERAGE ignores empty cells but includes cells containing zero.
5. Create conditional logic with IF functions. Click cell B1, type =IF(A1>10,"High","Low") and press Enter. This formula checks if A1 contains a value greater than 10. If true, it displays "High". If false, it displays "Low". Change the value in A1 to see the result update.
6. Copy formulas to multiple cells. Select the cell containing your formula. Press Ctrl+C to copy. Select the range where you want the formula applied. Press Ctrl+V to paste. Excel automatically adjusts cell references for each row or column. A formula referencing A1 becomes A2 when copied down one row.
7. Check your formulas in the formula bar. Click any cell containing a formula. The formula bar above the spreadsheet shows the actual formula while the cell displays the result. Use the formula bar to edit formulas without retyping them completely. Press F2 to edit a formula directly in the cell.
8. Fix common formula errors. Excel displays #DIV/0! when dividing by zero, #VALUE! for wrong data types, and #REF! for invalid cell references. Click the error cell to see Excel's suggested fixes. Double-check parentheses, cell references, and function spelling to resolve most errors.