Join Dennis Taylor for an in-depth discussion in this video Tips for creating and updating sample data, part of Excel Tips Weekly.
- [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,…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.