Tuesday, November 22, 2011

How to Set Up Monte Carlo in Excel 2003


1. Access the Monte Carlo program by either placing the CD in your computer's CD drive or by connecting to the program's network drive if the program is located on a network server. Wait a minute or two while the program loads onto your system.
2. Click 'Start' and go to 'All Programs.' Click on 'Microsoft Excel' to launch the program.
3. Click the 'Tools' tab on the main menu bar and choose 'Add-Ins.' The add-in manager will open. Check 'Monte Carlo' in the add-in list. If the program is not in the list, click 'Browse' and locate the 'MCSim.xla' file under 'Computer' in the removable storage section. Click 'OK.'
4. Click 'Yes' to copy the program to the Excel add-in folder. Monte Carlo is now set up in the Excel program. Click 'OK' to launch the add-in.

Blogger news