Learn How to Do-It-Yourself!
  Search:       

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other)

by Wayne L. Winston

List Price:$39.99
Amazon Price:$26.39 & eligible for FREE Super Saver Shipping on orders over $25.
You Save:$13.60 (34%)
Average Rating:4 out of 5 stars
Lowest New Price:$21.70
Availablitiy:Usually ships in 24 hours

Buy Now!


Editorial Reviews
Product Description
Master the analysis and business modeling techniques that help you transform your data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical guide now updated for Excel 2007. Use Wayne s proven practices and hands-on exercises to help you work smarter, make better decisions, and gain the competitive edge. Solve real-world business problems with Excel 2007! Maximize profits determine NPV, optimize your product mix, calculate ROI Create best, worst, and most-likely case scenarios for sales Analyze investment performance and help minimize risk Track your personal finances, calculate loan terms, and plan for retirement Use trend and seasonality to forecast revenue Estimate a product s demand curve and manage inventory with precision Interpret the effects of price and advertising on sales Assign a dollar value to customer loyalty Solve work scheduling problems and shorten wait times for customer service queues PLUS predict outcomes of sporting events, presidential elections, and more!C D Includes: Sample files from each chapter Problem-and-solution sets build your expertise! Fully searchable eBook


All Customer Reviews
Average Customer Review:4 out of 5 stars
0 of 0 people found the following review helpful:

5 out of 5 starsQuestion, 2008-11-24
First of all I thought this was a fantastic book and I was amazed with just how much one can do with Excel.

My question has to do with Chapters 7 and 13

The question Wayne Winston answered is this.

"I'm thinking of starting a store in the local mall to sell gourmet lemonade. Before opening the store, I'm curious about how my profit, revenue, and variable costs will depend on the price I charge and the unit cost."

Part of his answer is assuming annual demand.

"We're assuming that annual demand for lemonade (See formula in cell D2) equals 65000-9000*Price. (Chapter 7, "Evaluating Investments by Using Net Present Value Criteria," contains adiscussion of how to estimate a demand curve.)"

I reread Chapter 7 and no where does it state how to estimate a demand curve.

I was wondering how Wayne Winston got this formula. (Chapter 13 file Lemonade.xlsx.)


0 of 0 people found the following review helpful:

2 out of 5 starsNot Useful, 2008-11-19
I bought the book to do a spreadsheet for a new business. The author assumes I am already well versed in Excel, but at this point, I hadn't used Excel for about 6 years. Maybe I should not have purchsed this book, as the author covers topics not useful to me. I would think that business modeling allows one to do a spread sheet and do sensitivity analysis, as to which items are major cost drivers. This is obvious by inspection. Excel also allows one to do pie charts and bar charts.

The author gets into present value calculations and internal rate of returns but there is better software for this. He includes a disk but it wasn't obvious to me which files to open.

This book would be better used in a finance class. It's not for the user who needs some quick help.

There is lots of material in this book, but its usefullness, for me, was minimal.


2 of 3 people found the following review helpful:

5 out of 5 starsBest, Most Practical Book in the Field, 2008-08-11


Winston is a guru in his field and it shows in this book, which tackles all the necessary tools you will need "on the job" and does so in a rich, but easy to understand language.

At times, you will feel that the author is coaching you all along, right over your shoulder.

an amzing book that I reference at least once a week, this book is must-own for anyone who wants to model business decisions & stand out among your peers


3 of 7 people found the following review helpful:

4 out of 5 starsMicrosoft Office Excel 2007: Data Analysis and Business Modeling, 2008-01-24
Huge improvement over past Excel manuals because this financial analyst can actually understand the steps being described.


7 of 9 people found the following review helpful:

5 out of 5 starsGreat Overview of the Power of Excel 2007, 2008-01-08
I'll start by saying I'm biased: I believe Excel 2007 is awesome. So, this book is a great reference for how to get more out of a great tool. I've been to Wayne's seminars, adn his book is a great substitute for his classroom knowledge and experience. THe examples are highly practical, and his data samples on the included CD make learning how to use the functions a lot easier. Love the basketball and baseball stat examples!




Price is accurate as of the date/time indicated. Prices and product availability are subject to change. Any price displayed on the Amazon website at the time of purchase will govern the sale of this product.
Related Products