How To Use Excel Spreadsheet For Budget
This example shows y'all how to create a budget in Excel.
1. First, enter the dissimilar blazon of income and expenses in cavalcade A.
Annotation: On the Abode tab, in the Font group, you can use the different commands to change the font size and font style of text. Click on the correct border of the column A header to increase the cavalcade width.
two. Enter the give-and-take Jan into cell B2. Side by side, select cell B2, click the lower correct corner of the cell and drag it across to prison cell M2. Excel automatically adds the other months.
3. Enter some data.
4. Enter the SUM function into cell B6. To accomplish this, select cell B6, blazon an equal sign (=), enter SUM(, select the range B4:B5, close with a ")" and press Enter.
Note: On the Habitation tab, in the Font group, you can add a elevation border.
five. Select prison cell B6, click the lower right corner of the cell and drag it across to cell M6. Excel copies the function and border to the other cells.
6. Enter the SUM function into prison cell O4. Recollect, select cell O4, type =SUM(, select the range B4:M4, shut with a ")" and press Enter.
7. Drag cell O4 downwards to cell O6.
eight. Echo steps 4 to seven for the expenses.
9. Add a Short/Extra row.
Explanation: we created two provisional formatting rules to highlight cells lower than 0 and greater than 0. You lot tin follow the link to learn more nearly this topic. Maybe this is 1 step too far for you at this stage, merely information technology shows yous one of the many other powerful features Excel has to offer.
Source: https://www.excel-easy.com/examples/budget.html
Posted by: gallowaycomen2001.blogspot.com
0 Response to "How To Use Excel Spreadsheet For Budget"
Post a Comment