

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 Review: Fantastic, in - depth - 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 business analysis and modeling. The book covers v-lookups, if statements, sorting, conditional formatting, tables, solver, pivot tables, and about 75 other chapters. Highly recommended. Review: Overall great but competing with free is hard - Practical hands on exercises with data that works excellently. Only problem is there are online resources that are free these days in YouTube that perform better for the more basic concepts but may not meet the thoroughness for complex problems as seen in this book. Try the YouTube channel "Excelisfun" if interested.
| Best Sellers Rank | #1,366,881 in Books ( See Top 100 in Books ) #229 in Microsoft Excel Guides #355 in Spreadsheet Books #407 in Data Mining (Books) |
| Customer Reviews | 4.6 out of 5 stars 464 Reviews |
M**I
Fantastic, in - depth
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 business analysis and modeling. The book covers v-lookups, if statements, sorting, conditional formatting, tables, solver, pivot tables, and about 75 other chapters. Highly recommended.
E**S
Overall great but competing with free is hard
Practical hands on exercises with data that works excellently. Only problem is there are online resources that are free these days in YouTube that perform better for the more basic concepts but may not meet the thoroughness for complex problems as seen in this book. Try the YouTube channel "Excelisfun" if interested.
A**R
Perfect
This book is older and maybe that’s why the low price. Excel is such a great program and I love learning more about it. It is 2016 and windows 11 is just around the corner.
S**S
Good Condition
Very good condition
D**L
By far this is one of the best books ever written
By far this is one of the best books ever written, simple expalanations straight to the point covering in detail excel tools and functions, tons of exercises with support materials. This book is the way to go to really learn excel.
P**S
Great book with flaws
The content is great, you're going to learn a lot from this book. The book is huge which isn't a problem, but something you should note if you're deciding between the print and kindle versions. My main issues are with the format of the book and example problems. First, I find it strange that they don't include a short chapter at the beginning about shortcuts. They probably did this because they didn't want to include both Windows and Mac shortcuts. My recommendation to the author: Include a tear-out shortcut page in the beginning of the book for readers to reference. Second, the example workbooks are inconsistent. All examples include a workbook with the solutions filled in, but only some examples offer a blank workbook for you to fill in yourself. In the cases where there is only the solved workbook available, it is easy enough to clear the cells yourself, but it spoils the fun a bit. However, the main issue is that every example is in a separate workbook. Including a separate workbook for both the solutions and the blank workbooks. When you have 6+ examples per chapter, you have to open a minimum of 11 workbooks per chapter for 89 chapters which seems excessive. If you have the "Enable Editing" prompt enabled within Office, you will have to enable editing on each workbook individually which can be a pain. My recommendation to the author: 1 workbook per chapter. Include separate sheets for each example and solution. My recommendation to readers: Disable the "Enable Editing" prompt Finally, there are some sloppy errors in the wording of some of the examples. For example, in one of the chapters they are talking about doing a 10 year forecast, but halfway through the example they switch from years to months. It's not that big of a deal, but it's this inattention to detail that makes you question the author's credibility. My recommendation to John Pierce: As the editor, you should probably be more attentive if the author is going to name-drop you in the acknowledgments. Even with these problems, I still have no problem recommending this book. If the author fixes these issues, I will gladly give this book 5/5. As it is now, this is a 3 star book.
K**E
VBA is a versatile and user friendly language
VBA support in Excel should not be trashed by Microsoft and replaced by another language. Small businesses using Excel VBA for Business Modeling can be put out of business if Excel VBA does not continue to be supported in all subsequent versions / releases of MS Office. Please do not allow the "Quick Change Artists" to violate the "Rules of Change Control" like they did between Office 2007 and Office 2010 when USERS of Excel VBA Business Modeling Software Products could not USE their Excel VBA Models if they upgraded from Excel 2003 to the latest Office versions / releases.
J**.
Excellent Excel reference!
Excellent book! Thus will allow me to take my Excel skills to the next level. I purchased it in conjunction with an EDX class that I was taking.
A**R
Contenido actualizado y práctico.
Cada vez que actualizan la paquetería de MS agregan funcionalidades a sus programas y Excel no se queda atrás. Este libro es el más completo que encontré y no me defraudó. Lo recomiendo ampliamente.
S**T
This is a great book. It is a bit more advanced
This is a great book. It is a bit more advanced, but the techniques in this book are the same that the largest companies in the world use. This isn't a book that says, this is what a VLOOKUP does. This is a book that answers questions like, how can a company maximize profit by minimizing costs and with limited resources (labour and resources).
B**A
Book content
Excellent content to understand
V**H
Valuable resource for data analytics using MS Excel
Excellent book
D**S
Five Stars
Thank you Zmazon.ca....!
Trustpilot
1 month ago
5 days ago