Microsoft Press - Microsoft Office Excel 2007. Data Analysis and Business Modeling

MicrosoftВ® Office ExcelВ® 2007: Data Analysis and Business Modeling (Bpg -- Other)

ISBN: 0735623961
EAN: 2147483647

Year: 2007
Pages: 200

Authors: Wayne L. Winston

BUY ON AMAZON

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