How to use Goal Seek in Excel for What-If analysis #sk excel trick
What-If Analysis is one of the most powerful an Excel
features and one of the least recognized. In most general terms, it is what-If
Analysis allows you to test out various scenarios and determine a range of
possible outcomes. In other words, it’s enables you to see the impact of making
a certain change without changing the real data. It is particular tutorial we
shall focus on one of Excel's What-If Analysis tools - Goal Seek.
What is Goal Seek in Excel?
It is Goal Seek is Excel's built-in What-If Analysis tool
that shows how one value in a formula impacts another. It is more specifically,
it’s determines what value you should enter in an input cell to get the anticipated
result in a formula cell in MS excel.
How to use Goal Seek in Excel?
It is persistence of this fragment is to walk you through
how to use the Goal Seek function. So that, we shall be working with a very
simple data set in Gold Seek MS excel.
|
Student Name |
Rank |
|
Rahul Kumar |
|
|
English |
80 |
|
Match |
57 |
|
Sanskrit |
58 |
|
Biology |
45 |
|
Science |
|
|
Total |
240 |
|
Percentage |
=W9/5 |
No comments:
Post a Comment
if you have any doubt let me known will
give suggestion in this site
Thank you so much