$!$

Required information

LAB $3-7($LO $3-5)$ Excel: Create a Dashboard Using PivotTables and Slicers

$[$The following information applies to the questions displayed below.$]$

Lab Insight: This lab will demonstrate how placing multiple pivot tables and pivot charts in the same spreadsheet c present opportunities for interesting analysis.

We will create a dashboard that consists of three pivot tables, three associated pivot charts, and two separate slice filter the dashboard components.

$**$Note: the dataset will not work on Excel for Mac.

PivotTables and Related Charts

Sum of Quantity Sold for each product $($and a related bar $($column$)$ chart$).$

Count of Sales Orders that have each product on them $($and a related bar $($column$)$ chart$).$

Both measures $($sum of quantity sold and count of sales orders$)$ for each product over time $($and a related line ch

Slicers

A dashboard$-$level slicer to filter each pivot table and pivot chart at once based on Customer state.

A report$-$level slicer to filter only the sales of product over time pivot table and pivot chart by product.

The slicer will be for state, so that we can see the changes in products sold for each separate region interactively.