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

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 (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 (View shipping rates and policies)
• Average Customer Review: 4.1 out of 5 stars  See all reviews (21 customer reviews)
• Amazon Best Sellers Rank: #40,119 in Books (See Top 100 in Books)
  • #24 in Books > Computers & Technology > Computer Science > Modeling & Simulation

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

Most Helpful Customer Reviews

35 of 37 people found the following review helpful:

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

By 

Robert Shepard "Fact Reader" (Lexington, KY) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other) (Paperback)

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.

24 of 24 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 (Needham, MA USA) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other) (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 (http://hbdm.harvardbusiness.org/courses).

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.

14 of 14 people found the following review helpful:

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

By 

FC (Los Angeles, USA) - See all my reviews

Amazon Verified Purchase

This review is from: Microsoft® Office Excel® 2007: Data Analysis and Business Modeling (Bpg -- Other) (Paperback)

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.