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 Ilgar Zarbaliyev

Browse our top rated business templates. See All
Row, Column, Index, Match, Offset Functions. Excel Tutorial
511
53
 “It's Excel's world, we just live in it.” “To be an accountant in the age of spreadsheet program is —…
New Dynamic Functions. Excel Tutorial
530
47
In September, 2018, we released dynamic array formulas for Excel for Microsoft 365. The differences between dynamic arrays and legacy…
Fill Series. Data Validation. Excel Tutorial
522
42
 If you have inherited workbooks from someone else or if you have imported data from external data sources, you have…
HR INSIGHTS DASHBOARD
3,377
112
 This report includes the necessary analyzes according to some characteristics of the people who made and participated in the job…
Supplier_Insights
3,570
101
 Hello, This report is consisted of four pages. 1-Supplier Quality Metrics 2-Supplier Quality Regional 3-Top - Bottom Analysis 4-Downtime Analysis…
Sales_Analysis_Reportin Power BI
3,761
153
Hello, After participating in Enterprise DNA programs, I prepared reports on three topics in Power BI. The first report I…
See All