read more, you now input values that must change to achieve a specific goal. It can be found under the data tab in the what-if analysis section. Like a Data Table in excel Data Table In Excel A data table in excel is a type of what-if analysis tool that allows you to compare variables and see how they impact the result and overall data. In simple terms, you can see the impact of changing input values without changing the actual data. Scenario manager in Excel is a part of three what-if-analysis tools in Excel, which are built-in in Excel.Therefore, we can use it to make different scenarios, such as bad and medium, depending on the values present in the range that affect the result. ![]() ![]() It uses a group of ranges that impact an individual output. Scenario manager is a what-if analysis tool available in Excel that works on different scenarios.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |