The List Data Validation is useful when there are only a few valid inputs and the cell is used as a reference. In our project, we used the List Data Validation in our inputs section for many cells. We used some of them to signify either a "Yes" or "No" answer, and others as specific percentages. The following pictures show these two types of lists.
Once the settings for your Data Validation have been set, you are able to set any input messages and/or error alerts.
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.