\r\nInstructions \r\nFor the project you will design and create a workbook. The workbook should help solve some problem or serve a purpose that is of personal value to you, a friend or an associate. Create a short description of the workbook you plan to create as described in Part I of the project. Keep in mind that your workbook must implement the technical requirements described in part II.\r\n\r\n \r\n\r\nWrite a description of the Excell workbook you plan to create. Be sure to choose a project concept that will be of personal use to you, a friend or work associate. \r\n\r\nIn your description include the following:\r\n\r\n1. Who will use the workbook\r\n\r\n2. Describe what the workbook will do (What purpose will it serve?)\r\n\r\n3. Describe the type of data that will be stored in the workbook\r\n\r\n4. Describe some of the analysis and reporting features of the work\r\n\r\n Project Part II: \r\nCreate the workbook to complete your project. Your workbook must implement the following technical requirements. (60 pnt)\r\n\r\n1. Well formatted with some background color, borders and style\r\n\r\n2. Contain at least one database sheet with at least 15 records and 4 fields of data and at least one calculated field.\r\n\r\n3. Apply appropriate named cell references to your workbook.\r\n\r\n4. Implement goal seek analysis using absolute cell references and an assumption area. \r\n\r\n5. Use conditional formatting on the database sheet.\r\n\r\n6. Use one or more of the functions from this list: if(), iferror(), sumif(), countif()\r\n\r\n7. Use a database lookup function like VLOOKUP() using a lookup table.\r\n\r\n8. Create a filter sheet that will demonstrate the use of numberic and text filters applied to your datasheet.\r\n\r\n9. Create some scenarios and generate a summary report.\r\n\r\n10. Add at least one macro with a button to run the macro.\r\n\r\n11. Use solver in some way. Be sure to create an answer report.\r\n\r\n12. Add appropriate and consistant data validation fields\r\n\r\n13. Create 2 charts of different styles using different data. Include examples of data labels, modify axis settings, legends and titles.\r\n\r\n14. Add an imbedded image with a link to a web web site.\r\n\r\n15. Add cell and worksheet protection. Highlight the unprotected cells. Make the password \"MIDTERM\".\r\n\r\n16. Be sure to add comments to your project workbook pointing to each of the requirements above. Include the requirement number as the first line in the comment. The comment should point to where you implemented each of the technical requirements. To add comments right click the cell and select the insert comments menu option.\r\n\r\n17. Add a sheet to your finished workbook named INDEX. The INDEX will list each of the technical requirements above. The INDEX sheet should be the first sheet in your sheet tab. In the A column of the INDEX sheet create a list titled 1 thru 16 matching up with the 16 technical requirements. Add a hyperlink so that when the instructor clicks on the link it will goto the worksheet and cell containing an example of the technical requirement. In the B column add a short description of your implementation of the technical requirement. This is required for grading purposes. If these hyperlinks are not added to your workbook it will affect your project grade.
Hey There,
Thanks for posting the project. Its looks feasible and am Interested to do it.
Next steps:
Lets discuss/validate the complete requirement and I can start to get this done with required quality output.
I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality.
Lets discuss more online on chat.
Thanks,
Abhinav
$98 USD in 1 day
5.0 (6 reviews)
2.9
2.9
10 freelancers are bidding on average $168 USD for this job
Good day,
I have a ready file for you, I just need to build Index sheet and make hyperlinks.
I am Excel developer of spreadshetweb.com. I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. I work with excel since 1999.
Here are the links for my past experiences:
https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html
https://www.freelancer.com/projects/4848189.html
https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html
https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html
https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html
I am excellent in excel. I am a top ranking mathematics and statistics freelancer in freelancer.com. I am M.Sc. in mathematics and have very strong quantitative skill. I can deliver quality output. Please, check the reviews of my past projects before awarding your project.
Hi,
I specialize in Excel and have a very good understanding of all the features you are looking to be included in this workbook to be created as part of the project. I can send you the write-up (Part I) in a day and complete the workbook (Part 2) in 2 to 3 .
Please refer to my work history in freelancer. It will give you an idea of the variety of excel projects I have done
Regards
Excel Solution
I already have an awesome idea for your exam! A workbook for patients with database of visitors. Will be a great, professional look and great marks. Regards, Ed
sir,
<My goal is Your satisfaction>
After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I’m a professional data entry specialist with 2 years experience. And I’m very interested in your job. I would like to offer my services to you for this project. I believe my skills would be ideal for your project.
My working experience covers a verity of Data Entry area such as: Data entry, Typing, Microsoft-Excel, Data Analysis etc. I am available in Skype.
I am looking forward to hearing from you soon. Thank you for considering my cover letter.
Regards,
Tofazzel