Use the Assignment Data File Download Assignment Data Filefor the following:
Build one Pivot table in a new worksheet for answering each question. Name the worksheet accordingly (1, 2, 3,…).
What is the monthly profit of each Category? Insert a Pivot Chart to demonstrate results..
What is the average monthly profit for Mac products? Insert a Pivot Chart to demonstrate results.
Which Channel sells the most 60” TVs? Insert a Pie Pivot Chart that shows percentages on each share of the chart.
Which Channel sells the most Phones? Show results as percentage of Grand Total. Insert a Pivot Bar Chart and slicer to break down by Brand.
Which Channel sells the most LG products? Insert a timeline for March 2016 data. Insert a slicer to show Android items. Insert a Pivot Column Chart to demonstrate results.
6. Build a Pivot Table to summarize average sales of Brand by Type for each month. Type must collapse within Brand. Brand should be show as row headers:
Insert a subtotal for each Brand
Format all table numbers to “no decimal” and thousand indicators (comma style)
Remove grand totals from rows and columns.
Collapse all rows and apply data bar conditional formatting to row headers only
Expand rows to show all data
Use Slicers for Category and Channel to show TVs sold at the Banner and Website stores. Hold “Ctrl” key to select multiple items in slicer.