In the $$Sort$$ worksheet, sort records in ascending order by customer last name, then first name, then sale date from newest to oldest.

In the $$Filter $1$ worksheet filter the data to show only the records of customers who bought items with list price of more than $$20$ but their purchase cost was less than $$16,$ after January $20$th$,2015.$

In the $$Filter$2$ worksheet, using the advanced filter tool the data to display only the records of customers from both of these groups:$$

Living in zip code $50012,$ bought $$Cement$-$Board$-5/8$X$4$X$4$ item$$ in the year $2015.$Living in zip code $68104$ and bought $$Rigid$-$Foam$-2$X$4$X$8$ after May $1$st$,2014$ through the end of the year.$$ Copy results to a new location, cell Q$8.$

Use the "Consolidate$2"$ worksheet.

$$ Use consolidate tool to create a list of "CustomerID" and "subtotals" for each customer.$$

In the $$Remove Duplicate$$ worksheet create a non$-$duplicate list of all items sold by using the $$Remove Duplicates$$ tool on the $$Description$$ field.

Create a table in the $$Table$$ worksheet. Include the total row.$$ Create two slicers for $$CustomerID$$ and$$Customer$\_$Zip$.$