Microsoft® Office Excel® 2007: Data Analysis and Business Modeling

Product Description

Master the techniques that business analysts at leading companies use to transform data into bottom-line results. For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Office Excel for data analysis, modeling, and decision making. Now this award-winning educator shares the best of his classroom experience in this practical, business-focused guide--updated and expanded for Excel 2007. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. You'll learn how to create best, worst, and most-likely scenarios for sales, estimate a product's demand curve, forecast using trend and seasonality, and determine which product mix will yield the greatest profit. You'll even discover how to interpret the effects of price and advertising on sales and how to assign a dollar value to customer loyalty. You get all the book's problem-and-solution files on CD--for all the practice you need to solve complex problems and work smarter with Excel.

Key Book Benefits

• Teaches the best ways to use Excel for data analysis and decision making.
• Features real-world scenarios in each chapter, and then shows you how to use Excel to create an effective solution.
• Delivers hundreds of problem-and-solution examples.
• Covers topics including asset allocation modeling; creating histograms, elasticity and demand curves; estimating exponential growth; forecasting sales; optimizing bidding strategies and portfolios; and more!
• Includes a CD with sample files used in the book.

About Wayne L. Winston

Wayne L. Winston is a professor of Decision Sciences at Indiana University, Kelley School of Business and has earned numerous MBA teaching awards over the past two decades. Wayne also consults for several Fortune 500 clients. He and his business partner Jeff Sagarin developed the statistics tracking and rating system used by the Dallas Mavericks professional basketball team. Wayne is also a two-time Jeopardy champion.

More Business books

More Personal Finance books

More Software books

More Balanced Scorecards books

More Excel Books