This exercise will utilize the template created previously to make two dashboards. Basic instructions are provided, but specifics are left to individual preference:
- Right-click on the tab entitled Template created in the previous exercise, Creating a template, and select Duplicate sheet.
- Repeat the previous step.
- Rename the first duplicate sheet Superstore Loss Leaders. Rename the second duplicate sheet Map Loss Leaders.
- Populate the Superstore Loss Leaders dashboard with the worksheets Loss Leaders Regions, Loss Leaders Cities, Loss Leaders Zip, and Filter. Arrange as desired.
- Populate the Map Loss Leaders dashboard with the worksheets Map, Loss Leaders Cities, Loss Leaders Zip, and Filter. Arrange as ...