Excel Add-ins
Last Updated: 6 January 2025
First time used:
Chapter | Title | Description |
2 | Optimization | Solver add-in: Included in Excel |
3 | Monte Carlo Simulation | MCSim add-in: |
5 | Unemployment | FRED add-in Legacy version: |
6 | Constrained Optimization | Comparative Statics add-in: |
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. These additional course files are available in the Instructor Resources link at top right.
All comments welcome.
Humberto Barreto
DePauw University
hbarreto@depauw.edu