Skip to main content
SpringerLink
Log in
Apress
Book cover

Beginning Excel What-If Data Analysis Tools

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

  • Book
  • © 2006

Overview

Authors:
  1. Paul Cornell
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • 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

  • 8232 Accesses

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 34.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 44.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (5 chapters)

  1. Front Matter

    Pages i-xxii
    Download chapter PDF

  2. Goal Seek

    Pages 1-19

  3. Data Tables

    Pages 21-38

  4. Scenarios

    Pages 39-58

  5. Solver

    Pages 59-107

  6. Case Study: Using Excel What-If Tools

    Pages 109-130

  7. Back Matter

    Pages 131-167
    Download chapter PDF
Back to top

Keywords

About this book

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.

About the author

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.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation