From the course: Excel: You Can Do This

Unlock this course with a free trial

Join today to access over 23,100 courses taught by industry experts.

Data validation: Ensure users don't input crazy data

Data validation: Ensure users don't input crazy data - Microsoft Excel Tutorial

From the course: Excel: You Can Do This

Data validation: Ensure users don't input crazy data

(upbeat music) - This is serious. We have to learn how to control inputs in our spreadsheets. Mistakes cause problems. They invite a lot of questions, and when we can control the inputs, we keep crazy stuff out and we maintain the integrity of the data that we allow in. Let's check this out. Now here, we got some data about programs, and our funding is tied to this data. We've got kid's names, ages, and the number of days they were absent. We know we only deal with kids from eight to 12, so we should not have a five or a 19 or a J in this sale. So, let's look at this. Andrea, age, so I go to type a nine for Andrea, but I accidentally hit I. Excel should not take that, so let's delete that. Now, I'm going to highlight the entire column. In the Data tab in the ribbon, Data Tools, Data Validation, allow any value, no. That gets the forensic accounts to show up. Hit the drop-down list. Whole number. Between. Minimum, eight. Maximum, 12. We can put an error alert. If somebody puts in…

Contents