Create an executive summary report, a PowerPoint presentation, and an Excel workbook that describes and solves a business opportunity or problem appropriate to your chosen career.

Create (1) an executive summary report (pdf), a (2) PowerPoint presentation, and (3) an Excel workbook that describes and solves a business opportunity or problem appropriate to your chosen career.

This is an individual assignment.

Proposal Specifications

1. Your project topic must be career related (related to your academic field, job, or a business opportunity). The best project topics are those based on an actual organization’s issue.
2. Provide the following info in your proposal: 

   a. State the problem or opportunity.
   b. Explain its importance.
   c. Explain why an Excel spreadsheet is a good tool to solve it. Describe what spreadsheet features will be used and why.

   d. Provide background on the calculations, formulas, and data sources that you need.

Note: Do not include private or sensitive information in your project!

Implementation

1. Write a 3-5 page executive summary, to be submitted as a .pdf file that describes your project problem/opportunity, your spreadsheet solution, and your results, conclusion, or recommendations based on your spreadsheet analysis.
2. Create a short PowerPoint presentation that describes your project and your proposed solution. This will be based on your executive report.
3. Create an Excel workbook with worksheets that you will use to form your project solution.
   1. Use appropriate Excel features to create a professional presentation of your results.
   2. Use formulas and functions as needed.
   3. Use absolute, relative, and mixed references as needed.
   4. Use sorting, subtotals, pivot tables, etc. as needed.
   5. Use at least one type of chart.
   6. Use at least one type of “What if” analysis (scenarios, trend lines, goal seek, solver, etc.)

Deliverables

• ï‚·  3 submitted files: executive summary (pdf file), PowerPoint Presentation (ppt or pptx file), and Excel workbook (Excel file)