Winston, Wayne L

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 ROICreate best, worst, and most-likely case scenarios for salesAnalyze investment performance and help minimize riskTrack your personal finances, calculate loan terms, and plan for retirementUse trend and seasonality to forecast revenueEstimate a product’s demand curve and manage inventory with precision Interpret the effects of price and advertising on salesAssign a dollar value to customer loyaltySolve work scheduling problems and shorten wait times for customer service queuesPLUS—predict outcomes of sporting events, presidential elections, and more!CD Includes:Sample files from each chapterProblem-and-solution sets—build your expertise!Fully searchable eBookA Note Regarding the CD or DVDThe 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.English.

PublishedRedmond: Microsoft Press, 2007

Available at all branches.

## This item is not reservable because:

- There are no reservable copies for this title. Please contact a member of library staff for further information.

### Electronic Resource –One available in 005.54

Barcode Shelfmark Loan type Status EB209 005.54 eBook Available

## Details

Statement of responsibility: Wayne L. Winston

ISBN: 0735623961, 0735643105, 9780735623965, 9780735643109

Note: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! Fully searchable eBook.

Note:CLICK ON GREEN BUTTON TO CONNECT TO ELECTRONIC BOOK.

Physical Description:624 p.

Subject:Microsoft Excel.; Computers and IT.

## Contents

