Can anyone help me to understand how to apply Cholesky decomposition to Monte-Carlo simulation? I just about understand Monte-Carlo simulation and can model it in Excel but as I understand it catering for correlation is acheived by somehow constraining the random numbers that are used.