How to do Basic Calculations in Excel

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 control order of operations, like =(A1+A2)*A3
• Autofill formulas by dragging the corner of the cell

Where to buy Microsoft Office:

Microsoft Office Home 2024 One Time purchase for 1 PC/MAC: 

https://amzn.to/4iy6672

https://amzn.to/41YTfnh

Microsoft 365 Personal | 12-Month Subscription | 1 Person | Office Word, Excel, PowerPoint | 1TB OneDrive Cloud Storage | PC/Mac Instant Download | Activation Required

https://amzn.to/4hCpazy

https://amzn.to/42ac7jl

Some links are affiliate links. Purchasing through these links gives me a small commission to support this channel, at no cost to you. Thanks for your support!