How to use the script manager in Microsoft Excel

Microsoft Excel logo on a green background

If you have ever had to choose between two or more financial situations, you may have done some spreadsheet manipulation. You may have entered different numbers to see the different results. But did you know that you can use Scenario Manager in Excel for just that?

You can choose between jobs, projects, products or something similar, where the difference between them is financial or essentially digital. With Microsoft Script Manager, you can enter values ​​for each situation, save them, and then switch between them with a single click.

This can help you estimated finances or make a decision based on the results of the script manager. For the best way to show how useful the tool can be, let’s go through an example.

Use the Excel Script Manager

For our example, we have to choose between two different jobs. Job 1 has a lower salary, but is closer to home, which makes the price of our fuel lower. Work 2 pays more, but is farther from home, which makes the price of our fuel higher. We want to see which job leaves us more money at the end of the month.

CONNECTED: How to change the reference cell style in Excel

Add the data from your first script to your worksheet. Here we have the salary for work 1 in cell B2, minus the fuel costs in cell B3 and the monthly bills and cell B4. We enter a simple formula in cell B5, which shows us the remaining amount of money.

Data for the first scenario

Go to the “Data” tab, click the “What if” drop-down arrow, and select “Script Manager.”

Analyze what will happen in the Data section

In the Scenario Manager window, click Add to include this first scenario.

Add the first script

Give your script a name; we will use work 1.

Then select the Change Cells input field. You will enter or select cell references for all cells you plan to change for the script. You can either enter comma-separated cell references or hold Ctrl (Windows) or Command (Mac) until you click on each.

CONNECTED: All the best keyboard shortcuts in Microsoft Excel

In our example, our interchangeable cells are B2 for salary and B3 for fuel costs. Click “OK”.

Scenario details field

In the next pop-up window, enter the values. Since this is the first scenario and you have already entered the amounts in the worksheet, you should see these values ​​in the appropriate fields. Confirm and click OK.

Change cells for script

You will then see the Scenario Manager window showing your first scenario. Select “Add” to set up the second scenario.

Add the second scenario

Follow the same steps to name the script and enter Change Cells. Changing cells will probably be the same cell references as you compare situations. However, you can use different or additional cells from those shown, if necessary. Click “OK”.

Scenario details field

Now enter the values ​​for the second scenario in the field (not in the sheet). For our example, we introduce salary (B2) and fuel consumption (B3) for work 2. Remember that these are the two variables that change and that we compare. Click “OK”.

Change cells for script

You now have both scripts set up and you should see them in the Scenario Manager window.

Two scenarios in the manager's window

You already see the first scenario for work 1 in the worksheet, since you originally entered this data. To see the second scenario, select it in the window and click “Show”.

you will see your spreadsheet update to display the values ​​and calculation for the second scenario.

Scenario display 2

To show the first one again, select it in the Scenario Manager window and click “Show”.

Scenario display 1

This allows you to quickly and easily switch back and forth between scenarios.

When you get to the one you want to keep in your worksheet, make sure it’s displayed there and click “Close” in the Scenario Manager window.

Scenario Manager Notes

You can set as many scenarios as you want and switch between them in the same way. It is convenient to compare 3, 5 or 10 different numbers or financial situations.

CONNECTED: How to use Microsoft’s “Money in Excel” to manage your finances

You can use up to 32 changing cells for your script. We used only two in our example, but you can go much further and make many different comparisons.

To change or remove a script, open the Script Manager, select the script, and click Edit to make changes, or Delete to remove it.

To show a comparison in one place, open the Script Manager, click Summary, and select Script Summary. You will see an open new tab with a nice preview of your comparison that you can save or share.

Summary scenario report

Type: You can choose a script summary table Report instead of summary report if desired.

Before you spend time exchanging values ​​manually on find the best solution for your situation, be sure to review Scenario Manager in Excel. This really makes comparisons easy!

CONNECTED: How to use logical functions in Excel: IF, AND, OR, XOR, NO

Related Posts

Leave a Reply

Your email address will not be published.