Excel spreadsheet
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.
