Del 0 - Business Skills

Microsoft Excel Data Analysis and Business Modeling

Häftad, Engelska, 2017

859 kr

Slutsåld

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

Produktinformation

Utgivningsdatum2017-01-26
Mått190 x 229 x 44 mm
Vikt1 437 g
FormatHäftad
SpråkEngelska
SerieBusiness Skills
Antal sidor864
Upplaga5
FörlagPearson Education
ISBN9781509304219

Tillhör följande kategorier

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.

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

Mer från samma författare

Business Analytics

S. Albright, Wayne Winston, School of Business (Emeritus)) Albright, S. (Indiana University, Kelley School of Business (Emeritus)) Winston, Wayne (Indiana University

Häftad

1 609 kr

Business Analytics

S. Albright, Wayne Winston

Inbunden

1 409 kr

Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)

Wayne Winston

Häftad

519 kr

Practical Management Science

Wayne Winston, S. Albright, Kelley School of Business (Emeritus)) Winston, Wayne (Indiana University, School of Business (Emeritus)) Albright, S. (Indiana University

Inbunden

1 499 kr