Business Analytics with Excel

Excel Add-ins

Last Updated: 30 November 2024

First time used:

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 Microsoft App Store (from Excel, Insert --> Get Add-ins), 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. It has other readings and several cases which I am happy to share if you are interested.

All comments welcome.

Humberto Barreto
DePauw University
hbarreto@depauw.edu