MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 200
Pages: 200
Authors: Wayne L. Winston
- Table of Contents
- Back Cover
- Microsoft Office Excel 2007-Data Analysis and Business Modeling
- 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-Whats New?
- Chapter 1: Range Names
- How Can I Create Named Ranges?
- Remarks
- Problems
- Chapter 2: Lookup Functions
- Problems
- Chapter 3: The INDEX Function
- Problems
- Chapter 4: The MATCH Function
- Problems
- Chapter 5: Text Functions
- Text Function Syntax
- Text Functions in Action
- Extracting Data by Using the Text To Columns Wizard
- Problems
- Chapter 6: Dates and Date Functions
- Problems
- Chapter 7: Evaluating Investments by Using Net Present Value Criteria
- Problems
- Chapter 8: Internal Rate of Return
- Problems
- Chapter 9: More Excel Financial Functions
- CUMPRINC and CUMIPMT Functions
- Problems
- Chapter 10: Circular References
- Problems
- Chapter 11: IF Statements
- Problems
- Chapter 12: Time and Time Functions
- Problems
- Chapter 13: The Paste Special Command
- Problems
- Chapter 14: The Auditing Tool
- Problems
- Chapter 15: Sensitivity Analysis with Data Tables
- Problems
- Chapter 16: The Goal Seek Command
- Problems
- Chapter 17: Using the Scenario Manager for Sensitivity Analysis
- Remarks
- Problems
- Chapter 18: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions
- Remarks
- Problems
- Chapter 19: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions
- Problems
- Chapter 20: The OFFSET Function
- Remark
- Problems
- Chapter 21: The INDIRECT Function
- Problems
- Chapter 22: Conditional Formatting
- Problems
- Chapter 23: Sorting in Excel
- Problems
- Chapter 24: Tables
- Problems
- Chapter 25: Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes
- Spin Buttons and Scroll Bars
- Problems
- Chapter 26: An Introduction to Optimization with Excel Solver
- Problems
- Chapter 27: Using Solver to Determine the Optimal Product Mix
- Problems
- Chapter 28: Using Solver to Schedule Your Workforce
- Problems
- Chapter 29: Using Solver to Solve Transportation or Distribution Problems
- Problems
- Chapter 30: Using Solver for Capital Budgeting
- Handling Other Constraints
- Problems
- Chapter 31: Using Solver for Financial Planning
- Problems
- Chapter 32: Using Solver to Rate Sports Teams
- Problems
- Chapter 33: Importing Data from a Text File or Document
- Problems
- Chapter 34: Importing Data from the Internet
- Problems
- Chapter 35: Validating Data
- Remarks
- Problems
- Chapter 36: Summarizing Data by Using Histograms
- Problems
- Chapter 37: Summarizing Data by Using Descriptive Statistics
- Problems
- Chapter 38: Using PivotTables to Describe Data
- Remarks About Grouping
- Problems
- Chapter 39: Summarizing Data with Database Statistical Functions
- Problems
- Chapter 40: Filtering Data and Removing Duplicates
- Problems
- Chapter 41: Consolidating Data
- Problems
- Chapter 42: Creating Subtotals
- Problems
- Chapter 43: Estimating Straight Line Relationships
- Problems
- Chapter 44: Modeling Exponential Growth
- Problems
- Chapter 45: The Power Curve
- Problems
- Chapter 46: Using Correlations to Summarize Relationships
- Problems
- Chapter 47: Introduction to Multiple Regression
- Chapter 48: Incorporating Qualitative Factors into Multiple Regression
- Chapter 49: Modeling Nonlinearities and Interactions
- Problems for Chapters 47 Through 49
- Chapter 50: Analysis of Variance: One-Way ANOVA
- Problems
- Chapter 51: Randomized Blocks and Two-Way ANOVA
- Problems
- Chapter 52: Using Moving Averages to Understand Time Series
- Problem
- Chapter 53: Winter s Method
- Parameter Definitions
- Initializing Winters Method
- Estimating the Smoothing Constants
- Remarks
- Problems
- Chapter 54: Forecasting in the Presence of Special Events
- Problems
- Chapter 55: An Introduction to Random Variables
- Problems
- Chapter 56: The Binomial, Hypergeometric, and Negative Binomial Random Variables
- Problems
- Chapter 57: The Poisson and Exponential Random Variable
- Problems
- Chapter 58: The Normal Random Variable
- Problems
- Chapter 59: Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project
- Problems
- Chapter 60: Introduction to Monte Carlo Simulation
- Problems
- Chapter 61: Calculating an Optimal Bid
- Problems
- Chapter 62: Simulating Stock Prices and Asset Allocation Modeling
- Problems
- Chapter 63: Fun and Games: Simulating Gambling and Sporting Event Probabilities
- Problems
- Chapter 64: Using Resampling to Analyze Data
- Problems
- Chapter 65: Pricing Stock Options
- Problems
- Chapter 66: Determining Customer Value
- Problems
- Chapter 67: The Economic Order Quantity Inventory Model
- Problems
- Chapter 68: Inventory Modeling with Uncertain Demand
- Problems
- Chapter 69: Queuing Theory-The Mathematics of Waiting in Line
- Problems
- Chapter 70: Estimating a Demand Curve
- Problems
- Chapter 71: Pricing Products by Using Tie-Ins
- Problems
- Chapter 72: Pricing Products by Using Subjectively Determined Demand
- Problems
- Chapter 73: Nonlinear Pricing
- Problems
- Chapter 74: Array Formulas and Functions
- Problems
- Index
- B
- C
- D
- E
- F
- G
- H
- I
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- List of Figures
- List of Tables
MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)
ISBN: 0735623961
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 200
Pages: 200
Authors: Wayne L. Winston