Business Analytics with Excel

Welcome

Last Updated: 25 Mar 2024

This site has open-access open-access graphic CC-BY-SA materials (PDF or via LaTex source files) 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.

Chapter
Title
Description
1
Introduction
Defining Business Analytics
2
Optimization

Lifeguard Problem

Solver add-in

3
Monte Carlo Simulation

MCSim add-in

Parrondo's Paradox

Pooled testing

Economic Mobility
4
Growth

CAGR & Rule of 70

Economic Growth
(Maddison Data)

PV & IRR
5
Unemployment

FRED add-in

Seasonal Adjustment

Bloomberg terminal
(not in book, available upon request)
6
Constrained Optimization

2D & 3D Data Visualization

Solver add-in

Comparative Statics Wizard add-in

Elasticity
7
Yield Curve

3D Visualization

FRED add-in

Python

Bloomberg terminal
(not in book, available upon request)
8
GDP

Y = C + I + G + NX

FRED add-in

International comparisons of Investment
9
VBA

Introducing Macros in Excel

Functions
10
Demography

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