9. 🎯 Final Project – Personal Budget Tracker - rafageist/book-spreadsheet-basics GitHub Wiki
This is your final task for the Spreadsheet Basics book. You will create a complete spreadsheet that tracks your personal budget for one month.
This project brings together all the skills you’ve learned so far.
📌 Objective
Design a simple, functional, and clear spreadsheet that shows:
- Your income and expenses
- Categories like food, transport, rent, entertainment, savings
- Use of formulas, formatting, and at least one chart
🧱 Project Requirements
Your spreadsheet must include:
✅ At least 15 entries
✅ Categories and amounts
✅ A total income and total expenses section
✅ A remaining balance (income - expenses)
✅ Formulas: SUM, AVERAGE, etc.
✅ Conditional formatting to highlight large or over-budget expenses
✅ At least one chart (pie or bar)
🗂 Suggested Table Structure
| Date | Category | Description | Amount |
|---|---|---|---|
| 2025-06-01 | Food | Groceries | 60.00 |
| 2025-06-02 | Transport | Bus card | 15.00 |
| 2025-06-03 | Entertainment | Movie night | 25.00 |
🧠 Bonus Ideas
- Add notes for specific entries
- Use color coding for different categories
- Separate income and expenses in different sheets or sections
🎤 Presentation
At the end of the module, you will:
- Present your spreadsheet to the group
- Explain your structure and formulas
- Share what you found challenging or interesting
📦 Submission
- Save your file with your name:
firstname-budget.xlsxor.ods - Upload to your team repository
- Add screenshots and a short explanation in the team Wiki
Good luck! This project is a great step toward using spreadsheets in real life.