 So one of our big issues with working off of a spreadsheet is what's stopping someone from typing in Incorrect data say for example, we look at the registration date. Well, let's just say for example that it is 2016 we're in the future and somebody tries to register for They came in they're like, oh, yeah I totally signed up like 13 years ago or three years ago And they're trying to register now or you know in the past that doesn't really work So suddenly what can we do inside of my data tab? I have a section called data validation now What happens here is that we can actually have Excel Validate force the user to enter in proper data We click on this you'll see that it actually specifies now a data validation setting So in this case right now b3 the registration date So it's allowed to have anything it wants in it. I can type in Hello mom and it's gonna put it in there But if I come into data validation, I can actually come in and instead of allowing any value I can allow say for example a date and I can also allow that that date must be Greater than for example, let's see. We'll say one one 2015 they have to have signed up at least this year When I hit okay Then it looks like it's going on there, but let's try and do that again. Let's say 12 15 2013 as soon as I hit enter. Oh No, the value you entered is not correct The user has restricted the values entered into this cell now. I can't type it in that information now It will always be something before something above 2015 Well, what about down here at age group age group for example is another area where we might need to kind of limit What my user is doing again because if we look at this age group? Well That's my age group right there. That those are my valid age groups So I don't want them doing you know something like P9 because that's not an age group What I can do is I can come back to data validation again in this time instead of selecting date I can actually select list and Inside of this list option what I'm able to do is I can select a source now again My source is d5 to d10. So if I Click and highlight d5 to d10 and I hit okay Guess what appears right next to my age group suddenly I? Have a drop-down menu. I can't change this. I can't come in here and do 100 Again not valid data. It has to be something from this drop-down menu We keep on going with the exact same thing. I'll do it again for my shirt size and I'll do it one more time for my sock size and so now each one of these Has to be entered in Through a drop-down menu. It cannot be selected any other way