Business Analytics with Excel

Click on the link below to download a pdf of the entire book:

This open-access CC-BY-SA book is a how-to manual for students to create their own Excel workbooks from a wide range of examples.

The content is modular and standalone. Each chapter is a unit, but a pdf file in the table below can be used for a single class.

Please let me know if you would rather have the Latex files and I am happy to share them with you.

Chapter	Title	Description	Files
1	Introduction	Defining Business Analytics	1DefiningBA.pdf
2	Optimization	Lifeguard Problem Solver add-in Comparative Statics	2ALifeguardProblem.pdf 2BCompStatics.pdf 2CSolver.pdf 2DPracticeProblem.pdf
3	Monte Carlo Simulation	MCSim add-in Parrondo's Paradox Pooled testing	3AMCSim.pdf 3BParrondo.pdf 3CPooledTesting.pdf
4	Growth	CAGR & Rule of 70 Economic Growth (Maddison Data) PV & IRR	4AGrowthMath.pdf 4BGrowthData.pdf 4CPVIRR.pdf 4DCollegeIRR.pdf
5	Unemployment	FRED add-in Seasonal Adjustment Bloomberg terminal (not in book, available upon request)	5AUnemFRED.pdf 5BUnemGroups.pdf 5CUnemSA.pdf
6	Constrained Optimization	2D & 3D Data Visualization Solver Elasticity	6ACigarsBrandies.pdf 6BConOpt.pdf 6CCSWiz.pdf 6DElasticity.pdf 6ECostMin.pdf
7	Yield Curve	3D Visualization FRED add-in Python Bloomberg terminal (not in book, available upon request)	7AYieldCurve.pdf 7BYieldCurveViz.pdf
8	National Income Accounting	Y = C + I + G + NX FRED add-in International comparisons of Investment	8AGDPI.pdf 8BInternationalInv.pdf
9	VBA	Introducing Macros in Excel Functions	9AVBA.pdf 9BMoreVBA.pdf
10	Demography	Population Pyramids Demographic Analytics	10APopPyr.pdf 10BDemoAnalytics.pdf

All comments welcome.

Humberto Barreto
DePauw University
hbarreto@depauw.edu