Overview

                                     What-If Analysis

What-If Analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet. Four kinds of What-If Analysis tools come with Excel: Scenarios, Goal Seek, Solver, and Data Tables. Scenarios and Data Tables take sets of input values and determine possible results.

(https://support.office.com/en-us/article/introduction-to-what-if-analysis-22bffa5f-e891-4acc-bf7a-e4645c446fb4)

Reviews Add a review
No reviews yet

More From Excel World

Browse our top rated business templates. See All
What_If_Analysis_Data_Table
59
3
Data Table: It is a range of cells where one column consists of a series of values, called input cells…
Women Volleyball Teams_2018
795
29
This template covers women volleyball players' information of 16 countries in 2018.   Template is consisted of 4 sheets: -Cover…
What-If_Analysis_Scenarios
951
136
This Tutorial is about Scenarios (one of What-If Analysis Tools). It covers "Creating Scenarios", "Merging Scenarios" and "Scenario Summary Report".…
Kebabs, Pizzas and Sandwiches Recipes and Ideas
918
38
Dear Excel Lovers! Dear Fast Food Lovers! The Excel template contains menus, including the foods and quantities used in the…
Dynamic Amortization Schedule
1,214
81
Financial Schedules- Amortization Schedule An amortization schedule is a table detailing each periodic payment on an amortizing loan, as generated…
Static Amortization Schedule
845
64
Financial Schedules- Amortization Schedule An amortization schedule is a table detailing each periodic payment on an amortizing loan, as generated…
See All