Microsoft Excel Data Analysis and Business Modeling (Business Skills) 5th Edition

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.

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.

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.

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.

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.

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" promptFinally, 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.

Extremely useful! Wish I’d found it while suffering the grad school! My company can’t afford expensive data /statistical analysis programs so if you’re already fácil with Excel, this can give you the power needed without cost or completely learning a new program!

I think I'll be using this book for a long time to come. I learned a lot of advanced excel techniques in a relatively short amount of time. I find that using this as a guide while practicing on excel is the best way to get the most value out of this book.