Creating the Analysis sheet
The first sheet we will create is the Analysis sheet; as the current Dashboard sheet already contains a few of the metrics that we want on that sheet, first, let's change the name of the sheet from Dashboard to Analysis:
- Right-click anywhere on the sheet workspace and choose Properties.
- Navigate to the General tab and enter
Analysisin the Title input field.
- Click on OK to close the Sheet Properties dialog.
While we're at it, rename the Main sheet to
Associations. This sheet will help users to find associations on the data across many different fields. We might need to reposition the listboxes to fit our new layout.
The design toolbar at the top of the screen contains some useful commands for dealing with ...