Microsoft Excel Data Analysis and Business Modeling (5th Edition)
| Author | : | |
| Rating | : | 4.75 (690 Votes) |
| Asin | : | 1509304215 |
| Format Type | : | paperback |
| Number of Pages | : | 864 Pages |
| Publish Date | : | 2013-02-17 |
| Language | : | English |
DESCRIPTION:
About the AuthorWAYNE L. . 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. He has earned numerous MBA teaching awards. WINSTON is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School o
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 prices and bidding modelsWork with the AGGREGATE function and table slicersCreate PivotTables from data in different worksheets or workbooksLearn about basic probability and Bayes’ TheoremAutomate repetitive tasks by using macros . 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, action
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. He is also a two time Jeopardy! champion. For more than 20 years, he has taught clients at F
Fantastic, in - depth 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 si. A Very Good Reference 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" according to K. Nottestad. User friendly and very useful. Received in good shape & in a timely manner.