Paul Cornell

Beginning Excel What-If Data Analysis Tools (eBook, PDF)

Getting Started with Goal Seek, Data Tables, Scenarios, and Solver

• Format: PDF

Produktbeschreibung

* The only book on the market dedicated to the What-If functions and tools built into Excel, which are key to many business analysis scenarios.

* Focused and to the point - where other Excel books force the reader to wade through 100's of pages of related information and commit hours of reading, this book gets straight to the topic of teaching the reader about What-If scenario tools in Excel.

* Offers the deepest tutorial treatment of the Solver add-in, the Goal Seeker and the other What-If scenario analysis tools, in a practical, hands-on exercises approach to using Excel to get business results.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Apress
• Seitenzahl: 192
• Erscheinungstermin: 9. November 2006
• Englisch
• ISBN-13: 9781430200987
• Artikelnr.: 37347706

Autorenporträt

Paul Cornell works at Microsoft on the documentation team for Microsoft Visual Studio Tools for the Microsoft Office system. He worked as an editor, writer, and columnist on the MSDN Office Developer Center and edited the Microsoft Office Visual Basic Language Reference. Cornell also founded the Power User Corner, on Microsoft Office Online, where he was a frequent contributor.

Inhaltsangabe

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.