Chapter 1
Data Series Examples.xls
Fill Handle Examples.xls
Selecting Cells by Differences.xls
Summary of Quarterly Sales and Expenses.xls

Chapter 2
Amortization Schedule.xls
Expenses.xls
Penske.xls

Chapter 3
2005 Budget - Summary.xls
2005 Budget.xls
Custom Cell Format Examples.xls
Expenses.xls
Pre-Tax Cost Calculation.xls

Chapter 4
Array Diagram.xls
Array Formulas - Using a Range Versus Using an Array Constant.xls
Consolidation.xls
Division A Budget.xls
Division B Budget.xls
Division C Budget.xls
Division I Budget.xls
Division II Budget.xls
Division III Budget.xls
Expenses.xls
Invoice Template.xls
Iteration.xls
Worksheet Dialog Box Controls.xls

Chapter 5
Auditing - Tracer Arrow Examples.xls

Chapter 6
Future Value Calculator.xls

Chapter 7
Expenses.xls
Text Functions.xls

Chapter 8
Information Functions.xls
Logical Functions.xls

Chapter 9
Exact Match Lookup.xls
Lookup Functions.xls

Chapter 10
Date and Time Functions.xls

Chapter 11
Math Functions.xls

Chapter 12
Statistics.xls

Chapter 13
Lists.xls

Chapter 14
Analysis.xls
Modeling.xls

Chapter 15
Forecast.xls
Regression.xls

Chapter 16
Solver.xls

Chapter 17
Loans.xls

Chapter 18
Investments.xls

Chapter 19
Bonds.xls

Chapter 20
Discounting.xls