Microsoft Excel 2010: Data Analysis and Business Modeling

( 1 )

Overview

Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of his expertise in this hands-on, ...

See more details below
Paperback (Third Edition)
$30.95
BN.com price
(Save 38%)$49.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (46) from $20.00   
  • New (18) from $26.68   
  • Used (28) from $19.99   
Microsoft Excel 2010: Data Analysis and Business Modeling

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.99 List Price

Overview

Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of his expertise in this hands-on, scenario-focused guide—fully updated for Excel 2010!

Use Excel to solve real business problems—and sharpen your edge!

  • Model investment risks and returns
  • Analyze your sales team’s effectiveness
  • Create best, worst, and most-likely case scenarios
  • Compare lease vs. buy, and calculate loan terms
  • See how price, advertising, and seasonality affect sales
  • Manage inventory with precision
  • Quantify the value of customer loyalty
  • Calculate your break-even number and ROI
  • Maximize scheduling efficiency
  • Express “home-field advantage” in real numbers
  • Project company growth, predict election results, and more!
  • Plus—introduce yourself to PowerPivot for Excel
Your companion web content includes:
  • Downloadable eBook
  • Hundreds of scenario-based practice problems
  • All the book’s sample files—plus customizable templates
Read More Show Less

Product Details

  • ISBN-13: 9780735643369
  • Publisher: Microsoft Press
  • Publication date: 1/14/2011
  • Edition description: Third Edition
  • Edition number: 3
  • Pages: 720
  • Sales rank: 100,964
  • Product dimensions: 7.30 (w) x 8.90 (h) x 1.90 (d)

Meet 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.

Read More Show Less

Table of Contents

