Bask - Shop now
Buy new:
-44% $27.98
$3.99 delivery April 16 - 18
Ships from: 2BossyGirls
Sold by: 2BossyGirls
$27.98 with 44 percent savings
List Price: $49.99
$3.99 delivery April 16 - 18. Details
Only 1 left in stock - order soon.
$$27.98 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$27.98
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
2BossyGirls
2BossyGirls
Ships from
2BossyGirls
Returns
30-day refund/replacement
30-day refund/replacement
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt. You may receive a partial or no refund on used, damaged or materially different returns.
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
$11.33
Get Fast, Free Shipping with Amazon Prime FREE Returns
Used book in good and clean conditions. Pages and cover are intact. Limited notes marks and highlighting may be present. May show signs of normal shelf wear and bends on edges. Item may be missing CDs or access codes. Ships directly from Amazon. Used book in good and clean conditions. Pages and cover are intact. Limited notes marks and highlighting may be present. May show signs of normal shelf wear and bends on edges. Item may be missing CDs or access codes. Ships directly from Amazon. See less
FREE delivery April 28 - May 2 on orders shipped by Amazon over $35
Or fastest delivery April 27 - 29
$$27.98 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$27.98
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
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.6 out of 5 stars 454 ratings
{"desktop_buybox_group_1":[{"displayPrice":"$27.98","priceAmount":27.98,"currencySymbol":"$","integerValue":"27","decimalSeparator":".","fractionalValue":"98","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"QdYUA5pfF%2B5eF1GDt3mcP4zr015WpsZ0RE9AjSDo8cPbe5X%2B8WzNr3BvzKqBsl2%2BwhRS5qZ9s4222bvvGzwCbAdJj%2FrCmCzZ5%2FQTdPBN8ZW5VoeWU5Z9YVt6J3nhMt8ZgWhZ0ireKMNa3pt8h66r17icVqKyWSa6JOXv4DX9YrRQ4If%2FdDSfRBy%2FgtqklNe%2F","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$11.33","priceAmount":11.33,"currencySymbol":"$","integerValue":"11","decimalSeparator":".","fractionalValue":"33","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"QdYUA5pfF%2B5eF1GDt3mcP4zr015WpsZ0GGNljdSogXaDwfPtS2Xdm2wI%2FV1Ts1eIyCAOlALLAJ9HUwGb2urdO5vL74oYSV4%2Fo2K0wNnbZK7tsyt78V5g105hLtVUZfUZi8Gb9NUJdXTcU%2FVMahbVL6kdt%2Bksl3%2BuYYsxfP6LN%2BHhjVZT1s5M3DJoHB4G07Go","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 slide of product details
  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
Next slide of product details
Books%20with%20Buzz
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)
This item: Microsoft Excel Data Analysis and Business Modeling (Business Skills)
$27.98
Get it Apr 16 - 18
Only 1 left in stock - order soon.
Ships from and sold by 2BossyGirls.
+
Excel Formulas QuickStudy Laminated Study Guide (QuickStudy Computer)
$5.53
Get it as soon as Tuesday, Apr 15
In Stock
Ships from and sold by Amazon.com.
+
Excel 2016 Bible
$28.99
Get it as soon as Tuesday, Apr 15
Only 13 left in stock (more on the way).
Ships from and sold by Amazon.com.
Total price: $00
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 pounds
  • Dimensions ‏ : ‎ 7.4 x 1.75 x 9 inches
  • Customer Reviews:
    4.6 out of 5 stars 454 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 book recommendations and more.

Customer reviews

4.6 out of 5 stars
454 global ratings

Review this product

Share your thoughts with other customers
Write a customer review

Customers say

Customers find the book very useful for learning Excel, with one mentioning it covers advanced techniques. They appreciate its user-friendly approach, with one noting its step-by-step guidance, and find the content extensive. Customers also consider it a valuable investment for its great price.

AI-generated from the text of customer reviews

Select to learn more

27 customers mention "Use"27 positive0 negative

Customers find the book very useful for learning Excel and creating spreadsheets, with one customer noting its comprehensive coverage of advanced techniques.

"...extensive and I'd recommend it if you wish to be successful in business analysis and modeling...." Read more

"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...." Read more

"Practical hands on exercises with data that works excellently...." Read more

"...interested in learning how to model with Excel then this is a very good reference...." Read more

8 customers mention "User friendly"8 positive0 negative

Customers find the book user-friendly, with one mentioning its easy-to-follow examples and step-by-step approach.

"...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." Read more

"...It can help to set models using Excel and give schematic process." Read more

"Easy to follow examples." Read more

"simple to learn" Read more

4 customers mention "Value for money"4 positive0 negative

Customers find the book offers great value for money.

"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...." Read more

"This is the required textbook in my university, the price is fairly cheap compare to textbooks in other subjects which cost hundreds of dollars...." Read more

"...Definetly worth the money. I've used this book to create an diy erp for a small business!" Read more

"Great price. Very comprehensive." Read more

3 customers mention "Content depth"3 positive0 negative

Customers appreciate the content depth of the book, with one customer noting it covers a lot of ground.

"...This book is quite extensive and I'd recommend it if you wish to be successful in business analysis and modeling...." Read more

"...Covers a lot of ground from the basic Excel functions used to create pretty robust models...." Read more

"Comprehensive, clear, good reference. Enough." Read more

Torn in between the pages!
3 out of 5 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

  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Vek
    5.0 out of 5 stars I find that using this as a guide while practicing on excel is the best way to get the most value out of this ...
    Reviewed in the United States on October 11, 2017
    Verified Purchase
    I think I'll be using this book for a long time to come. I learned a lot of advanced excel techniques in a relatively short amount of time. I find that using this as a guide while practicing on excel is the best way to get the most value out of this book.
    One person found this helpful
    Helpful
     Report

Top reviews from other countries

Translate all reviews to English
  • 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.
    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).
    Report
  • 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
  • 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
    Report