Microsoft Excel Data Analysis and Business Modeling (Business Skills) - Softcover

Winston, Wayne

 
9781509304219: Microsoft Excel Data Analysis and Business Modeling (Business Skills)
Softcover
ISBN 10: 1509304215 ISBN 13: 9781509304219
Verlag: Microsoft Press, 2016

Inhaltsangabe

Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed.


Solve real business problems with Excel―and build your competitive advantage

  • Quickly transition from Excel basics to sophisticated analytics
  • Summarize data by using PivotTables and Descriptive Statistics
  • Use Excel trend curves, multiple regression, and exponential smoothing
  • Master advanced functions such as OFFSET and INDIRECT
  • Delve into key financial, statistical, and time functions
  • Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts)
  • Make charts more effective by using Power View
  • Tame complex optimizations by using Excel Solver
  • Run Monte Carlo simulations on stock prices and bidding models
  • Work with the AGGREGATE function and table slicers
  • Create PivotTables from data in different worksheets or workbooks
  • Learn about basic probability and Bayes’ Theorem
  • Automate repetitive tasks by using macros

 

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. den Autor

WAYNE L. WINSTON is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School of Business and Visiting Professor of Decision and Information Sciences at University of Houston Bauer College of Business. He has earned numerous MBA teaching awards. For more than 20 years, he has taught clients at Fortune 500 companies, various accounting groups, the US Navy, and the US Army 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.

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Verlag
Microsoft Press
Erscheinungsdatum
2016
Sprache
Englisch
ISBN 10 
1509304215
ISBN 13 
9781509304219
Einband
Taschenbuch
Auflage
5
Anzahl der Seiten
864
Kontakt zum Hersteller
Microsoft
info@impliva.nl

Constructieweg 9
Mijdrecht
3461 SB
Niederlande

Weitere beliebte Ausgaben desselben Titels

9788120353350: Microsoft Excel 2016 : Data Analysis And Business Modeling

Vorgestellte Ausgabe

ISBN 10:  8120353358 ISBN 13:  9788120353350
Verlag: Phi, 2017
Softcover