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...
Step-by-Step Guide: Creating a Table in Excel 1. Open Excel and Start a New Workbook Launch Microsoft Excel. Click on Blank Workbook to start fresh. 2. Create Headings In the first row, type your column headings: Example: Date, Item, Category, Amount, Notes. 3. Make Headings Bold Select the heading row. Click the Bold (B) icon in the toolbar or press Ctrl + B. 4. Adjust Column Widths Hover over the line between column letters (e.g., between A and B). Drag to expand or double-click to auto-fit. 5. Apply Color Fill Select the heading row. Click the Fill Color icon (paint bucket) and choose a color. 6. Format Cells Select the Amount column. Right-click → Format Cells → Choose Currency . 7. Merge & Center Title Type a title (e.g., “Personal Budget”) above your table. Select the cells across the top row. Click Merge & Center in the t...