25 Books to Read Before You Die
 
 

Recently Viewed clear list


Q&A | August 19, 2014

Richard Kadrey: IMG Powell’s Q&A: Richard Kadrey



Describe your latest book. The Getaway God is the sixth book in the Sandman Slim series. In it, the very unholy nephilim, James Stark, aka Sandman... Continue »
  1. $17.49 Sale Hardcover add to wish list

spacer
Qualifying orders ship free.
$25.00
List price: $49.99
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Burnside - Bldg. 2 Microsoft Windows- Applications

More copies of this ISBN

Microsoft Excel 2010: Data Analysis and Business Modeling

by

Microsoft Excel 2010: Data Analysis and Business Modeling Cover

 

Synopses & Reviews

Publisher Comments:

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 guidenow updated for Excel 2007. Use Waynes 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 profitsdetermine 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 products 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
  • PLUSpredict outcomes of sporting events, presidential elections, and more!

CD Includes:

  • Sample files from each chapter
  • Problem-and-solution setsbuild 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 booktech@oreilly.com.

Book News Annotation:

This comprehensive guide to advanced business modeling and analysis functions for Microsoft Excel 2010 provides classroom-style instruction for performing a variety of intermediate to complex business reporting tasks. The volume provides useful examples examining functions, advanced commands and tools and focuses on data presentation options such as histograms, PivotTables and database statistical functions. Numerous screen shots and example data are provided throughout and access to an online version of the text including additional resources is included. Winston is a professor of business at Indiana University. Annotation ©2011 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

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

Synopsis:

Customer Service Note: We are sorry for the inconvenience, but the voucher with the online access code is missing from the first printing of this title. However, we do have the code, available upon request. Please contact O'Reilly Media Customer Service at mspbooksupport@oreilly.com or call 800-889-8969 to obtain your 24-character access code. This code will give you access to your online edition of this Microsoft Press book that is hosted on Safari Books Online! Once you have obtained your unique access code: Go to http://microsoftpress.oreilly.com/​safarienabled and enter your unique 24-character access code, including the hyphens. Set up your free Safari account (required), following the instructions on-screen. Enjoy unlimited access to your online edition of the Web! PLEASE NOTE: Each access code may only be redeemed once. Again, for assistance, please contact O'Reilly Media Customer Service at mspbooksupport@oreilly.com or call 800-889-8969 or 707-827-7019.

Master the business modeling and analysis techniques that help you transform 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, scenario-focused guide—fully updated for Excel 2010. Use Waynes proven practices and hands-on examples to help you work smarter, make better decisions, and gain the competitive edge.

About the Author

Wayne L. Winston is a professor of Decision Sciences at Indiana Universitys Kelley School of Business and the recipient of more than 30 teaching awards. For the past 20 years, Wayne has also taught Fortune 500 companies how to use Excel to make smarter business decisions. He has written 15 books on Excel, management science, and mathematics in sports.

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

Product Details

ISBN:
9780735643369
Author:
Winston, Wayne L
Publisher:
Microsoft Press
Author:
Winston, Wayne L.
Author:
n, Wayne L.
Author:
Winsto
Author:
Winston, Wayne
Subject:
Spreadsheets - Excel
Subject:
Spreadsheets - General
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Excel;Office 2010;business model;data analysis;data sets;statistics
Copyright:
Edition Description:
Trade paper
Series:
Business Skills
Publication Date:
20110131
Binding:
TRADE PAPER
Language:
English
Pages:
720
Dimensions:
9.00 x 7.38 in

Other books you might like

  1. Excel 2007 Data Analysis for Dummies... Used Trade Paper $12.50

Related Subjects

Computers and Internet » Database » Design
Computers and Internet » Networking » General
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Computers and Internet » Software Engineering » Software Management

Microsoft Excel 2010: Data Analysis and Business Modeling Used Trade Paper
0 stars - 0 reviews
$25.00 In Stock
Product details 720 pages Microsoft Press - English 9780735643369 Reviews:
"Synopsis" by , 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

"Synopsis" by ,

Customer Service Note: We are sorry for the inconvenience, but the voucher with the online access code is missing from the first printing of this title. However, we do have the code, available upon request. Please contact O'Reilly Media Customer Service at mspbooksupport@oreilly.com or call 800-889-8969 to obtain your 24-character access code. This code will give you access to your online edition of this Microsoft Press book that is hosted on Safari Books Online! Once you have obtained your unique access code: Go to http://microsoftpress.oreilly.com/​safarienabled and enter your unique 24-character access code, including the hyphens. Set up your free Safari account (required), following the instructions on-screen. Enjoy unlimited access to your online edition of the Web! PLEASE NOTE: Each access code may only be redeemed once. Again, for assistance, please contact O'Reilly Media Customer Service at mspbooksupport@oreilly.com or call 800-889-8969 or 707-827-7019.

Master the business modeling and analysis techniques that help you transform 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, scenario-focused guide—fully updated for Excel 2010. Use Waynes proven practices and hands-on examples to help you work smarter, make better decisions, and gain the competitive edge.

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.