Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Business Skills) Paperback – May 16, 2007

ISBN-13: 978-0735623965 ISBN-10: 0735623961 Edition: 1st

11 New from $15.00 49 Used from $0.01
Amazon Price New from Used from
Kindle
"Please retry"
Paperback, May 16, 2007
$15.00 $0.01
Amazon%20Web%20Services


Frequently Bought Together

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Business Skills) + Pivot Table Data Crunching for Microsoft Office Excel 2007 + Excel 2007 Bible
Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: Business Skills
  • Paperback: 624 pages
  • Publisher: Microsoft Press; 1 edition (May 16, 2007)
  • Language: English
  • ISBN-10: 0735623961
  • ISBN-13: 978-0735623965
  • Product Dimensions: 9 x 7.4 x 1.4 inches
  • Shipping Weight: 2.1 pounds
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (28 customer reviews)
  • Amazon Best Sellers Rank: #342,583 in Books (See Top 100 in Books)

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.


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.

Customer Reviews

This book will tell you more than you need to know about Excel.
Eric "honestly opinionated" Kim
The book has been very useful to me as it has a lot of cases to demonstrate how those functions can be applied.
FC
I highly recommend this book as a great source of information and reference.
D. Watts

Most Helpful Customer Reviews

39 of 42 people found the following review helpful By Robert Shepard on December 11, 2009
Format: Paperback 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.
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
28 of 29 people found the following review helpful By Patricia A. Haldi on May 28, 2009
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.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
15 of 15 people found the following review helpful By FC on March 26, 2010
Format: Paperback 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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
15 of 19 people found the following review helpful By Hop on January 7, 2008
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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 7 people found the following review helpful By David Alan Tussey on August 2, 2009
Format: Paperback 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?
3 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 10 people found the following review helpful By DJ on August 11, 2008
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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By dvd224 on July 16, 2010
Format: Paperback 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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By D. Grigsby on November 16, 2009
Format: Paperback Verified Purchase
This book is an excellent, comprehensive explanation of how to leverage the analysis tools in Excel 2007. The case study approach for the general tool topics helps you connect the type of analysis you may need with the appropriate tool set. The table of contents addresses all the tools and the first page of each chapter lists different cases where the tool can be applied, so it's quick to figure out the best approach to finding what you need. The accompanying CD with example files is extremely helpful. It allows you to examine the raw data and how the different tools are applied. I would recommend this book as both an effective primer for someone not so familiar with Excel's more powerful tools and a nice reference for those who simply need to look up specific formulas or approaches. It covers a wide range of situations where Excel's analytical tools can help.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


What Other Items Do Customers Buy After Viewing This Item?