Business Analytics with Excel

Excel Add-ins

Last Updated: 16 May 2024

First use:

Chapter Title Description
2 Optimization

Solver add-in:

Included in Excel

3 Monte Carlo Simulation

MCSim add-in:

MCSim.xla

5 Unemployment

FRED add-in Legacy version:

FRED.xlam

6 Constrained Optimization

Comparative Statics add-in:

CSWiz.xla

Install add-ins by downloading and then using the Add-Ins Manager to install: keyboard shortcut alt, t, i.

The latest FRED version is available in the app store, but it is buggy and error-prone so I continue to use the older version that can be freely downloaded above.

The course also uses a Bloomberg Excel add-in, but it requires access to the Bloomberg terminal, which is expensive and takes some time to learn.

All comments welcome.

Humberto Barreto
DePauw University
hbarreto@depauw.edu