Book Description
Now you can apply the techniques that business analysts at leading companies use to analyze and transform data into bottom line results. For more than 10 years, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA candidates the most effective ways to use Microsoft Excel for data analysis, modeling, and decision making. This practical, business-focused guide delivers the best of Winston’s classroom experience to you in 70+ concise chapters, organized by real-world scenarios. Quickly find and apply exactly the information you need to solve a specific business problem—from asset allocation modeling to estimating exponential growth, forecasting sales, optimizing portfolios, and other critical functions. You also get all the book’s sample files on CD-ROM—ready for use in your own work.


About the Author
Wayne L. Winston teaches decision sciences at Indiana University’s Kelley School of Business. For more than 10 years he has taught business analysts how to use Excel to make better decisions. His clients include Bristol-Myers Squibb Company; Cisco Systems, Inc.; Eli Lilly and Company; Ford Motor Company; General Motors Corporation; Intel Corporation; Microsoft Corporation; NCR Corporation; Owens Corning; Pfizer, Inc.; Proctor & Gamble; the U.S. Army; and the U.S. Department of Defense. Wayne and business partner Jeff Sagarin developed a player rating system that the Dallas Mavericks use to identify statistical trends and evaluate players. Wayne is also a two-time Jeopardy! Champion.

FROM OUR EDITORS

The Barnes & Noble Review
Wayne Winston has taught Excel analysis and modeling to thousands of analysts, from Microsoft to the Department of Defense. Now, he￯﾿ﾽs written the definitive guide for working businesspeople: simply the best we￯﾿ﾽve ever seen on the subject.

Winston walks you through one challenge and feature at a time, from the simplest (range names) all the way through Black-Scholes options calculations. Using real-world examples, he explains IRR, auditing, sensitivity analysis, goal seek, data validation, PivotTables, demand curves, risk analysis, and plenty more.

Your payoff: a closing chapter on picking your fantasy football team. Don￯﾿ﾽt laugh: Winston consults with Mark Cuban and the Dallas Mavericks on using Excel to rate basketball players. Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2003 and Upgrading & Fixing Networks for Dummies, Second Edition.

FROM THE PUBLISHER

Now you can apply the techniques that business analysts at leading companies use to analyze and transform data into bottom line results. For more than 10 years, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA candidates the most effective ways to use Microsoft Excel for data analysis, modeling, and decision making. This practical, business-focused guide delivers the best of Winston￯﾿ﾽs classroom experience to you in 70+ concise chapters, organized by real-world scenarios. Quickly find and apply exactly the information you need to solve a specific business problem￯﾿ﾽfrom asset allocation modeling to estimating exponential growth, forecasting sales, optimizing portfolios, and other critical functions. You also get all the book￯﾿ﾽs sample files on CD-ROM￯﾿ﾽready for use in your own work. Updated versions of some files are available at: Microsoft's Knowledge Base site at: http://support.microsoft.com/default.aspx?scid=kb;en-us;842652.

SYNOPSIS