#Probability is the heart of #simulation . And whilst #R is the preferred platform for developing the models, it can be useful to drop into Excel, especially for demonstration. +John Cook 's table of available probability functions in Excel shows when it'll be smooth-sailing to do this and when you're going to have to 'roll your own' if you need, for instance, a Poisson quantile function.