Overview
· Task: Complete an Excel workbook that demonstrates the skills learned this semester!
· Purpose: Solve a problem for yourself or others using Excel.
· Graded by certified graders with feedback on the ru
ic.
Instructions
This assignment is a personal application project, meaning that you are responsible to design the project requirements within the guidelines below.
1. The Excel workbook must benefit one of the following:
· Yourself, your spouse, a family member, or a friend.
· A work setting (your employer / company).
· A church calling or assignment.
· A volunteer, charitable, or public organization.
2. If the user is someone other than yourself, work closely with that "client" to clearly understand their needs and requirements, and what functionality the project should provide.
Note: Although you may collaborate with your "client" about requirements and needs, you may not ask questions about how to actually build the Excel workbook.
3. Your project spreadsheet should meet all of the following requirements:
· Be original and creative. Do not use pre-existing workbooks, templates, or other partially completed files. You should start your work using the file provided above.
· Your project must be newly-created during this semester. You may not use something that you completed previously.
· Do not use a project associated with another course. This is a personal application project, not an academic project. You may not submit a project that received or may receive credit in another course (including a previous semester of this course).
· The workbook must use the full range of functionality learned this semester. This ranges from cell referencing, filters, and lookup functions all the way to charts, pivot tables, and perhaps even macros. Please see the ru
ic for details on how this requirement will be graded.
· Your project should be user-friendly and very intuitive. Create a dashboard. Just because something is "easy to use" does not mean that it is "easy to build". For a project of this scale, "easy to use" usually means "difficult to build". ?
· Label and format the workbook's sheets appropriately. Clean up the workbook and make it look sharp. Format values co
ectly on all sheets and make the data easy to read. Ensure all of the columns are of appropriate width. Follow all Standards of Professionalism
· (Links to an external site.)
· .
Items to submit
1. Your custom Excel workbook (remember to save as macro-enabled .xlsm)
2. A submission comment with the number of hours spent working on this project
BUS115_Coversheet
Best wishes as you work to finish up the semester!
This is a blank file to get you started on your final for spring 2022
Because the work must be done in this semester, please use and submit this file.
Do not alter this sheet, just add other sheets and leave this one at the end.