UNIT 2 ASSIGNMENT scenario manager

-

Use Scenario Manager

Using Scenario Manager in Excel can help you analyze different sets of data and see how changes in variables can affect your results. Essentially, you’ll be able to create various "what-if" scenarios to predict outcomes and make informed decisions. By the end of this guide, you’ll be able to set up and use Scenario Manager with ease.

Steps to do scenario manager

Step 1: Open your Excel file

Open your Excel file where you want to use Scenario Manager.

Make sure your data is well-organized with clear headings and values. This will help you easily identify which cells you want to change.



Step 2: Go to the Data tab

Click on the "Data" tab at the top of the Excel window.

The Data tab contains numerous tools for data analysis, including the Scenario Manager.




Step 3: Click on What-If Analysis

In the Data tab, find the "What-If Analysis" option and click on it.

This will open a dropdown menu that includes different tools for forecasting and scenario analysis.


Step 4: Select Scenario Manager

From the dropdown menu, click on "Scenario Manager."

A new window will pop up, allowing you to manage different scenarios.



Step 5: Click on Add

In the Scenario Manager window, click on "Add" to create a new scenario.

This will open another window where you can enter the details of your new scenario.



Step 6: Name your scenario

Enter a name for your new scenario in the "Scenario Name" field.

Giving your scenario a descriptive name will help you remember what it represents later on.

Step 7: Specify changing cells

In the "Changing cells" field, input the cells you want to change for this scenario.

You can either type the cell references manually or select them directly on your worksheet.


Step 8: Enter values for the changing cells

After clicking "OK," another window will appear where you can input new values for your changing cells.

Enter the new values you want for this specific scenario.



Step 9: Click OK

Click "OK" to save your scenario.

FINAL OUTPUT




Comments

Post a Comment

Popular posts from this blog

`Data validation

-
Image
😊😊Data validation for error message😊😊 1. Click on data option in menu bar. 2. Select data tools then go to setting. 3.Choose whole number from drop list. 4. Fill the maximum number. 5. Fill the minimum number. 6. Fill title under error alert option.   OUTPUT   figure1:- figure 2:-  figure 3:- 
Read more

Assignment of removing duplicate data and if condition formula

-
Image
Remove duplicate data 1. Go to data option  in menu bar. 2. Select the data in which you want to remove duplicate items. 3. select the duplicate remove option which is situated next to the columns. Then dialogue box will appear which is shown following below :- OUTPUT:- If condition formula In Excel, you can use the IF function to perform conditional logic. The basic syntax is: = IF (logical test, value_if_true, value_if_false) logical test: The condition you want to evaluate (e.g., A1 > 10). value_if_true : The value that will be returned if the condition is true. value_if_false : The value that will be returned if the condition is false. Example 1: = IF (A1 > 10 , "Yes" , "No" ) If you want to check if the value in cell A1 is greater than 10, and return "Yes" if it is, or "No" if it isn't: Example 2: If you want to check if the value in A1 is greater than 50, and return "High" if true, or "Low" if false, you can d...
Read more

POWER BI

-
Image
  What is Power BI? Power BI is a business intelligence tool of Microsoft that is mainly designed to curate and present data insights that are most intriguing and engaging. It is a versatile tool that can easily derive data origins, including cloud services and Excel spreadsheets. Power BI is used by many businesses to create better visualization of data through charts, graphs, and other data interpretation techniques. Discover the art of Power BI more through the CCSLA exclusive  PL-300: Microsoft Power BI Data Analyst  course to gain valuable insights from industry leaders. Furthermore, Power BI offers data refinement and structuring to enable the development of reports, presentations, and interactive dashboards. The Power BI works at its total capacity to convert data, clean it, and make it more appealing using visual elements. It facilitates sharing and collaboration using cloud services. It helps them to cooperate reasonably in the team and make data-driven decisions...
Read more