Thinkabara

📗 Excel for Beginners · Lesson 10 of 10

Project: a family budget

Google Classroom

A family budget in Excel: income, expenses, balance, IF, dollar format and a chart.

The tasks in this lesson

1. Totals

  1. B5: the sum of the income
  2. B13: the sum of the expenses

💡 In real Excel, Alt+= types SUM for you.

2. Balance

  1. B15: income minus expenses
  2. B16: an IF that writes "Saving" if the balance is 0 or more, otherwise "Deficit"

💡 Try raising the rent to 6,000 and watch B16 flip.

3. Formatting

  1. Make A1:B1 and A7:B7 bold
  2. Select B2 to B15 and click $

💡 After you select a range, Ctrl+B makes all of it bold.

4. Where does the money go?

  1. Select A7 to B12
  2. Click "🥧 Pie chart"

💡 You finished the course! Now try building the budget for your own home.

All lessons

  1. ✍️ 1. Typing in cellsCells, typing, fixing and deleting
  2. 🎨 2. Format a tableSelect a range, bold and dollar format
  3. 🧮 3. Your first formulaMultiply, add and subtract between cells
  4. ➕ 4. SUM and AVERAGEThe total and the average of a column
  5. ⬇️ 5. Drag and fillThe fill handle, and $ to lock a cell
  6. 🔢 6. MAX, MIN and COUNTThe most, the least, and how many filled in
  7. 🔀 7. IF: if... then...Pass or fail, and COUNTIF
  8. ↕️ 8. Sort a tableHigh to low, and alphabetical
  9. 📊 9. Your first chartA bar chart and a pie chart
  10. 🏠 10. Project: a family budgetEverything we learned in one sheet