Business Analytics with Excel

Welcome

Last Updated: 4 October 2024

This site has open-access open-access graphic 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
(Maddison Data)

PV & IRR

5
Unemployment

FRED Excel add-in

Seasonal Adjustment

Bloomberg terminal
(not in book, available upon request)

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
(not in book, available upon request)

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

List of Excel functions used

Proceed by clicking on the Menu items (top-right) to access the materials.

All comments welcome.

Humberto Barreto
DePauw University
hbarreto@depauw.edu