<p>Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook. </p> <p> <b>Solve real business problems with Excel—and sharpen your edge</b> </p> <ul> <li>Summarize data with PivotTables and Descriptive Statistics </li> <li>Explore new trends in predictive and prescriptive analytics </li> <li>Use Excel Trend Curves, multiple regression, and exponential smoothing </li> <li>Master advanced Excel functions such as OFFSET and INDIRECT </li> <li>Delve into key financial, statistical, and time functions </li> <li>Make your charts more effective with the Power View tool </li> <li>Tame complex optimization problems with Excel Solver </li> <li>Run Monte Carlo simulations on stock prices and bidding models </li> <li>Apply important modeling tools such as the Inquire add-in </li> </ul>
<p><b>Wayne L. Winston</b> 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.</p>
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.