? PROJECT 1: EXCEL Over the past two weeks, you have studied some
?
PROJECT 1: EXCEL
Over the past two weeks, you have studied some of the advanced features of Microsoft Excel. The exercises in this project will reinforce some of the concepts learned.
PROJECT DESCRIPTION
Using Excel, you will create a NEW spreadsheet, using formulas, functions, and formatting tools, based on a budget for your home/family (you can use general items if you prefer to not list your specific items).
PROJECT REQUIREMENTS
For your completed file, you MUST include FIVE items that you learned from the assignments readings for Weeks 1 and 2, such as (1) advanced charts, (2) advanced graphics, (3) advanced formulas, (4) advanced functions, (5)goal seek, (6) pivot tables (7) all types of advanced formatting, etc. Be creative and innovative, and include many items from Excel to visually represent your budget, both as calculations for income and expenses, and for charts and graphics.
Here are some more items you can include for expenses:
Retirement savings, 401K investments, parking, getting coffee, expenses for cars, car maintenance, yearly registrations for vehicles, gym memberships, clothes, shoes, student loans, interest on items such as mortgage (principal and interest list separately if possible), credit cards (principal and interest list separately if possible), TV/television services such as NetFlix, Hulu, and Amazon Prime; taxes on property you own; payment to accountant for doing your yearly taxes, babysitters. For income, expenses you can include the taxes you pay, as there are multiple for every paycheck.
For income, you can list all types of employers for regular income (and sick and personal days), health and wellness centers, and those that you work for as an independent contractor. Overtime and comp time can be separate items. Expense accounts, training, financial planning services, office items. Other types of income include dividends on stocks and purchase/option plans, real estate sales, insurance payments for claims, commissions, and bonuses, interest received from your bank for savings and checking accounts, rental income for rental properties you own, unemployment compensation, scholarships/fellowships/grants, social security benefits.
Excel File Requirements
The following MUST be included in the Excel Five Item File:
1. Three different types of charts.
2. Two different types of graphics?(include this list of items in the Comment section when you submit your file).
3. The budget must include (for 1 month): income with deductions calculated for all items (gross and net salary/income) and all expenses/deductions, with totals for rows and columns for all items (minimum 50 items/cells filled in, font size 12 for items in cells).
4. Organized, formatted, and professionally presented Excel file, including grammar items (correct spelling, etc., format row and column titles with bold and font size 14 for row/column titles/names).
5. In the Comment section when you submit your file, also include any items that surprised you, when globally looking at your budget?(income and expenses), in completing this project.
For Project 1 using Excel – Charts can be a pie chart, column chart, line chart.
Graphics (which can include charts) are also WordArt, SmartArt, Pictures, Freeform Drawings, Vectors, Grouping Shapes.
Here’s a web site on “10 ways to add creative graphics to Excel” —https://www.techradar.com/news/software/applications/10-ways-to-add-creative-graphics-to-excel-598384?
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
