Buy new:
$30.69
FREE delivery: Wednesday, May 1 on orders over $35.00 shipped by Amazon.
Ships from: Amazon.com
Sold by: Amazon.com
List Price: $49.99 Details

The List Price is the suggested retail price of a new product as provided by a manufacturer, supplier, or seller. Except for books, Amazon will display a List Price if the product was purchased by customers on Amazon or offered by other retailers at or above the List Price in at least the past 90 days. List prices may not necessarily reflect the product's prevailing market price.
Learn more
Save: $19.30 (39%)
Get Fast, Free Shipping with Amazon Prime FREE Returns
FREE delivery Wednesday, May 1 on orders shipped by Amazon over $35
Or fastest delivery Tuesday, April 30. Order within 6 hrs 50 mins
Only 3 left in stock (more on the way).
$$30.69 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$30.69
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon.com
Ships from
Amazon.com
Sold by
Amazon.com
Sold by
Amazon.com
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Get Fast, Free Shipping with Amazon Prime
FREE delivery Wednesday, May 1 on orders shipped by Amazon over $35
Or fastest delivery Tuesday, April 30. Order within 9 hrs 50 mins
Used: Good | Details
Sold by Martistore
Fulfilled by Amazon
Condition: Used: Good

Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.

If you're a seller, Fulfillment by Amazon can help you grow your business. Learn more about the program.

Access codes and supplements are not guaranteed with used items.
Amazon book clubs early access
Loading your book clubs
There was a problem loading your book clubs. Please try again.
Not in a club? Learn more
Amazon book clubs early access

Join or create book clubs

Choose books together

Track your books
Bring your club to Amazon Book Clubs, start a new book club and invite your friends to join, or find a club that’s right for you for free.
Explore Amazon Book Clubs
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Wayne Winston
Follow
Something went wrong. Please try your request again later.

Microsoft Excel Data Analysis and Business Modeling (Business Skills) 5th Edition

by Wayne Winston (Author)
4.5 4.5 out of 5 stars 446 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$30.69","priceAmount":30.69,"currencySymbol":"$","integerValue":"30","decimalSeparator":".","fractionalValue":"69","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"oJwI7PzXqAR4Ofe7C0%2BAiiLUEJEMpgoj6CNDtqG4L2ZZAAZOyybjGSRRY%2Bk6iiQC4MWZvzGkgnwJlWEodjU1gEqOeXudZ9NS%2F%2B9QVsgXENDkSh%2FxH2sdP%2Bi768Q9fNFxdpIgqppz6bswGoopi2wi4g%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$14.80","priceAmount":14.80,"currencySymbol":"$","integerValue":"14","decimalSeparator":".","fractionalValue":"80","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"oJwI7PzXqAR4Ofe7C0%2BAiiLUEJEMpgojofSsp9WmScq9NmGMRLveDPUJqTuazNHZm49bHFeyrlx1hWAfpBDhfEvqySnpfX87BVeq3%2BKbZVGPHojf8PEdSpS7kihS8%2FoyJYMmC1z9CznDrppKno2061BSRBp0qVyebZzQUtBVAPw%2FXnC2IWuTCl0YlzwL5OFX","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel’s newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you’re fully up to speed.


Solve real business problems with Excel—and build your competitive advantage

  • Quickly transition from Excel basics to sophisticated analytics
  • Summarize data by using PivotTables and Descriptive Statistics
  • Use Excel trend curves, multiple regression, and exponential smoothing
  • Master advanced functions such as OFFSET and INDIRECT
  • Delve into key financial, statistical, and time functions
  • Leverage the new charts in Excel 2016 (including box and whisker and waterfall charts)
  • Make charts more effective by using Power View
  • Tame complex optimizations by using Excel Solver
  • Run Monte Carlo simulations on stock prices and bidding models
  • Work with the AGGREGATE function and table slicers
  • Create PivotTables from data in different worksheets or workbooks
  • Learn about basic probability and Bayes’ Theorem
  • Automate repetitive tasks by using macros

Previous page
  1. ISBN-10
    1509304215
  2. ISBN-13
    978-1509304219
  3. Edition
    5th
  4. Publisher
    Microsoft Press
  5. Publication date
    December 9, 2016
  6. Language
    English
  7. Dimensions
    7.4 x 1.75 x 9 inches
  8. Print length
    864 pages
  9. See all details
