Lesson 10: Project: a family budget
- B5: the sum of the income
- B13: the sum of the expenses
| A | B | |
|---|---|---|
| 1 | Income | Amount |
| 2 | Salary 1 | 9000 |
| 3 | Salary 2 | 7500 |
| 4 | Child benefit | 300 |
| 5 | Total income | |
| 6 | ||
| 7 | Expenses | Amount |
| 8 | Rent | 5200 |
| 9 | Groceries | 3200 |
| 10 | Utilities | 700 |
| 11 | Car | 1500 |
| 12 | Activities | 900 |
| 13 | Total expenses | |
| 14 | ||
| 15 | Balance | |
| 16 | Status |
- B5 = 16,800
- B13 = 11,500
All lessons
✍️ 1. Typing in cells
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
A family budget in Excel: income, expenses, balance, IF, dollar format and a chart. In real Excel, Alt+= types SUM for you. Try raising the rent to 11,000 and watch B16 flip. After you select a range, Ctrl+B makes all of it bold. You finished the course! Now try building the budget for your own home.
Explore more: Excel course: all lessons.