Using Excel is a great way to perform what-if analysis, and formulas generating random values that make sense for your forecasting help present a variety of outcomes for analysis.

It's easy to return random values in Microsoft Excel, but returning random letters might leave you scratching your head. Fortunately, you only need two functions.

Microsoft Office Excel includes dozens of function options to help you automatically generate values in cells across a spreadsheet. If you have a lengthy column of numbers that you need to ...