Randomize Data

4 lessons in order

Learn how to randomly select from a list in Excel using Data Analysis, INDEX with RANDBETWEEN, RANDARRAY, RAND, and custom VBA macros.

Learn how to randomize a list of names in Excel using RAND, RANDBETWEEN, INDEX, SORTBY, CHOOSE, Power Query, and custom VBA for shuffling.

Learn how to generate random numbers in Excel without repeats using SORTBY, SEQUENCE, RANDARRAY, INDEX, UNIQUE, and RANDBETWEEN.

Learn 5 easy ways to generate random numbers in Excel using RANDBETWEEN, RAND, RANDARRAY, VBA, and the Data Analysis Toolpak.