Develop a personal budget from scratch using MS Excel.

This project requires you to develop a personal budget from scratch using MS Excel. It is important that businesses and individuals track spending and create budgets for financial planning. How many of you have scribbled notes on the back of a scratch piece of paper that you throw away after writing bills for the month? In this scenario, MS Excel can be useful to create a budget that you can track electronically. Create your own worksheet that incorporates the major features that you have learned about in the first half of the course. Include income and expenses for all 12 months in the budget. All of this information should be fictitious. Please do not include any of your own personal information.

Develop a personal budget from scratch using MS Excel.

You will be graded on use of all features, professional impact, organization, creativity and overall impression. (Remember, creativity makes an impression!) Be sure to include these key features (and more): number formatting, wrapping text, merging cells, naming worksheets, formulas, functions, font styles and sizes, borders, adjustments to column width and row height, cell borders and fill colors, mathematical operators, and relative and absolute cell references. Upon completion, upload your Excel Spreadsheet to the Assignments area.

  • Develop a personal budget from scratch using MS Excel.
  • Create your own worksheet that incorporates income for all 12 months in the budget.
  • Create your own worksheet that incorporates expenses for all 12 months in the budget.
  • You should be able track your budget by subtracting your expenses from your income using a formula.

50

50

Professional Impact: Be sure to include these key features (and more): font styles and sizes, borders, adjustments to column width and row height, cell borders and fill colors.

10

10

Organization: Be sure to include these key features (and more): number formatting, wrapping text, merging cells, and naming worksheets

10

10

Creativity: Be sure to include these key features (and more): mathematical operators and formulas.

10

10

Overall Impression: Develop a personal budget from scratch using MS Excel.