1-3: Creating Sample Data

You can create your own data to use for dashboards if needed for a project or to learn.

Some key formulas to use to make random data are:

=RANDBETWEEN(1,1000)

=CHOOSE(RANDBETWEEN(1,4),"A","B","C","D")

=VLOOKUP(RANDBETWEEN(1,20),A:C,3,FALSE)


Complete and Continue