␡
- 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. 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:
)
)
)
)