Microsoft Excel 2013: Data Analysis and Business Modeling - Couverture souple

Winston, Wayne

Couverture souple

ISBN 10 : 0735669139 ISBN 13 : 9780735669130

Editeur : Microsoft Press,U.S., 2014

A propos du livre

Présentation de l'éditeur

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.

Solve real business problems with Excel—and 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

Biographie de l'auteur

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.

Détails de l'édition

• Éditeur: Microsoft Press,U.S.
• Date d'édition: 2014
• ISBN 10: 0735669139
• ISBN 13: 9780735669130
• Reliure: Broché
• Langue: anglais
• Nombre de pages: 896