Business analytics : the art of modeling with spreadsheets

Introduction -- Modeling in a problem-solving framework -- Spreadsheet engineering -- Analysis using spreadsheets -- Data exploration and preparation -- Classification and prediction methods -- Short-term forecasting -- Nonlinear optimization -- Linear optimization -- Optimization of network models -- Integer optimization -- Optimization of nonsmooth models -- Decision analysis -- Monte carlo simulation -- Optimization in simulation -- Modeling cases -- Appendix 1 Basic excel skills -- Appendix 2 Macros and VBA -- Appendix 3 Basic probability concepts