Microsoft® Excel® 2010: : Data Analysis and Business Modeling / Winston, Wayne.

Format:

Book

Author/Creator:

Winston, Wayne, author.

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Industrial management--Statistical methods--Computer programs.

Industrial management.

Decision making--Computer programs.

Decision making.

Physical Description:

1 online resource (720 pages)

Edition:

1st edition

Other Title:

Excel 2010 : data analysis and business modeling

Place of Publication:

Microsoft Press, 2011.

System Details:

text file

Summary:

Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of his expertise in this hands-on, scenario-focused guide—fully updated for Excel 2010! Use Excel to solve real business problems—and sharpen your edge! Model investment risks and returns Analyze your sales team’s effectiveness Create best, worst, and most-likely case scenarios Compare lease vs. buy, and calculate loan terms See how price, advertising, and seasonality affect sales Manage inventory with precision Quantify the value of customer loyalty Calculate your break-even number and ROI Maximize scheduling efficiency Express “home-field advantage” in real numbers Project company growth, predict election results, and more! Plus—introduce yourself to PowerPivot for Excel Your companion web content includes: Downloadable eBook Hundreds of scenario-based practice problems All the book’s sample files—plus customizable templates

Contents:

What's new in Excel 2010

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.

Notes:

Includes index.

Online resource; Title from title page (viewed January 7, 2011)

OCLC:

733752537