Microsoft Excel 2010 Data Analysis and Business Modeling

Wayne Winston

Jan 2011 · Pearson Education

About this ebook

Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of his expertise in this hands-on, scenario-focused guide—fully updated for Excel 2010!

Use Excel to solve real business problems—and sharpen your edge!

• Model investment risks and returns
• Analyze your sales team’s effectiveness
• Create best, worst, and most-likely case scenarios
• Compare lease vs. buy, and calculate loan terms
• See how price, advertising, and seasonality affect sales
• Manage inventory with precision
• Quantify the value of customer loyalty
• Calculate your break-even number and ROI
• Maximize scheduling efficiency
• Express “home-field advantage” in real numbers
• Project company growth, predict election results, and more!
• Plus—introduce yourself to PowerPivot for Excel

Your companion web content includes:

• Downloadable eBook
• Hundreds of scenario-based practice problems
• All the book’s sample files—plus customizable templates

Ratings and reviews

nice app

About the author

Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business and has earned numerous MBA teaching awards. For 20+ years, he has taught clients at Fortune 500 companies how to use Excel to make smarter business decisions. Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. He is also a two time Jeopardy! Champion.