How to do Basic Calculations in Excel is a great beginner-friendly tutorial that walks through essential calculation functionalities in Excel. Step-by-Step Guide: How to do Basic Calculations in Excel 1. Sum Up the Values What to do : Select the cell where you want the total. Formula : Type =SUM(A1:A5) if your numbers are in cells A1 through A5 2. Manually Add Values What to do : Click a cell and type =A1+A2+A3 to add specific cells. Tip : You can also use =5+10+15 for direct number addition. 3. Subtract Values What to do : Use =A2-A1 to subtract one cell from another. Example : If A2 is 20 and A1 is 5, the result will be 15 4. Multiply Values What to do : Use =A1*A2 to multiply two cells. Shortcut : You can also multiply constants like =5*3 . 5. Divide Values What to do : Use =A2/A1 to divide one cell by another. Note : Be cautious of dividing by zero—it will cause an error. Pro Tips Always start formulas with = Use parentheses to co...