![]() Step 4: Type your income Type your monthly income amount in the row beneath the monthly total amount due in column D.Make sure the cell numbers are in parentheses. Type SUM equals then highlight the cells you want added together. TIP: Total your figures by using Excel's calculation tool.In this same row, but in column D, calculate the grand total of all your bills for the month. ![]() ![]() Skip a few rows beneath the bills and type "Total" in column A. Step 3: Total the expenses Total all the "monthly payment expenses" in column D.Each group should be sorted in order of due date. TIP: You can further break down your budget by grouping like expenses together: household and fixed payments on top and credit card bills at the bottom.Continue typing the information for all your bills, one in each row, placing them in order of date due. Enter the information from your first bill in row 2, filling out all four columns. Step 2: Fill in columns Label columns A to D in row 1 with the following headers: bills name, due date, total balance, and monthly payment amount.The program automatically opens to a new spreadsheet.
0 Comments
Leave a Reply. |