- Preface
- What You Should Know Before Reading this Book
- How to Use this Book
- Using the Companion CD
- Support Information
- Acknowledgments
- Introduction to Excel 2007: WhatÔÇÖs New?
- Range Names
- 1.1 How Can I Create Named Ranges?
- 1.2 Remarks
- 1.3 Problems
- Lookup Functions
- 2.1 Syntax of the Lookup Functions
- 2.2 Problems
- The INDEX Function
- 3.1 Syntax of the INDEX Function
- 3.2 Problems
- The MATCH Function
- 4.1 Problems
- Text Functions
- 5.1 Text Function Syntax
- 5.2 Text Functions in Action
- 5.3 Extracting Data by Using the Text To Columns Wizard
- 5.4 Problems
- Dates and Date Functions
- 6.1 Problems
- Evaluating Investments by Using Net Present Value Criteria
- 7.1 Problems
- Internal Rate of Return
- 8.1 Problems
- More Excel Financial Functions
- 9.1 CUMPRINC and CUMIPMT Functions
- 9.2 Problems
- Circular References
- 10.1 Problems
- IF Statements
- 11.1 Problems
- Time and Time Functions
- 12.1 Problems
- The Paste Special Command
- 13.1 Problems
- The Auditing Tool
- 14.1 Problems
- Sensitivity Analysis with Data Tables
- 15.1 Problems
- The Goal Seek Command
- 16.1 Problems
- Using the Scenario Manager for Sensitivity Analysis
- 17.1 Remarks
- 17.2 Problems
- The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions
- 18.1 Remarks
- 18.2 Problems
- The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions
- 19.1 Problems
- The OFFSET Function
- 20.1 Remark
- 20.2 Problems
- The INDIRECT Function
- 21.1 Problems
- Conditional Formatting
- 22.1 Problems
- Sorting in Excel
- 23.1 Problems
- Tables
- 24.1 Problems
- Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes
- 25.1 Spin Buttons and Scroll Bars
- 25.2 Problems
- An Introduction to Optimization with Excel Solver
- 26.1 Problems
- Using Solver to Determine the Optimal Product Mix
- 27.1 Problems
- Using Solver to Schedule Your Workforce
- 28.1 Problems
- Using Solver to Solve Transportation or Distribution Problems
- 29.1 Problems
- Using Solver for Capital Budgeting
- 30.1 Handling Other Constraints
- 30.2 Problems
- Using Solver for Financial Planning
- 31.1 Problems
- Using Solver to Rate Sports Teams
- 32.1 Problems
- Importing Data from a Text File or Document
- 33.1 Problems
- Importing Data from the Internet
- 34.1 Problems
- Validating Data
- 35.1 Remarks
- 35.2 Problems
- Summarizing Data by Using Histograms
- 36.1 Problems
- Summarizing Data by Using Descriptive Statistics
- 37.1 Mean
- 37.2 Median
- 37.3 Mode
- 37.4 Kurtosis
- 37.5 Sample variance and sample standard deviation
- 37.6 Range
- 37.7 Problems
- Using PivotTables to Describe Data
- 38.1 Remarks About Grouping
- 38.2 Problems
- Summarizing Data with Database Statistical Functions
- 39.1 Problems
- Filtering Data and Removing Duplicates
- 40.1 Problems
- Consolidating Data
- 41.1 Problems
- Creating Subtotals
- 42.1 Problems
- Estimating Straight Line Relationships
- 43.1 Problems
- Modeling Exponential Growth
- 44.1 Problems
- The Power Curve
- 45.1 Problems
- Using Correlations to Summarize Relationships
- 46.1 Filling in the correlation matrix
- 46.2 Using the CORREL function
- 46.3 Relationship between correlation and R2
- 46.4 Correlation and regression towards the mean
- 46.5 Problems
- Introduction to Multiple Regression
- 47.1 What is the best prediction equation?
- Incorporating Qualitative Factors into Multiple Regression
- Modeling Nonlinearities and Interactions
- 49.1 Problems for Chapters 47 Through 49
- Analysis of Variance: One-Way ANOVA
- 50.1 Problems
- Randomized Blocks and Two-Way ANOVA
- 51.1 Problems
- Using Moving Averages to Understand Time Series
- 52.1 Problem
- WinterÔÇÖs Method
- 53.1 Time Series Characteristics
- 53.2 Parameter Definitions
- 53.3 Initializing WinterÔÇÖs Method
- 53.4 Estimating the Smoothing Constants
- 53.5 Remarks
- 53.6 Problems
- Forecasting in the Presence of Special Events
- 54.1 Problems
- An Introduction to Random Variables
- 55.1 Problems
- The Binomial, Hypergeometric, and Negative Binomial Random Variables
- 56.1 co*ke or Pepsi
- 56.2 Elevator Rails
- 56.3 Airline Overbooking
- 56.4 Problems
- The Poisson and Exponential Random Variable
- 57.1 Problems
- The Normal Random Variable
- 58.1 What fraction of people have an IQ of less than 90?
- 58.2 What fraction of all people have IQs from 95 through 120?
- 58.3 What fraction of all people have IQs of at least 130?
- 58.4 Problems
- Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project
- 59.1 What is the probability that a machine will last at least 20 hours?
- 59.2 What is the probability that a machine will last from 15 through 30 hours?
- 59.3 Problems
- Introduction to Monte Carlo Simulation
- 60.1 Problems
- Calculating an Optimal Bid
- 61.1 Problems
- Simulating Stock Prices and Asset Allocation Modeling
- 62.1 Problems
- Fun and Games: Simulating Gambling and Sporting Event Probabilities
- 63.1 Problems
- Using Resampling to Analyze Data
- 64.1 Problems
- Pricing Stock Options
- 65.1 Problems
- Determining Customer Value
- 66.1 Problems
- The Economic Order Quantity Inventory Model
- 67.1 Problems
- Inventory Modeling with Uncertain Demand
- 68.1 The back-order case
- 68.2 The lost-sales case
- 68.3 Problems
- Queuing Theory: The Mathematics of Waiting in Line
- 69.1 Problems
- Estimating a Demand Curve
- 70.1 Problems
- Pricing Products by Using Tie-Ins
- 71.1 Problems
- Pricing Products by Using Subjectively Determined Demand
- 72.1 Problems
- Nonlinear Pricing
- 73.1 Problems
- Array Formulas and Functions
- 74.1 How many units of makeup did Jen sell?
- 74.2 How many units of lipstick did Jen sell?
- 74.3 How many units were sold by Jen or were lipstick?
- 74.4 Can I summarize the number of units of each product sold by each salesperson?
- 74.5 Problems
- About the Author

## Author note

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.