Table of Contents


microsoft office excel 2007: data analysis and business modeling
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



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

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net