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

Wayne L. Winston (Author)

Book Description

Publication Date: May 16, 2007 | ISBN-10: 0735623961 | ISBN-13: 978-0735623965 | Edition: 0002-

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!

CD Includes:

• Sample files from each chapter
• Problem-and-solution sets—build your expertise!
• Fully searchable eBook

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [e-mail].

Editorial Reviews

From the Publisher

Key Book Benefits:

-Teaches the best ways to use Excel for data analysis and decision making.

-Features real-world scenarios in each chapter, and then shows you how to use Excel to create an effective solution.

-Delivers hundreds of problem-and-solution examples.

-Covers topics including asset allocation modeling; creating histograms, elasticity and demand curves; estimating exponential growth; forecasting sales; optimizing bidding strategies and portfolios; and more!

-Includes a CD with sample files used in the book.

About the Author

Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business and has earned numerous MBA teaching awards. For 20+ years, he has taught clients at Fortune 500 companies how to use Excel to make smarter business decisions. Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. He is also a two time Jeopardy! champion.

Product Details

• Paperback: 624 pages
• Publisher: Microsoft Press; 0002- edition (May 16, 2007)
• Language: English
• ISBN-10: 0735623961
• ISBN-13: 978-0735623965
• Product Dimensions: 1.4 x 7.2 x 8.7 inches
• Shipping Weight: 2.1 pounds
• Average Customer Review: 4.2 out of 5 stars  See all reviews (24 customer reviews)
• Amazon Best Sellers Rank: #213,265 in Books (See Top 100 in Books)

More About the Author

Wayne L. Winston is a professor of Decision Sciences at Indiana
University, Kelley School of Business and has earned numerous MBA teaching
awards over the past two decades. Wayne also consults for several Fortune
500 clients. He and his business partner Jeff Sagarin developed the
statistics tracking and rating system used by the Dallas Mavericks
professional basketball team. Wayne is also a two-time Jeopardy champion.

Most Helpful Customer Reviews

39 of 41 people found the following review helpful

3.0 out of 5 stars GREAT BOOK w/MANY, MANY errors December 11, 2009

By Robert Shepard

Format:Paperback|Amazon Verified Purchase

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

This book should be on the desk of anyone analyzing data. It IS NOT for someone who doesn't know Excel 2007 and the basics of analyzing or working with data.

However, I've gone through Chapter 39 and have found this book is filled with all kinds of errors. I couldn't find any place on the internet that addresses these errors. Files missing or wrong (ie. Chapter 9 solution file problem numbers are incorrect), examples not matching my Office, Home, Student 2007 version (ie. pg. 43 references a DATEIF function that doesn't exist), plus many more.

The author or Microsoft needs to do a better job of proofreading or at least have a website where readers can post the errors they find so everybody using this book doesn't spend their time refinding the same errors.

27 of 28 people found the following review helpful

5.0 out of 5 stars Book is great, online course is better! May 28, 2009

By Patricia A. Haldi

Format:Paperback

Must read for anyone who models business problems or does statistical analysis.

If you haven't been to one of his seminars, you should check out his online course, Spreadsheet Modeling, developed by Harvard Business School ([...]

The course shows you how to create spreadsheet models to analyze both simple and complex problems. It's practical and painless. Includes lots of great videos and is very interactive.

15 of 15 people found the following review helpful

5.0 out of 5 stars Very useful book for financial analysis. March 26, 2010

By FC

Format:Paperback|Amazon Verified Purchase

When I just started my career as a financial analyst, a project manager gave me a pile of condensed training materials which included the excel functions that I would be using most frequently. I bought this Data Analysis & Modeling book 2-3 weeks after my first day of work and I found many of those taught in the book aligned with those on the training materials from my manager. The book has been very useful to me as it has a lot of cases to demonstrate how those functions can be applied.

This book is a book teaching MS Excel, but shaped in a way that focuses more on functions that are useful to financial analysis. It won't make you a financial expert after reading the book -- you need to know the financial concepts like fixed / variable cost, NPV & IRR, stocks & options first, then the tools introduced in the book will help you organize, calculate or present your data.

Pros:
- Clear step by step explanation
- Lots of examples & Exercises included in CD.

15 of 19 people found the following review helpful

5.0 out of 5 stars Great Overview of the Power of Excel 2007 January 7, 2008

By Hop

Format:Paperback

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!

6 of 7 people found the following review helpful

3.0 out of 5 stars Not as useful as I was hoping. Could be more in-depth with OR examples. August 2, 2009

By David Alan Tussey

Format:Paperback|Amazon Verified Purchase

Having studied Wayne Wilson's OR materials, I was hoping this book would be a bit more technical and in-depth. Basically, I was hoping for a "how to do OR type problems with Excel". This book didn't quite meet those expectations.

For example, the forecasting portion talks only about Winter's method, which is great, but often that is too much for a simple forecast. And the LP approach doesn't really talk about Linear Programming...it only casually mentions the "Simplex" algorithm, and nothing about sensitivity tables.

So Dr. Wilson, if you're reading -- could you write a real OR book that uses the Excel 2007 tools? for real OR people?

8 of 10 people found the following review helpful

5.0 out of 5 stars Best, Most Practical Book in the Field August 11, 2008

By DJ

Format:Paperback

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 3 people found the following review helpful

4.0 out of 5 stars Good Purchase July 16, 2010

By dvd224

Format:Paperback|Amazon Verified Purchase

Overall this is a great buy, it is a comprehensive read which breaks the information down into manageable sections. The only thing i think could be improved upon are the practice files which i could use a little more organization. I assume they are great in a classroom setting but are sometimes hard to immediately follow for the independent reader.

1 of 1 people found the following review helpful

4.0 out of 5 stars 3 1/2 Stars - Good but there are some problems July 4, 2011

By In2books

Format:Paperback|Amazon Verified Purchase

Good guide for more advanced business models. Not for a novice in Excel or Statistics. There were some errors in the book and the file didn't always agree with the example in the book, but overall it was helpful.