I have used the Monte Carlo method, but not in risk analysis.
If all you want to do is to generate a set of numbers for a variable with a certain
distribution for which you set the mean and the standard deviation, then
select a column of length N, then pick Data Analysis from the Tools menu...