Scribd Logo
Upload

Welcome to Scribd!

  • 88 views

    Introduction To What-If Analysis

    Uploaded by

    Mihir Sansare
    The document introduces various what-if analysis tools in Microsoft Excel including goal seek, solver, scenario manager, and data table. Goal seek and solver help optimize formulas by changing input values to achieve desired outputs. Scenario manager and data table allow testing multiple scenarios by substituting different value combinations to compare results.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Introduction To What-If Analysis

    Uploaded by

    Mihir Sansare
    88 views7 pages
    The document introduces various what-if analysis tools in Microsoft Excel including goal seek, solver, scenario manager, and data table. Goal seek and solver help optimize formulas by changing input values to achieve desired outputs. Scenario manager and data table allow testing multiple scenarios by substituting different value combinations to compare results.

    Original Title

    Introduction to What-If Analysis

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document introduces various what-if analysis tools in Microsoft Excel including goal seek, solver, scenario manager, and data table. Goal seek and solver help optimize formulas by changing input values to achieve desired outputs. Scenario manager and data table allow testing multiple scenarios by substituting different value combinations to compare results.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    88 views7 pages

    Introduction To What-If Analysis

    Uploaded by

    Mihir Sansare
    The document introduces various what-if analysis tools in Microsoft Excel including goal seek, solver, scenario manager, and data table. Goal seek and solver help optimize formulas by changing input values to achieve desired outputs. Scenario manager and data table allow testing multiple scenarios by substituting different value combinations to compare results.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 7

    BUSINESS ANALYTICS THROUGH MS EXCEL

    Introduction to What-If Analysis

    Delivered by
    Dr. Sameer Rohadia
    Data Analyst & IT Trainer l Hannover, Germany
    What is What-If Analysis?

    • One of the most powerful Excel features & one of the


    least understood.
    • It allows us to test out various scenarios and determine a
    range of possible outcomes.
    • It enables us to see the impact of making a certain
    change without changing the real data.
    What is Goal Seek?

    • It is within What-If Analysis tool that shows how one


    value in a formula impacts another.
    • It determines what value we should enter in an Input cell
    to get the desired result in a Formula cell.
    • It is especially useful for doing Sensitivity Analysis in
    financial modeling.
    • Goal Seek can process only ONE input value at a time.
    What is Solver?

    • It is a sophisticated optimization program that enables us


    to find the solutions to complex problems that would
    otherwise require high-level mathematical analysis.
    • It is a type of What-If analysis and is particularly useful
    when trying to determine the “best” outcome, given a
    set of more than two assumptions.
    • We use it to find an optimal solution which Maximizes
    Profit or Minimizes Costs or matches other criteria.
    What is Scenario Manager?

    • A Scenario is a set of values that Excel saves and can


    substitute automatically on our worksheet.
    • Scenarios are managed with the Scenario Manager
    wizard from the What-If Analysis.
    • A Scenario Manager allows us to change or substitute
    input values for multiple cells (maximum up to 32).
    • We can view the results of different input values or
    different scenarios at the same time.
    What is Data Table?
    • A Data Table is a range of cells in which we can change
    values in some of the cells and come up with different
    answers to a problem.
    • Especially useful when a formula depends on several values,
    and we would like to experiment with different
    combinations of inputs and compare the results.
    • E.g.: PMT function with different loan amounts and interest
    rates to calculate the affordable amount on a home
    mortgage loan.
    rohadiasameer@yahoo.com

    You might also like