Next page
Books with Buzz
Books with Buzz
Discover the latest buzz-worthy books, from mysteries and romance to humor and nonfiction. Explore more

Frequently bought together

Microsoft Excel Data Analysis and Business Modeling (Business Skills)
$30.69
Get it as soon as Wednesday, May 1
Only 3 left in stock (more on the way).
Ships from and sold by Amazon.com.
+
Excel Formulas (Quick Study Computer)
$5.95
Get it as soon as Wednesday, May 1
In Stock
Ships from and sold by Amazon.com.
+
Excel 2016 Bible (Bible (Wiley))
$37.18
Get it as soon as Wednesday, May 1
Only 19 left in stock (more on the way).
Ships from and sold by Amazon.com.
Total price:
To see our price, add these items to your cart.
Details
Added to Cart
Some of these items ship sooner than the others.
Show details Hide details
Choose items to buy together.

Editorial Reviews

About the Author

WAYNE L. WINSTON is Professor Emeritus of Decision Sciences at Indiana University’s Kelley School of Business and Visiting Professor of Decision and Information Sciences at University of Houston Bauer College of Business. He has earned numerous MBA teaching awards. For more than 20 years, he has taught clients at Fortune 500 companies, various accounting groups, the US Navy, and the US Army 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

  • Publisher ‏ : ‎ Microsoft Press; 5th edition (December 9, 2016)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 864 pages
  • ISBN-10 ‏ : ‎ 1509304215
  • ISBN-13 ‏ : ‎ 978-1509304219
  • Item Weight ‏ : ‎ 3.17 pounds
  • Dimensions ‏ : ‎ 7.4 x 1.75 x 9 inches
  • Customer Reviews:
    4.5 4.5 out of 5 stars 446 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Wayne Winston

Wayne Winston

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read author blogs and more

Customer reviews

4.5 out of 5 stars
4.5 out of 5
446 global ratings
Torn in between the pages!
3 Stars
Torn in between the pages!
This is not a good copy that I received. The pages are falling off because the glue wasn't held tight enough. It's like I'm reading two books that I try putting together to one book by myself and it failed...It is a huge inconvenience reading the pages after this as it tries to flip its way back to close the book.Other than this, the pages are good although some edges of the book got wrecked during shipment but not bad at all. If it wasn't for this glue thing, I would have kept the book, but I'm returning it and getting a new one.
Hide
Thank you for your feedback
Sorry, there was an error
Sorry we couldn't load the review

Top reviews from the United States

Eric Hess
5.0 out of 5 stars Overall great but competing with free is hard
Reviewed in the United States on December 10, 2019
Verified Purchase
Practical hands on exercises with data that works excellently. Only problem is there are online resources that are free these days in YouTube that perform better for the more basic concepts but may not meet the thoroughness for complex problems as seen in this book. Try the YouTube channel "Excelisfun" if interested.
4 people found this helpful
Helpful
 Report
Ken More
5.0 out of 5 stars VBA is a versatile and user friendly language
Reviewed in the United States on December 10, 2018
Verified Purchase
VBA support in Excel should not be trashed by Microsoft and replaced by another language.
Small businesses using Excel VBA for Business Modeling can be put out of business if Excel VBA does not continue to be supported in all subsequent versions / releases of MS Office. Please do not allow the "Quick Change Artists" to violate the "Rules of Change Control" like they did between Office 2007 and Office 2010 when USERS of Excel VBA Business Modeling Software Products could not USE their Excel VBA Models if they upgraded from Excel 2003 to the latest Office versions / releases.
Helpful
 Report
Giorgi
5.0 out of 5 stars Good
Reviewed in the United States on July 30, 2023
Verified Purchase
Good
Helpful
 Report
The Real Bob
4.0 out of 5 stars A Very Good Reference
Reviewed in the United States on May 26, 2017
Verified Purchase
If you are interested in learning how to model with Excel then this is a very good reference. Covers a lot of ground from the basic Excel functions used to create pretty robust models. A step by step approach and examples online, the reader who is willing to invest time should get a lot of benefit from the work.
10 people found this helpful
Helpful
 Report
BestCoast
5.0 out of 5 stars Must buy for analysis!
Reviewed in the United States on September 27, 2020
Verified Purchase
Extremely useful! Wish I’d found it while suffering the grad school! My company can’t afford expensive data /statistical analysis programs so if you’re already fácil with Excel, this can give you the power needed without cost or completely learning a new program!
Helpful
 Report
