![]() (2) Calculate total income of every item: In Cell N4 enter =SUM(B4:M4), then drag the Fill Handle to apply this formula to Range N5:N6. (1) Calculate total income per month: In Cell B7 enter =SUM(B4:B6), then drag the Fill Handle to apply this formula to Range C7:M7. Step 2: Enter your budget data of income and expenses into the table, and calculate the total incomes of every month and every item: Step 1: Prepare a table, and enter its row headers and column headers as following screen shot shown: ![]() The following steps will walk you through customizing a monthly budget template in Excel. Although there are so many budget templates for downloading, you may still want to make a custom monthly budget template based on your needs.
0 Comments
Leave a Reply. |