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.
Hello patinojaime, We went through the document that you have provided and we are very confident of doing this. Please reply if you want to discuss further !
Hi,
I am very experienced with creating Excel (VBA) applications. I reviewed the sample project and I can devise a business problem scenario, solve it using Excel functions and macros and create the report for you. Please, contact me and we will get the project completed.