- File Size: 70252 KB
- Print Length: 863 pages
- Page Numbers Source ISBN: 8120353358
- Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
- Publisher: Microsoft Press; 5 edition (November 29, 2016)
- Publication Date: November 29, 2016
- Sold by: Amazon.com Services LLC
- Language: English
- ASIN: B01N2LPD5E
- Text-to-Speech: Enabled
- Word Wise: Enabled
- Lending: Not Enabled
- Amazon Best Sellers Rank: #408,028 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
Microsoft Excel Data Analysis and Business Modeling 5th Edition, Kindle Edition
Use the Amazon App to scan ISBNs and compare prices.
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Customers who bought this item also bought
About the Author
Would you like to tell us about a lower price?
There was a problem filtering reviews right now. Please try again later.
1. The examples are laid out very well and the author provides files that you can download to follow along with;
2. The author does not use boring examples like comparable products, yet real-life problems that the reader can relate to;
3. The author has a tremendous pedigree and can be considered an expert in his field;
4. The material in this book has made me the premier Excel guy at my organization that everyone comes to in order to solve problems.
1. I feel like the author is someone that knows "a lot about a lot" and he tends to hold back on some topics just because his publisher probably imposes a page count limit on him;
2. The book is a large soft-back textbook, but it is still very portable.
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.
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.
Top international reviews
Against: Inconsistencies in the problems sections lets the book down slightly- some of the solution files have minor errors, there doesn't appear continuity in style throughout and some of the finance worked questions are overly complex and may require further research to complete.