Microsoft Excel Data Analysis and Business Modeling (5th Edition)
| Author | : | |
| Rating | : | 4.35 (902 Votes) |
| Asin | : | 1509304215 |
| Format Type | : | paperback |
| Number of Pages | : | 864 Pages |
| Publish Date | : | 2016-05-14 |
| Language | : | English |
DESCRIPTION:
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 advantageQuickly transition from Excel basics to sophisticated analyticsSummarize data by using PivotTables and Descriptive StatisticsUse Excel trend curves, multiple regression, and exponential smoothingMaster advanced functions such as OFFSET and INDIRECTDelve into key financial, statistical, and time functionsLeverage the new charts in Excel 2016 (including box and whisker and waterfall charts)Make charts more effective by using Power ViewTame complex optimizations by using Excel SolverRun Monte Carlo simulations on stock price
About the AuthorWAYNE L. He is also a two time Jeopardy! champion. He has earned numerous MBA teaching awards. Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. 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. . 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 Baue
"Fantastic, in - depth" according to Mason. Fantastic book! I was, by no means, an excel expert. This book is well structured to where anybody can understand. I love the example and template files to help you understand the processes. Then at the end of each chapter, there are questions that require you to create spreadsheets on your own. These last few questions do a terrific job reinforcing the chapter and making sure you truly understand the concepts and where to use them, rather than just understanding simple procedures.This book is quite extensive and I'd recommend it if you wish to be successful in busines. A Very Good Reference The Real Bob If you are interested in learning how to model with Excel then this is a very good reference. Covers a lot of ground from the basic Excel functions used to create pretty robust models. A step by step approach and examples online, the reader who is willing to invest time should get a lot of benefit from the work.. Five Stars User friendly and very useful. Received in good shape & in a timely manner.
Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. WAYNE L. He has earned numerous MBA teaching awards. He is also a two time Jeopardy! champion. 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. . WINSTON is Professor Emer