I've used the Crystal Ball addin to run MC simulations. I don't
think std Excel has the capability. Crystal Ball is pretty sweet but
it ain't cheap.

Check the following web site:
http://www.decisioneering.com/