Paul Hicks
3.0 out of 5 stars Great book with flaws
Reviewed in the United States on November 1, 2017
Verified Purchase
The content is great, you're going to learn a lot from this book. The book is huge which isn't a problem, but something you should note if you're deciding between the print and kindle versions. My main issues are with the format of the book and example problems.

First, I find it strange that they don't include a short chapter at the beginning about shortcuts. They probably did this because they didn't want to include both Windows and Mac shortcuts.

My recommendation to the author: Include a tear-out shortcut page in the beginning of the book for readers to reference.

Second, the example workbooks are inconsistent. All examples include a workbook with the solutions filled in, but only some examples offer a blank workbook for you to fill in yourself. In the cases where there is only the solved workbook available, it is easy enough to clear the cells yourself, but it spoils the fun a bit.

However, the main issue is that every example is in a separate workbook. Including a separate workbook for both the solutions and the blank workbooks. When you have 6+ examples per chapter, you have to open a minimum of 11 workbooks per chapter for 89 chapters which seems excessive. If you have the "Enable Editing" prompt enabled within Office, you will have to enable editing on each workbook individually which can be a pain.

My recommendation to the author: 1 workbook per chapter. Include separate sheets for each example and solution.

My recommendation to readers: Disable the "Enable Editing" prompt

Finally, there are some sloppy errors in the wording of some of the examples. For example, in one of the chapters they are talking about doing a 10 year forecast, but halfway through the example they switch from years to months. It's not that big of a deal, but it's this inattention to detail that makes you question the author's credibility.

My recommendation to John Pierce: As the editor, you should probably be more attentive if the author is going to name-drop you in the acknowledgments.

Even with these problems, I still have no problem recommending this book. If the author fixes these issues, I will gladly give this book 5/5. As it is now, this is a 3 star book.
30 people found this helpful
Helpful
 Report
Mai
5.0 out of 5 stars Fantastic, in - depth
Reviewed in the United States on June 13, 2017
Verified Purchase
Fantastic book! I was, by no means, an excel expert. This book is well structured to where anybody can understand. I love the example and template files to help you understand the processes. Then at the end of each chapter, there are questions that require you to create spreadsheets on your own. These last few questions do a terrific job reinforcing the chapter and making sure you truly understand the concepts and where to use them, rather than just understanding simple procedures.
This book is quite extensive and I'd recommend it if you wish to be successful in business analysis and modeling. The book covers v-lookups, if statements, sorting, conditional formatting, tables, solver, pivot tables, and about 75 other chapters.
Highly recommended.
22 people found this helpful
Helpful
 Report
Amazon Customer
5.0 out of 5 stars Perfect
Reviewed in the United States on April 5, 2022
Verified Purchase
This book is older and maybe that’s why the low price. Excel is such a great program and I love learning more about it. It is 2016 and windows 11 is just around the corner.
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Biswaprakash Ananda
5.0 out of 5 stars Book content
Reviewed in India on January 5, 2024
Verified Purchase
Excellent content to understand
Report
Data Analysis
5.0 out of 5 stars Five Stars
Reviewed in Canada on August 27, 2017
Verified Purchase
Thank you Zmazon.ca....!
Report
Amazon Customer
5.0 out of 5 stars Contenido actualizado y práctico.
Reviewed in Mexico on November 22, 2017
Verified Purchase
Cada vez que actualizan la paquetería de MS agregan funcionalidades a sus programas y Excel no se queda atrás. Este libro es el más completo que encontré y no me defraudó. Lo recomiendo ampliamente.
3 people found this helpful
 Report
Student
5.0 out of 5 stars This is a great book. It is a bit more advanced
Reviewed in the United Kingdom on December 4, 2017
Verified Purchase
This is a great book. It is a bit more advanced, but the techniques in this book are the same that the largest companies in the world use. This isn't a book that says, this is what a VLOOKUP does. This is a book that answers questions like, how can a company maximize profit by minimizing costs and with limited resources (labour and resources).
3 people found this helpful
 Report
Cliente Amazon
4.0 out of 5 stars Opinion e-book
Reviewed in Spain on August 29, 2017
Verified Purchase
Es la primera vez que leo un e-book y la verdad es que me resulta de mucha utilidad. El contenido del libro es muy bueno. El manejo a través del índice y la opción buscar por tema o capítulo es rápido
One person found this helpful
 Report