Sample Excel Dashboards is useful for showing how a formula will be applied when a row or column is selected. You can also apply a grid style to make it easy to see if the cell’s value should match the selection.
There are many types of Dashboards. You can use them to show how the formula would be used in the formula window. Most often, these examples are used to show the multiple selection process. In this way, you can illustrate how various rows and columns could be combined.
For example shows the execution of a single variable row and column selection. You can select multiple rows and columns by clicking or holding the mouse button down. Using a Keystroke, you can then do a Selection in the list, get a Sub selection or Multiple Selection, or choose a second item from the selection. Note that there is a problem if more than one item is selected.
Another example uses the word ‘Hidden’. This word will have the effect of hiding the results on the page. The main purpose of a Dashboard is to hide the results in order to bring focus on the main functions on the page. This example shows how to hide the results to better control which rows and columns are selected.
Another example shows the use of a Matrix Calculation. This example does not use a Matrix Calculation in order to keep the Dashboard simple. Rather, it demonstrates how you can use the number format in two different ways.
In the Matrix Calculation Dashboard example, the Dashboard uses the Current Number format to enter values. In the Demo Case, the number format changes in order to add a second column. It then displays an extra row in a different format in order to make it clearer what it is doing.
Dashboards that show a selection might use a Back Button to reset the selected row or column. This would work with any sort of selection, including selecting one or more.
To use Dashboards you must first import the Dashboards into Excel. The Dashboards are mainly designed to have the formula-selection data. Most include images or numbers to display the selection.