Risk Template in Excel Training • Overview: Parameters Tabs

Video Training for Overview: Parameters Tabs

Audio Extract for Overview: Parameters Tabs

&nsbp;

Transcript and Screenshots for Overview: Parameters Tabs

In this training, I will give you an overview of Parameters tabs in Managenable® risk template software.

This overview is applicable to all Parameters tabs.

In the Home tab, there is no links for these tabs. You need to go to the Options tab to show or hide Parameters tabs.

For more information on how to show or hide tabs for Automation, please refer to the relevant training.

Options Link In Home Tab

All Parameters tabs are similar, except 2 tabs which have noticeable differences.

The Interaction Parameters tab is slightly different.

Interaction Parameters Tab

And, the Global Parameters tab is completely different.

Global Parameters Tab

For more information on these Parameters tabs, please refer to the relevant training (Interaction Parameters tab, Global Parameters tab).

As an example of all other Parameters tabs, let’s give a look at the Risk Parameters tab.

Risk Parameters Tab

In Parameters tabs, you can simply change a parameter cell, and see the change immediately applied throughout the risk application.

This way, you can rapidly customize this risk management tool, without having to change any formula, and without having to write any VBA code.

In each Parameters tab, there are several tables.

As an example, let’s give a look at the table Risk Gap To Control.

Risk Gap To Control: Table

Each table has a title and a subtitle, with an outline of its content.

Risk Gap To Control: Title

Each table has a Warning to remind you that if you change a parameter, you may have to also change the matching Charts Preparation tab, where a simple formula might be applied to shorten the text to be displayed on charts.
For more information on Charts Preparation tabs, please refer to the relevant training.

Risk Gap To Control: Warning

Below the title and subtitle, each table has 3 parts.

The left part of the table gives you an outline for each parameter.

Risk Gap To Control: Condition

The middle part of the table is the list of actual parameters you may change.

Risk Gap To Control: Items And Colors

Each parameter in this list must be unique.
If you have any duplicated item, the application will not work properly.

Risk Gap To Control: Items

Also, those parameters may contain a simple formula, which links various parameters together to create an even more integrated risk application.

Those formulas can be seen in the formula bar, or, in cells, by pressing F2 on your keyboard.

Press F2 to Enter a Cell

The right part of the table is for the colors associated with each parameter in the list, with a preview of the selected colors.

If you change any parameter, or any color associated with a parameter, that change is immediately applied throughout the risk application.

Risk Gap To Control: Color Selection Preview

Parameters tabs are a powerful feature of this risk workbook, and it is recommended to keep the default settings until you become reasonably familiar with the risk application.