Sorting data in random order


show more Sorting data in random order provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Sorting data in random order

You may have the occasional need to rearrange data randomly. That is, sort this list in a random order. Now, why might you want to do something like that? Maybe you want to review the accuracy of your record keeping and you'd like to extract from here, copy from here, 8 or 10 records, paste them somewhere else, and review the data at hand. And rather than just doing it in a freeform way, let's actually rearrange this data in a random order. I think you could also imagine this on a sales environment. You're trying to analyze orders, inventory, processing, shipments, those kinds of things.

Maybe you don't have a formal Quality Control department, but you just want to pick random records at times. Let's randomize this list. Now, we can either add a new column over to left of column A, or possibly off to the right here. Maybe we haven't put in the new salaries. If we did, we'd create a new set of data in column N, but we'll just use this right here. What we'r...

Sorting data in random order
Video duration: 2m 43s 1h 32m Appropriate for all

Viewers:

Sorting data in random order provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...