You have chosen to sponsor your bid up to a maximum amount of .
I need to Submit a worksheet analysis (using Excel) along with written documentation (using PowerPoint or Word).
The worksheet analysis should be clear and accurate. Insert comments where appropriate to provide explanation of formulas.
The documentation should include the following parts:
1. Provide a brief description of the business situation that you are building the application for.
? What is the purpose of your application?
? Who is the target audience?
? What questions are you trying to answer?
? What assumptions do you need to make?
2. Identify the worksheet concepts and techniques used in your application.
? Which functions did you use?
? Did you use goal seek, scenario management, pivot tables, charting, conditional formatting?
? Did you name cell ranges?
? Did you create macros?
To give an idea of what needs to be done, I attached a .doc file of a sample project. You can use a real company or make one up. Both the Excel and Word or PPT files must be submitted.