Table of Contents

		Microsoft Office Excel 2007: Data Analysis and Business Modeling byWayne L. Winston Microsoft Press 2007 (624 pages) ISBN:9780735623965 Using real-world examples and learn-by-doing exercises, this book will help you master the techniques that business analysts at leading companies use to transform data into bottom-line results.

Table of Contents
	Microsoft Office Excel 2007-Data Analysis and Business Modeling
	Preface
	Introduction to Excel 2007-What’s New?
	Chapter 1	-	Range Names
	Chapter 2	-	Lookup Functions
	Chapter 3	-	The INDEX Function
	Chapter 4	-	The MATCH Function
	Chapter 5	-	Text Functions
	Chapter 6	-	Dates and Date Functions
	Chapter 7	-	Evaluating Investments by Using Net Present Value Criteria
	Chapter 8	-	Internal Rate of Return
	Chapter 9	-	More Excel Financial Functions
	Chapter 10	-	Circular References
	Chapter 11	-	IF Statements
	Chapter 12	-	Time and Time Functions
	Chapter 13	-	The Paste Special Command
	Chapter 14	-	The Auditing Tool
	Chapter 15	-	Sensitivity Analysis with Data Tables
	Chapter 16	-	The Goal Seek Command
	Chapter 17	-	Using the Scenario Manager for Sensitivity Analysis
	Chapter 18	-	The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions
	Chapter 19	-	The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions
	Chapter 20	-	The OFFSET Function
	Chapter 21	-	The INDIRECT Function
	Chapter 22	-	Conditional Formatting
	Chapter 23	-	Sorting in Excel
	Chapter 24	-	Tables
	Chapter 25	-	Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes
	Chapter 26	-	An Introduction to Optimization with Excel Solver
	Chapter 27	-	Using Solver to Determine the Optimal Product Mix
	Chapter 28	-	Using Solver to Schedule Your Workforce
	Chapter 29	-	Using Solver to Solve Transportation or Distribution Problems
	Chapter 30	-	Using Solver for Capital Budgeting
	Chapter 31	-	Using Solver for Financial Planning
	Chapter 32	-	Using Solver to Rate Sports Teams
	Chapter 33	-	Importing Data from a Text File or Document
	Chapter 34	-	Importing Data from the Internet
	Chapter 35	-	Validating Data
	Chapter 36	-	Summarizing Data by Using Histograms
	Chapter 37	-	Summarizing Data by Using Descriptive Statistics
	Chapter 38	-	Using PivotTables to Describe Data
	Chapter 39	-	Summarizing Data with Database Statistical Functions
	Chapter 40	-	Filtering Data and Removing Duplicates
	Chapter 41	-	Consolidating Data
	Chapter 42	-	Creating Subtotals
	Chapter 43	-	Estimating Straight Line Relationships
	Chapter 44	-	Modeling Exponential Growth
	Chapter 45	-	The Power Curve
	Chapter 46	-	Using Correlations to Summarize Relationships
	Chapter 47	-	Introduction to Multiple Regression
	Chapter 48	-	Incorporating Qualitative Factors into Multiple Regression
	Chapter 49	-	Modeling Nonlinearities and Interactions
	Chapter 50	-	Analysis of Variance: One-Way ANOVA
	Chapter 51	-	Randomized Blocks and Two-Way ANOVA
	Chapter 52	-	Using Moving Averages to Understand Time Series
	Chapter 53	-	Winter ’s Method
	Chapter 54	-	Forecasting in the Presence of Special Events
	Chapter 55	-	An Introduction to Random Variables
	Chapter 56	-	The Binomial, Hypergeometric, and Negative Binomial Random Variables
	Chapter 57	-	The Poisson and Exponential Random Variable
	Chapter 58	-	The Normal Random Variable
	Chapter 59	-	Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project
	Chapter 60	-	Introduction to Monte Carlo Simulation
	Chapter 61	-	Calculating an Optimal Bid
	Chapter 62	-	Simulating Stock Prices and Asset Allocation Modeling
	Chapter 63	-	Fun and Games: Simulating Gambling and Sporting Event Probabilities
	Chapter 64	-	Using Resampling to Analyze Data
	Chapter 65	-	Pricing Stock Options
	Chapter 66	-	Determining Customer Value
	Chapter 67	-	The Economic Order Quantity Inventory Model
	Chapter 68	-	Inventory Modeling with Uncertain Demand
	Chapter 69	-	Queuing Theory-The Mathematics of Waiting in Line
	Chapter 70	-	Estimating a Demand Curve
	Chapter 71	-	Pricing Products by Using Tie-Ins
	Chapter 72	-	Pricing Products by Using Subjectively Determined Demand
	Chapter 73	-	Nonlinear Pricing
	Chapter 74	-	Array Formulas and Functions
	Index
	List of Figures
	List of Tables