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.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Business Skills) 1st Edition

4.3 out of 5 stars 32 customer reviews
ISBN-13: 978-0735623965
ISBN-10: 0735623961
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
$5.00
Condition: Used - Good
Condition: Used: Good
Comment: Item is in good condition. May include some wear and creases on the cover. Fast shipping. Free delivery confirmation with every order.
Access codes and supplements are not guaranteed with used items.
66 Used from $0.01
FREE Shipping on orders over $25.
More Buying Choices
12 New from $31.57 66 Used from $0.01
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Windows10ForDummiesVideo
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
click to open popover

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.

NO_CONTENT_IN_FEATURE

The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

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: 7.4 x 1.5 x 9.1 inches
  • Shipping Weight: 2.8 pounds
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (32 customer reviews)
  • Amazon Best Sellers Rank: #798,971 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

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 40 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 29 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 16 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 15 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I bought this book many years ago and the previous edition as well. i still refer to it at times if I am faced with a new problem that I need to solve. I will credit this book as be the most eye-opening book on Excel that I have ever read. It clearly re-energized me to take Excel to places I never imagined it could go. This book is also an easy read, even fascinating, to me at least. Each chapter unveils concepts so simply yet many Excel users may not have touched on the capability previously. In fact, I discovered power in Excel I never imagined existed and have leveraged it hundreds of times since. Pick any chapter and start reading, Each one seems to be so self-contained, that you can just jump right in. This is a book I would never want to be without for Excel.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I purchased this to supplement a graduate level Quantitative Decision Analysis course I am taking as part of an MBA program.

I was intending to learn some shortcuts and best practices in Excel, mainly for linear programming models, and with hope that some PivotTable wizardry would also be covered.

The book does a fine job of covering the basics on these and many other topics (descriptive statistics, nonlinear models, etc.), in brief, if not superficial depth.

Its good for a quick and basic primer and for some very simple templates, but not really what I was looking for in terms of depth and complexity.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book is exactly what I needed to understand the more advanced functions in Excel. I am a VBA programmer and used the information to construct applications to automate the process of forecasting sales orders for a major automotive manufacturer.
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews