Welcome
Last Updated: 16 May 2024
This site has open-access 
CC-BY-SA materials for an introductory Business Analytics course that heavily emphasizes Microsoft Excel. There are no prerequisites and the target audience is first- or second-year undergraduate students who have used a spreadsheet before, but have no specialized training in Excel, calculus, statistics, or programming.
The book is available as a single pdf or individual chapters in the Book menu item (top-right).
The level and contents are conveyed in the table and the list of Excel functions below.
Chapter |
Title |
Description |
1 |
Introduction |
Defining Business Analytics |
2 |
Optimization |
Lifeguard Problem Solver Excel add-in |
3 |
Monte Carlo Simulation |
MCSim Excel add-in Parrondo's Paradox Pooled Testing Economic Mobility |
4 |
Growth |
CAGR & Rule of 70 Long Run Economic Growth PV & IRR |
5 |
Unemployment |
FRED Excel add-in Seasonal Adjustment Bloomberg terminal |
6 |
Constrained Optimization |
2D & 3D Data Visualization Solver Excel add-in Comparative Statics Wizard Excel add-in Elasticity |
7 |
Yield Curve |
3D Visualization FRED Excel add-in Python Bloomberg terminal |
8 |
National Income Accounting |
Y = C + I + G + NX FRED add-in International comparisons of Investment |
9 |
VBA |
Introducing Macros in Excel Functions |
10 |
Demography |
Visualization: Population Pyramids Demographic Analytics |
Proceed by clicking on the Menu items (top-right) to access the materials.
All comments welcome.
Humberto Barreto
DePauw University
hbarreto@depauw.edu