Creating a Personal Budget

I’m trying to learn for my Excel class and I’m stuck. Can you help?

  • Creating a Personal BudgetOne of the many benefits of Excel includes the capability to create a personal budget. Budgets include income and expenses. For this assignment, you are to create a 3-month personal budget.Create your own personal 3-month budget in an Excel workbook. Using real numbers is not necessary (nor is it encouraged for privacy reasons). Generate this workbook from scratch by using a standard layout and structure for the budget workbook. Do not use an Excel template; however, you are welcome to refer to a template for guidance in creating your workbook.
    1. Start with a relevant title and put your name in the subtitle
    2. Add column headers for the months.
    3. In column A, add a label for Income. Under Income, list the job (or jobs) that you will be using).
    4. Add numbers in column B.
    5. Next, use a formula to add your income for the job or jobs that you hold. Use Total Income for the label. (Note: add this line even if you have only one job).
    6. Leave a couple of blank rows, then in column A, add a label (Expenses) before listing the cost of housing (rent or mortgage) and appropriate utilities (cable, Internet, phone, electricity, etc., and all other expenses you may wish to incorporate) for the three months.
    7. In column B, add numbers for each of your expenses.
    8. In column A, add a label for Total Expense.
    9. Total your expenses for each month.
    10. In column A add a label for Net Income.
    11. Calculate your Net Income (Total Income minus Total Expenses) for each month.
    12. Add sparklines to column E for all rows with data.

    Click here to see a sample budget.Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates.Save your assignment as a Microsoft Excel workbook. (Mac users, please remember to append the “.xlsx” extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:Jstudent_exampleproblem_101504Need Help? Click here for complete drop box instructions. Click for more options

  • Module 04 Course Project – Enhancing Your Portfolio with Themes, Illustrations, and Charts

    Pen Click for more options Module 04 Course Project – Enhancing Your Portfolio with Themes, Illustrations, and Charts

    Enhancing Your Portfolio with Themes, Illustrations, and ChartsIn the first two project pieces, you created the core of the portfolio and filled in the initial purchase data (e.g., number of stocks purchased, purchase price, date of purchase, total investment) of 10 different stocks. You also performed several different tasks. It is now time to enhance your workbook with a theme, illustration, and pie chart.For this piece of the project, include the following in your portfolio (separate worksheets if applicable):

    1. Create a pie chart of the stocks you purchased using the “Ticker Symbol” and “# of Shares Purchased” columns.
    2. Move the chart to a separate sheet.
    3. Name the sheet “Portfolio Pie Chart”.
    4. Add a relevant chart title and any other elements to make the chart easy to interpret.
    5. Create a column chart using the “Ticker Symbol” column and two additional non-contiguous columns.
    6. Move the chart to a separate sheet.
    7. Name the sheet “Portfolio Column Chart”.
    8. Add a relevant chart title and any other elements to make the chart easy to interpret.
    9. Pictures add to the visual appeal of the charts. On the portfolio sheet, insert a small relevant picture from the Internet into your workbook in an appropriate spot of your choice. Do not block the data. Resize if necessary. For more information on inserting an online picture, follow this link.
    10. In the Ribbon, under the Page Layout tab, click on a thumbnail of a new theme you want to apply to the worksheet (e.g., Organic, Wisp, Integral, etc.). Note: the theme might change the color of the chart.

    Submit your completed assignment by following the directions below. Please check the Course Calendar for specific due dates.

  • Best Nursing Writers
  • Best Nursing Writing Company
  • Buy a Nursing Essay
  • Capstone Project Writing Services
  • CHEAP NURSING ASSIGNMENTS
  • Cheap Thesis Writing Nurses
  • Community Health
  • Course Work
  • Document Formatting Services
  • Family Health Nursing
  • Fundamentals of Nursing
  • Geriatrics
  • GRADUATES CAPSTONE PROJECT
  • Health & Human Ecology
  • Human Bio-Sciences
  • Human Physiology
  • Industry Warning and Guidance!
  • Legit Nursing Writing Company
  • Medical Writing Services
  • Mental Health & Psychiatry
  • Nursing Assignment Help
  • Nursing Bibliography
  • Nursing Case Study
  • Nursing Coursework Help
  • Nursing Dissertation Writing Services
  • Nursing Essay/Personal Statement
  • Nursing Essays
  • Nursing Freelance Writers
  • Nursing Practitioners
  • Nursing Report Writing
  • Nursing Surgery
  • Nursing Term Paper Writing
  • Nursing Thesis Writing

©  2020 Nursingpaperspros.com