Use $$Sort$$ worksheet to sort the entire data set based on Channel, within each channel based on category, and within each category by brand.

Use $$Filter$$ worksheet to filter records. Keep only transactions for computers sold on or after August $1,2016,$ and on or before November $15$th$,2016.$ Also, their sale price is between $$500$ and $$1200($inclusive$).$

Use $$Advanced Filter $(1)$ worksheet to create the following advanced filter:

Select customers who purchased GE Appliances for at least $$350$ in September $2016$

Use "Advanced Filter $(2)"$ worksheet to create the following advanced filter:

Select customers who purchased LG TV$\text{'}$s in August $2016$ from the North store, and customers who purchased LG TV$\text{'}$s in December $2016$ from the South store.

Use the $$Consolidate$$ worksheet to create a table of all channels, and total sales for each channel. Select cell $"$K$2"$ as the starting cell of the output.

Use the $$Subtotal$$ worksheet to create subtotals of sales for each channel. Sort the worksheet based on channel first. Copy Subtotal Rows to a new Worksheet.

Use the $$Table$$ worksheet to create an Excel table. Create Total row for this table.$$ Insert Average of Sales and COGS in the total row.$$ Use slicers to show only Mac Computers.