Description:
https://excel.tv/creating-random-data-in-excel-using-randbetween-and-choose/
Jordan gives some tips for creating random categorical data in Excel. His tip includes use of the RANDBETWEEN() and CHOOSE() functions. Oz gives this 4 srirachis.
The panel then discusses the practical uses of this tip for creating dashboard mockups and creating tons of dummy-data on the fly.
Excel TV
SUBSCRIBE: http://www.youtube.com/user/ExcelTVShow
Google Plus: https://plus.google.com/116533082132230113711/116533082132230113711
Facebook: https://www.facebook.com/ExcelTVSeries
Twitter: https://twitter.com/ExcelTV
Our Personal Sites:
Website
Rick Grantham: http://rickgrantham.com/
Jordan Goldmeier: http://optionexplicitvba.com
Oz Du Soleil: http://datascopic.net
Youtube:
Oz Du Soleil: http://www.youtube.com/user/WalrusCandy
Rick Grantham; http://www.youtube.com/MrRickGrantham
Facebook:
Rick Grantham: https://www.facebook.com/AuthorRickGrantham
Jordan Goldmeier: https://www.facebook.com/OptionExplicitVBA
Oz Du Soleil: http://facebook.com/devilhorse
Google Plus:
Oz Du Soleil:
Jordan Goldmeier: http://plus.google.com/+JordanGoldmeier
Rick Grantham: https://plus.google.com/+RickGrantham
LinkedIN:
Jordan Goldmeier: http://www.linkedin.com/in/jordangoldmeier/
Oz Du Soleil: http://www.linkedin.com/in/ozdata
Rick Grantham: http://www.linkedin.com/in/rickgrantham/
Twitter
Oz Du Soleil: https://twitter.com/Oz_DragonCookie
Rick Grantham: https://twitter.com/BIStrategyGuy
Jordan Goldmeier: http://twitter.com/Option_Explicit
Products:
Rick - Spreadsheet Templates for Small Business Owners - http://smallbusinesschampionbundle.com/
Jordan - Excel Consulting & Training
http://www.GoldmeierConsulting.com
http://www.ExcelAndAccess.com
http://www.VBAExpress.com
Share this link via
Or copy link























