Tips for creating and updating sample data

- [Instructor] When you're creating sample data,…or possibly updating sample data…to make it look more current,…there are a number of techniques you can use in Excel.…In this worksheet, we see an HR kind of list here.…And you'll see the social security numbers in column D.…These were all randomly generated,…and every so often I get a phone call,…or an email from somebody that says, "Are these real?"…well, I made them all up, and so I have to say,…some of them could be real.…Now, odds are a billion to one that yours isn't here.…If it is, I'll gladly take it out.…But, how do we generate numbers like this?…And you can imagine other situations…where you've got an ID scheme.…

Maybe it's just six characters, eight characters, whatever.…Here we have nine characters.…How do we create a list like this quickly?…Sample data.…I'm going to zoom in a little bit here,…and momentarily make column D wider.…Not truly necessary.…But to make this more visible, more clear.…Let's use the function RANDBETWEEN.…Just as you see this, by the way, in the list here,…