Example on the handout shows the final result – do not enter the totals in the shaded cells! Use calculations to do it!
- Insert row above budget items, enter “Expenses” in cell A1, make it the row bold and shaded (highlight row/Font/bold button and the fill color button—it looks like a paint can)
- In Row 10 Enter label “Income”, make it bold and shaded (highlight row/Font/bold button and the fill button)
- Create a row for “Salary” and “Other income” respectively in cells A11 and A12.
- Enter values for each month for both salary and other income (use example on handout) TIP: you can copy values for one month and paste in for other months, or use the Fill function to copy along a row or column.
- Format all cells as currency (Home/Cells/Format/Format Cells)
- Enter calculations in row 13 (Monthly Totals and Average, as was done for Budget Items above)
- Label the calculations row “Monthly totals” and make the row Bold (highlight row/Home/Font/Bold button)
- In row 15 create a row called “Income – Expenses”, make it bold and shaded (highlight row/Font/bold button and the fill tab)
- Resize column A to fit this long label (double-click the border between Column A and B – or manually move it)
- Enter calculations for Income minus expenses. So you want to subtract the values in Row 8 from Row 13 (Home/Editing/Autosum/Sum) The function will look like this: =SUM(B13-B8)
- Insert Header for the spreadsheet, use File Name (Insert/Header & Footer/Header & Footer elements/File name)
- Use Page Setup to change orientation to Landscape (Page Layout/Page Setup (button on bottom right)/Landscape Orientation)