Generate random numbers in Excel using the RAND function. This tutorial includes a step by step example.
spreadsheets.about.com