We are only 5 of the couple hundred students who are enrolled in British Columbia Institute of Technology's (BCIT's) Financial Management Program. Our ten-week Business Systems (BSYS 2050) class focuses on Excel 2007. From this course, we have learned many of the great functionalities that Excel offers.
For our term project, we were required to find a simple Excel spreadsheet being used by a company. We then had to make the spreadsheet more useful by using the full capabilities of Excel that we have learned.
We have chosen to modify a Bonus Calculator document. We have modified many of the hard-coding errors, created formulas, and have used Data Validation.
Our blog outlines how we used Data Validation in Excel 2007 to make our Bonus Calculator very user friendly. We hope you enjoy.