No No No No No!
Do NOT use ATP for any of its stat functions, unless you want to
demonstrate the degree to which MS can demonstrate total ineptitude when
it comes to long-standing (since 1990, at least) problems with many of
its functions (core worksheet functions, as well as those supplied by
the analysis ToolPak).
PopTools is a free add-in that will do the trick; unlike MS, its author
is good about documenting what's going on (he uses the very modern
Mersenne Twister for the underlying variates).
Many of us who write add-ins for this stuff use a Box-Muller algorithm
when the variates aren't from a truncated distribution; I assume the
(IMO excellent) commercial package Crystal Ball approaches this
differently, given its age.
There are more free add-ins out there for what you request, but none I
have seen are as well documented, and modern, as PopTools.
HTH
Dave Braden