Microsoft Excel 2013 Data Analysis and Business Modeling

Wayne Winston

ISBN 10: 0735669139 / ISBN 13: 9780735669130

Editore: Microsoft Press,U.S., United States, Redmond, 2014

Riguardo questo articolo

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 tablesand how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Exceland sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts more effective with the Power View tool Tame complex optimization problems with Excel Solver Run Monte Carlo simulations on stock prices and bidding models Apply important modeling tools such as the Inquire add-in. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.

Codice articolo GOR007167318

Dati bibliografici

• Titolo: Microsoft Excel 2013 Data Analysis and Business Modeling
• Editore: Microsoft Press,U.S., United States, Redmond
• Data di pubblicazione: 2014
• Lingua: Inglese
• ISBN 10: 0735669139
• ISBN 13: 9780735669130
• Rilegatura: Paperback
• Condizione: Very Good
• Peso: 1451 grammi

Descrizione articolo

Riassunto

<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>

Informazioni sugli autori

<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.