␡
- name the sheet
- understand references
- enter information
- activate a cell
- enter row headings
- enter column headings
- make a column wider
- enter values
- calculate a difference
- calculate a percent diff
- sum some values
- calculate net income
- copy formulas
- copy and paste
- use the fill handle
- change a value
- extra bits
This chapter is from the book
This chapter is from the book
This chapter is from the book
This chapter is from the book
enter row headings
The row headings in our budget worksheet will identify the categories of income and expenses and label the subtotals and net income.
)
Activate cell A1 (the first cell in the worksheet).
)
)
Type Item Name.
)
)
Press Enter (Windows) or Return (Mac OS). The cell pointer moves down one cell.
)
)
Repeat steps 2 and 3 for the following labels:
|
Income Items |
Professional Fees |
|
Sales |
Rent |
|
Interest Income |
Repairs |
|
Other Income |
Taxes |
|
Total Income |
Telephone |
|
Expense Items |
Travel & Entertainment |
|
Automobile |
Entertainment |
|
Bank Fees |
Meals |
|
Contributions |
Travel |
|
Depreciation |
Utilities |
|
Insurance |
Other Expenses |
|
Interest Expense |
Total Expenses |
|
Office Supplies |
Net Income |
|
Postage |
When you're finished, the worksheet should look like this.
)