It 2

Download as pdf or txt
Download as pdf or txt
You are on page 1of 7

Now, you will be taken back to the Scenario Manager Box.

Now the window will look like this.

Now, one scenario is done and dusted. Create a second scenario, and this where you need to
make changes to your Food & Clothes expenses. Click the Add button one more time and
give a scenario name as “Plan 2”. Changing the cell will be B15 & B13 (Food & Cloth
expenses).

8|Page
Now, below Scenario Values dialogue box opens again. This time, we do want to change the values.
Enter the same ones as in the image below:

These are the new values for our new scenario, Plan 2. Click OK, and now you are back to the Scenario
Manager window. Now we already have two scenarios named after Actual Budget & Plan 2.

9|Page
Click the Add button one more time and give a scenario name as “Plan 3”. Changing the cell will be B15
& B13 (Food & Cloth expenses).

Now, below Scenario Values dialogue box opens again. This time, we do want to change the values.
Enter the same ones as in the image below:

10 | P a g e
Tese are the new values for our new scenario, Plan 3. Click OK, and now you are back to the Scenario
Manager window. Now you have three scenarios named after Actual Budget, Plan 2, and Plan 3.

As you can see, we have our Actual Budget, Plan 1 and Plan 2. With Plan 2 selected, click the Show
button at the bottom. The values in your excel sheet will change, and the new budget will be calculated.
The image below shows what it looks like.

11 | P a g e
Click on the Actual Budget, then click on the Show button to see the differences. Initial values will be
displayed.

Do
the same for Plan 2 to look at the changes.

So Scenario Manager in Excel allows you to set different values and allows you to identify the significant
changes from them.

What is data validation in Excel?


Excel Data Validation is a feature that restricts (validates) user input to a worksheet. Technically, you
create a validation rule that controls what kind of data can be entered into a certain cell.
Here are just a few examples of what Excel's data validation can do:
• Allow only numeric or text values in a cell.

12 | P a g e
• Allow only numbers within a specified range.
• Allow data entries of a specific length.
• Restrict dates and times outside a given range.
• Restrict entries to a selection from a drop-down list.
• Validate an entry based on another cell.
• Show an input message when the user selects a cell.
• Show a warning message when incorrect data has been entered.
• Find incorrect entries in validated cells.

For instance, you can set up a rule that limits data entry to 4-digit numbers between 1000 and 9999. If the
user types something different, Excel will show an error alert explaining what they have done wrong:

How to do data validation in Excel

To add data validation in Excel, perform the following steps.

1. Open the Data Validation dialog box

Select one or more cells to validate, go to the Data tab > Data Tools group, and click the Data Validation
button.
You can also open the Data Validation dialog box by pressing Alt > D > L, with each key pressed
separately.

13 | P a g e
2. Create an Excel validation rule
On the Settings tab, define the validation criteria according to your needs. In the criteria, you can supply
any of the following:

• Values - type numbers in the criteria boxes like shown in the screenshot below.
• Cell references - make a rule based on a value or formula in another cell.
• Formulas - allow to express more complex conditions like in this example.

As an example, let's make a rule that restricts users to entering a whole number between 1000 and 9999:

With the validation rule configured, either click OK to close the Data Validation window or switch to
another tab to add an input message or/and error alert.
3. Add an input message (optional)
If you want to display a message that explains to the user what data is allowed in a given cell, open the
Input Message tab and do the following:
• Make sure the Show input message when cell is selected box is checked.
• Enter the title and text of your message into the corresponding fields.
• Click OK to close the dialog window.

14 | P a g e

You might also like