Wayne L. Winston
Redmond, Washington: Microsoft Press, 2007
624pp, ISBN: 978-0-7356-2396-5
This describes the main techniques for using Excel for data analysis, modeling, and decision-making. It provides real-world examples and exercises to explain how to create scenarios for sales, estimate a product’s demand curve, forecast using trend and seasonality, and determine which product mix will yield the greatest profit. It also covers topics such as asset allocation modeling, and how to optimize bidding strategies and portfolios.