Name: Microsoft Excel Data Analysis and Business Modeling von Wayne Winston
SKU: 9781509304219
Price: 11.50 CHF
Availability: OutOfStock

Microsoft Excel Data Analysis and Business Modeling Zusammenfassung

Microsoft Excel Data Analysis and Business Modeling Wayne Winston

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

Über Wayne Winston

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.

Inhaltsverzeichnis

Chapter 1 Basic spreadsheet modeling
Chapter 2 Range names
Chapter 3 Lookup functions
Chapter 4 The INDEX function
Chapter 5 The MATCH function
Chapter 6 Text functions
Chapter 7 Dates and date functions
Chapter 8 Evaluating investment by using net present value criteria
Chapter 9 Internal rate of return
Chapter 10 More Excel financial functions
Chapter 11 Circular references
Chapter 12 IF statements
Chapter 13 Time and time functions
Chapter 14 The Paste Special command

Zusätzliche Informationen

Sku

GOR009568405

ISBN 13

9781509304219

ISBN 10

1509304215

Titel

Microsoft Excel Data Analysis and Business Modeling Wayne Winston

Autor

Wayne Winston

Serien

Business Skills

Zustand

Gebraucht - Gut

Bindung

Broschiert

Verlag

Microsoft Press,U.S.

Datum

20170119

Anzahl der Seiten

864

Preise

N/A

Begleitschreiben

Die Abbildung des Buches dient nur Illustrationszwecken, die tatsächliche Bindung, das Cover und die Auflage können sich davon unterscheiden.

Hinweis

Dies ist ein gebrauchtes Buch. Es wurde schon einmal gelesen und weist von der früheren Nutzung Gebrauchsspuren auf. Wir gehen davon aus, dass es im Großen und Ganzen in einem guten Zustand ist. Sollten Sie jedoch nicht vollständig zufrieden sein, setzen Sie sich bitte mit uns in Verbindung.