To randomize the order of a list, add an additional column on either side of the list and provide a temporary heading. Then enter this formula in the cell just below the title: =RAND()and copy it down the column. Select a single cell in the column and click either the AZ or ZA button to sort the data in random order.
- [Voiceover] On this worksheet called random sort,…we've got a list of transactions.…The list looks like it's sorted descending order by amount.…We might want to, occasionally, just do some…quality control here, in sort of a primitive way.…We've got about 900 records here…and every so often, we want to review,…just 10 of them or so,…to see if everything has been handled properly.…Is the information correct?…We have everything correct in those 10 entries,…in those 10 rows, let's say.…How do we pick 10 of them at random?…Either add a new column to the right…or in this case, we've got an empty column,…we can use column H out here.…
Use the function =RAND, this is a mathematical function,…there's a companion called RANDBETWEEN, if we want…to generate random numbers between two amounts.…We simply want to use RAND.…If you type =RAND, left parenthesis,…that's all you need to do, press enter.…It simply enters a number between zero and one,…a random number.…To copy this down the column,…we'll just double click and in the process…
- Prepping data for analysis
- Multiple-key sorting
- Sorting by rows or by columns
- Setting single- and multi-level subtotals
- Using text, numeric, and date filters
- Creating custom filters
- Filtering tables using slicers
- Using Advanced Filter
- Eliminating duplicate data
- Using SUMIF and COUNTIF functions for quick data analysis
- Working with the database functions such as DSUM and DMAX
Skill Level Intermediate
Working with Real-Time Data in Excelwith Chris Dutton1h 18m Intermediate
Learning Microsoft Power BI Desktopwith Gini von Courter2h 52m Intermediate
1. Data Preparation
2. Sorting Data
3. Creating Automatic Subtotals in Sorted Lists
4. Filtering Data
5. Advanced Filter
6. Eliminating Duplicate Data
7. Data Analysis Tools
- 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.