Excel Budget Sheet
| Objective | To give kids a working knowledge of Microsoft Excel and its capabilities. |
|---|---|
| Description |
Create your own budget sheet using Microsoft Excel. Steps: 1. Calculate, on average, how much you make per month. 2. In Excel create a column for expenses (groceries, light spending, savings, emergency funds, etc.) and list beside each how much money you think you need to budget in that area. 3. Learn some simple formulas, like sum, and enter them into appropriate places. For example you could have a space for a total at the bottom of your budget sheet and have excel add up the amounts in each space above automatically. 4. Look at your budget chart and answer these questions:
|
| Complete When |
Mark this activity as complete when you have totaled up your monthly income and expenses and you feel like you have a good idea of your financial situation. Track your progress and earn badges! This activity is included in the following: |
| Attachments | |
| Prerequisites | |
| Average Rating | |
| Your Rating | Sign In or Sign Up to rate this activity |
| Age Range | 12 13 14 15 16 17 18 |
| Activity Type | Lesson |
| Tags | Logical-Mathematical Intelligence Computer Literacy Budgeting Counting |
| Created | |
| Last Modified |
References
| Reference | Reference Note | |
|---|---|---|
| Microsoft Office | Here is an Excel Budget Sheet Template.
|
Questions or Comments