This week I am going to walk you through the process of creating a single page dashboard. The purpose of a dashboard is to save space and prevent users from having to scroll down constantly by using a drop-down list to change the data on the screen.
In this lesson I will show you how to create the drop-down list which triggers the rest of the changes on the screen. A drop-down list is also an excellent tool to ensure that users only type specific pieces of data into a cell. Any data that is not a part of the list cannot be entered into a cell with a list. This prevents users from entering data you don't want them to. For example if all I wanted entered in the cell were the codes S, H, AH or IB then I could use the list. This would prevent a user from entering Honors.