Introduction; What You Should Know Before Reading This Book; How to Use This Book; Using the Companion Content; How to Access Your Online Edition Hosted by Safari; How to Download the Online Edition to Your Computer; Errata and Book Support; We Want to Hear from You; Stay in Touch; Acknowledgments; Chapter 1: What’s New in Excel 2010; 1.1 Customizable Ribbon; 1.2 Sparklines; 1.3 Slicers; 1.4 PowerPivot; 1.5 New Excel Solver; 1.6 File Tab; 1.7 New Excel Functions; 1.8 New Equation Editor; 1.9 Improved Data Bars; 1.10 Paste Special Live Preview; Chapter 2: Range Names; 2.1 How Can I Create Named Ranges?; 2.2 Answers to This Chapter’s Questions; 2.3 Problems; Chapter 3: Lookup Functions; 3.1 Syntax of the Lookup Functions; 3.2 Answers to This Chapter’s Questions; 3.3 Problems; Chapter 4: The INDEX Function; 4.1 Syntax of the INDEX Function; 4.2 Answers to This Chapter’s Questions; 4.3 Problems; Chapter 5: The MATCH Function; 5.1 Answers to This Chapter’s Questions; 5.2 Problems; Chapter 6: Text Functions; 6.1 Text Function Syntax; 6.2 Answers to This Chapter’s Questions; 6.3 Problems; Chapter 7: Dates and Date Functions; 7.1 Answers to This Chapter’s Questions; 7.2 Problems; Chapter 8: Evaluating Investments by Using Net Present Value Criteria; 8.1 Answers to This Chapter’s Questions; 8.2 Problems; Chapter 9: Internal Rate of Return; 9.1 Answers to This Chapter’s Questions; 9.2 Problems; Chapter 10: More Excel Financial Functions; 10.1 Answers to This Chapter’s Questions; 10.2 Problems; Chapter 11: Circular References; 11.1 Answers to This Chapter’s Questions; 11.2 Problems; Chapter 12: IF Statements; 12.1 Answers to This Chapter’s Questions; 12.2 Problems; Chapter 13: Time and Time Functions; 13.1 Answers to This Chapter’s Questions; 13.2 Problems; Chapter 14: The Paste Special Command; 14.1 Answers to This Chapter’s Questions; 14.2 Problems; Chapter 15: Three-Dimensional Formulas; 15.1 Answers to This Chapter’s Questions; Chapter 16: The Auditing Tool; 16.1 Answers to This Chapter’s Questions; 16.2 Problems; Chapter 17: Sensitivity Analysis with Data Tables; 17.1 Answers to This Chapter’s Questions; 17.2 Problems; Chapter 18: The Goal Seek Command; 18.1 Answers to This Chapter’s Questions; 18.2 Problems; Chapter 19: Using the Scenario Manager for Sensitivity Analysis; 19.1 Answer to This Chapter’s Question; 19.2 Problems; Chapter 20: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions; 20.1 Answers to This Chapter’s Questions; 20.2 Problems; Chapter 21: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions; 21.1 Answers to This Chapter’s Questions; 21.2 Problems; Chapter 22: The OFFSET Function; 22.1 Answers to This Chapter’s Questions; 22.2 Problems; Chapter 23: The INDIRECT Function; 23.1 Answers to This Chapter’s Questions; 23.2 Problems; Chapter 24: Conditional Formatting; 24.1 Answers to This Chapter’s Questions; 24.2 Problems; Chapter 25: Sorting in Excel; 25.1 Answers to This Chapter’s Questions; 25.2 Problems; Chapter 26: Tables; 26.1 Answers to This Chapter’s Questions; 26.2 Problems; Chapter 27: Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes; 27.1 Answers to This Chapter’s Questions; 27.2 Problems; Chapter 28: An Introduction to Optimization with Excel Solver; 28.1 Problems; Chapter 29: Using Solver to Determine the Optimal Product Mix; 29.1 Answers to This Chapter’s Questions; 29.2 Problems; Chapter 30: Using Solver to Schedule Your Workforce; 30.1 Answers to This Chapter’s Question; 30.2 Problems; Chapter 31: Using Solver to Solve Transportation or Distribution Problems; 31.1 Answer to This Chapter’s Question; 31.2 Problems; Chapter 32: Using Solver for Capital Budgeting; 32.1 Answer to This Chapter’s Question; 32.2 Problems; Chapter 33: Using Solver for Financial Planning; 33.1 Answers to This Chapter’s Questions; 33.2 Problems; Chapter 34: Using Solver to Rate Sports Teams; 34.1 Answer to This Chapter’s Question; 34.2 Problems; Chapter 35: Warehouse Location and the GRG Multistart and Evolutionary Solver Engines; 35.1 Understanding the GRG Multistart and Evolutionary Solver Engines; 35.2 Answer to This Chapter’s Questions; 35.3 Problems; Chapter 36: Penalties and the Evolutionary Solver; 36.1 Answers to This Chapter’s Questions; 36.2 Problems; Chapter 37: The Traveling Salesperson Problem; 37.1 Answers to This Chapter’s Questions; 37.2 Problems; Chapter 38: Importing Data from a Text File or Document; 38.1 Answers to This Chapter’s Question; 38.2 Problems; Chapter 39: Importing Data from the Internet; 39.1 Answers to This Chapter’s Questions; 39.2 Problems; Chapter 40: Validating Data; 40.1 Answers to This Chapter’s Questions; 40.2 Problems; Chapter 41: Summarizing Data by Using Histograms; 41.1 Answers to This Chapter’s Questions; 41.2 Prooooooblems; Chapter 42: Summarizing Data by Using Descriptive Statistics; 42.1 Answers to This Chapter’s Questions; 42.2 Problems; Chapter 43: Using PivotTables and Slicers to Describe Data; 43.1 Answers to This Chapter’s Questions; 43.2 Problems; Chapter 44: Sparklines; 44.1 Answers to This Chapter’s Questions; 44.2 Problems; Chapter 45: Summarizing Data with Database Statistical Functions; 45.1 Answers to This Chapter’s Questions; 45.2 Problems; Chapter 46: Filtering Data and Removing Duplicates; 46.1 Answers to This Chapter’s Questions; 46.2 Problems; Chapter 47: Consolidating Data; 47.1 Answer to This Chapter’s Question; 47.2 Problems; Chapter 48: Creating Subtotals; 48.1 Answers to This Chapter’s Questions; 48.2 Problems; Chapter 49: Estimating Straight Line Relationships; 49.1 Answers to This Chapter’s Questions; 49.2 Problems; Chapter 50: Modeling Exponential Growth; 50.1 Answers to This Chapter’s Question; 50.2 Problems; Chapter 51: The Power Curve; 51.1 Answer to This Chapter’s Question; 51.2 Problems; Chapter 52: Using Correlations to Summarize Relationships; 52.1 Answer to This Chapter’s Question; 52.2 Problems; Chapter 53: Introduction to Multiple Regression; 53.1 Answers to This Chapter’s Questions; Chapter 54: Incorporating Qualitative Factors into Multiple Regression; 54.1 Answers to This Chapter’s Questions; Chapter 55: Modeling Nonlinearities and Interactions; 55.1 Answers to This Chapter’s Questions; 55.2 Problems for Through; Chapter 56: Analysis of Variance: One-Way ANOVA; 56.1 Answers to This Chapter’s Questions; 56.2 Problems; Chapter 57: Randomized Blocks and Two-Way ANOVA; 57.1 Answers to This Chapter’s Questions; 57.2 Problems; Chapter 58: Using Moving Averages to Understand Time Series; 58.1 Answers to This Chapter’s Question; 58.2 Problem; Chapter 59: Winters’s Method; 59.1 Time Series Characteristics; 59.2 Parameter Definitions; 59.3 Initializing Winters’s Method; 59.4 Estimating the Smoothing Constants; 59.5 Remarks; 59.6 Problems; Chapter 60: Ratio-to-Moving-Average Forecast Method; 60.1 Answers to This Chapter’s Questions; 60.2 Problem; Chapter 61: Forecasting in the Presence of Special Events; 61.1 Answers to This Chapter’s Questions; 61.2 Problems; Chapter 62: An Introduction to Random Variables; 62.1 Answers to This Chapter’s Questions; 62.2 Problems; Chapter 63: The Binomial, Hypergeometric, and Negative Binomial Random Variables; 63.1 Answers to This Chapter’s Questions; 63.2 Problems; Chapter 64: The Poisson and Exponential Random Variable; 64.1 Answers to This Chapter’s Questions; 64.2 Problems; Chapter 65: The Normal Random Variable; 65.1 Answers to This Chapter’s Questions; 65.2 Problems; Chapter 66: Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project; 66.1 Answers to This Chapter’s Questions; 66.2 Problems; Chapter 67: Making Probability Statements from Forecasts; 67.1 Answers to This Chapter’s Questions; 67.2 Problems; Chapter 68: Using the Lognormal Random Variable to Model Stock Prices; 68.1 Answers to This Chapter’s Questions; 68.2 Problems; Chapter 69: Introduction to Monte Carlo Simulation; 69.1 Answers to This Chapter’s Questions; 69.2 Problems; Chapter 70: Calculating an Optimal Bid; 70.1 Answers to This Chapter’s Questions; 70.2 Problems; Chapter 71: Simulating Stock Prices and Asset Allocation Modeling; 71.1 Answers to This Chapter’s Questions; 71.2 Problems; Chapter 72: Fun and Games: Simulating Gambling and Sporting Event Probabilities; 72.1 Answers to This Chapter’s Questions; 72.2 Problems; Chapter 73: Using Resampling to Analyze Data; 73.1 Answer to This Chapter’s Question; 73.2 Problems; Chapter 74: Pricing Stock Options; 74.1 Answers to This Chapter’s Questions; 74.2 Problems; Chapter 75: Determining Customer Value; 75.1 Answers to This Chapter’s Questions; 75.2 Problems; Chapter 76: The Economic Order Quantity Inventory Model; 76.1 Answers to This Chapter’s Questions; 76.2 Problems; Chapter 77: Inventory Modeling with Uncertain Demand; 77.1 Answers to This Chapter’s Questions; 77.2 Problems; Chapter 78: Queuing Theory: The Mathematics of Waiting in Line; 78.1 Answers to This Chapter’s Questions; 78.2 Problems; Chapter 79: Estimating a Demand Curve; 79.1 Answers to This Chapter’s Questions; 79.2 Problems; Chapter 80: Pricing Products by Using Tie-Ins; 80.1 Answer to This Chapter’s Question; 80.2 Problems; Chapter 81: Pricing Products by Using Subjectively Determined Demand; 81.1 Answer to This Chapter’s Questions; 81.2 Problems; Chapter 82: Nonlinear Pricing; 82.1 Answers to This Chapter’s Questions; 82.2 Problems; Chapter 83: Array Formulas and Functions; 83.1 Answers to This Chapter’s Questions; 83.2 Problems; Chapter 84: PowerPivot; 84.1 Answers to This Chapter’s Questions; About the Author;

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted March 29, 2011

    Awful on Nook

    Illustrations of computer screens are impossible to read. The book is too large for reasonable access on the Nook. Nook drops back to opening screen while trying to read the book. Reference materials such as this are poor candidates for the Nook. I ordered it for the Nook by mistake and B&N wouldn't let me cancel the order. I had to buy a second copy to get the hard-copy book. I can't comment on the contents of the book until I get the hard-copy.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Posted May 25, 2012

    I thought this book was fantastic! It shows you exactly how to d

    I thought this book was fantastic! It shows you exactly how to do about a 100 different business/stock market/probability models you can do in Excel. This book is for beginners. However, if you have NO working knowledge of excel I recommend learning up at least a little bit before buying this book. Go on youtube for some of the basics then you can have a crack at this!

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)