Excel
Directions: Following the in-class video lecture, create a simple spreadsheet for a fictional neighbor who needs your help getting financially back on track. To be more financially responsible anyone can save more by sticking to a budget.
- To do so we must create an expense sheet for a monthly budget.
- The following elements should be incorporated into your budget for 12 months.
- This is practical usage of excel and how it can be used for everyday purposes.
Things you will need to do:
1. Create a column for each month (Starting with January)
2. Change the size of the columns and rows to fit the numbers you will be adding and subtracting
3. Add borders around each “cell” that contains the months
4. Change the font
5. Color coordinate the Months, use the colors that you picked
6. Using the first month of the year, January, enter a rough amount that you will start your budget with. For example, if you earn a take-home pay of $4,000 starting with that amount
7. Enter on each line using the formula sheet attached the number of debits and/or credits you may receive in a month.
For example, if you pay the rent and/or mortgage list Mortgage: $1200 and subtract it using the formula for subtractions, subtract that amount from your budget.
Continue until all the normal deductions from your budget are calculated in their respective cell. Be sure to add money to your savings.
When you are finished save the book and upload it to this assignment. As always if you have any questions please email me.
