Beginning Excel what-if data analysis tools : getting started with Goal Seek, data tables, scenarios and Solver / Paul Cornell.

Format:

Book

Author/Creator:

Cornell, Paul, 1968-

Language:

English

Subjects (All):

Business--Computer programs.

Business.

Electronic spreadsheets.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (182 p.)

Edition:

1st ed. 2006.

Other Title:

Beginning Excel what-if data analysis

Place of Publication:

Berkeley, CA : Apress ; New York, NY : Distributed to the book trade worldwide by Springer-Verlag New York, c2006.

Language Note:

English

Summary:

Excels what-if data analysis tools let you experiment with your data to project future results. In turn, these predictions will lead to better decision making and unlock the mystery of many business analysis scenarios. For example, what-if data analysis tools will enable you to forecast how lowering the price per unitwhile increasing projected unit salesmight affect your profit margins. Beginning Excel What-If Data Analysis Tools explores the use of Goal Seek, Data Tables, Scenarios, and Solver to help you get insight on your data. This book is focused and to the point, and it provides tutorial treatment of what-if tools in a practical, hands-on manner.

Contents:

From the contents: Goal Seek. What Is Goal Seek? When Would I Use Goal Seek? Preparing Worksheets for Goal Seek. Using Formulas with Goal Seek. Using the Goal Seek Dialog Box

Data Tables

What Are Data Tables? When Would I Use Data Tables? Data Tables Terminology. One-Variable Data Table. Two-variable Data Table. Input Values Result Values

Working with One-Variable Data Tables. Working with Two-Variable Data Tables

Using Formulas with Data Tables. Adjusting Data Table Calculation Options

Scenarios. What Are Scenarios? When Would I Use Scenarios? Using the Scenario Manager Dialog Box

Solver. What Is Solver? When Would I Use Solver? Solver Terminology Decision variables. Constraints. Objective. Optimization. Adjustable Cells. Constrained Cell Target Cell. Preparing Worksheets for Solver. Using the Solver Parameters Dialog Box. Using the Add Constraint Dialog Box. Using the Solver Options Dialog Box. Working with Solver Constraints. Working with Solver Reports. Working with Solver Models. Working with Scenarios in Solver. Working with Solver Trial Solutions. Experimenting with the Default Solver Samples

Case Study: Using What-If Data Analysis Tools at the Ridge Running Cooperative

About the Cooperative. Using Goal Seek to Forecast Membership Dues. Using One-Variable and Two-Variable Data Tables to Organize Fun Runs. Using Scenarios to Forecast Race Day Cash Flow. Using Solver to Predict Race Day Finish Times. Using Solver to Pair Up Race Relay Teams.

Notes:

Description based upon print version of record.

Includes bibliographical references (p. 155) and index.

ISBN:

1-280-65714-6

9786610657148

1-4302-0098-7

OCLC:

262691705