Author

Language

Pages

Size

Format

Category

# Microsoft Excel 2010 Data Analysis and Business Modeling by Wayne L. Winston

## Contents of Microsoft Excel 2010 Book

• Introduction
• What s New in Excel
• Range Names
• Lookup Functions
• The INDEX Function
• The MATCH Function
• Text Functions
• Dates and Date Functions
• Evaluating Investments by Using Net Present Value Criteria
• Internal Rate of Return
• More Excel Financial Functions
• Circular References
• IF Statements
• Time and Time Functions
• The Paste Special Command
• Three Dimensional Formulas
• The Auditing Tool
• Sensitivity Analysis with Data Tables
• The Goal Seek Command
• Using the Scenario Manager for Sensitivity Analysis
• The COUNTIF COUNTIFS COUNT COUNTA and COUNTBLANK Functions
• The SUMIF AVERAGEIF SUMIFS and AVERAGEIFS Functions
• The OFFSET Function
• The INDIRECT Function
• Conditional Formatting
• Sorting in Excel
• Tables
• Spin Buttons Scroll Bars Option Buttons Check Boxes Combo Boxes and Group List Boxes
• An Introduction to Optimization with Excel Solver
• Using Solver to Determine the Optimal Product Mix
• Using Solver to Schedule Your Workforce
• Using Solver to Solve Transportation or Distribution Problems
• Using Solver for Capital Budgeting
• Using Solver for Financial Planning
• Using Solver to Rate Sports Teams Warehouse Location and the GRG Multistart and
• Evolutionary Solver Engines
• Penalties and the Evolutionary Solver
• The Traveling Salesperson Problem
• Importing Data from a Text File or Document
• Importing Data from the Internet
• Validating Data
• Summarizing Data by Using Histograms
• Summarizing Data by Using Descriptive Statistics
• Using PivotTables and Slicers to Describe Data
• Sparklines
• Summarizing Data with Database Statistical Functions
• Filtering Data and Removing Duplicates
• Consolidating Data
• Creating Subtotals
• Estimating Straight Line Relationships
• Modeling Exponential Growth
• The Power Curve
• Using Correlations to Summarize Relationships
• Introduction to Multiple Regression
• Incorporating Qualitative Factors into Multiple Regression
• Modeling Nonlinearities and Interactions
• Analysis of Variance One Way ANOVA
• Randomized Blocks and Two Way ANOVA
• Using Moving Averages to Understand Time Series
• Winters s Method
• Ratio to Moving Average Forecast Method
• Forecasting in the Presence of Special Events
• An Introduction to Random Variables
• The Binomial Hypergeometric and Negative Binomial Random Variables
• The Poisson and Exponential Random Variable
• The Normal Random Variable
• Weibull and Beta Distributions Modeling Machine Life and Duration of a Project
• Making Probability Statements from Forecasts
• Using the Lognormal Random Variable to Model
• Stock Prices
• Introduction to Monte Carlo Simulation
• Calculating an Optimal Bid Simulating Stock Prices and Asset Allocation Modeling
• Fun and Games Simulating Gambling and Sporting
• Event Probabilities
• Using Resampling to Analyze Data
• Pricing Stock Options
• Determining Customer Value
• The Economic Order Quantity Inventory Model
• Inventory Modeling with Uncertain Demand
• Queuing Theory The Mathematics of Waiting in Line
• Estimating a Demand Curve
• Pricing Products by Using Tie Ins
• Pricing Products by Using Subjectively Determined Demand
• Nonlinear Pricing
• Array Formulas and Functions
• PowerPivot

Share PDF on your social media:

## Related Books

### Excel 2019 Power Programming with VBA

What's the problem with this file?