creating a memo from a pivot table
creating a memo from a pivot table
Your task is to write a 2 page Memo Report on the group you are assigned to from the “Product Material PivotTable” tab you created from Module 5 Project Assignment.
Steps:
1. From the Material filter to your assigned group on Canvas (Gold, Silver or Copper).
2. From the Type filter select “Select All”.
The Memo Report should contain information / analysis about the data you are viewing, which attributes were used, and what do the results indicate.
PivotTable:
Material
Type
Total Sales
Grand Total
PivotChart:
Column Chart
Filter by Material Type
Legend by years
Memo Report Length: 2 Pages double spaced
Ensure that you embed your unique copy of the PivotTable and PivotChart in your Memo Report from the worksheet. Then submit the Memo Report to Canvas. You may download a memo template from Microsoft Word in order to complete this assignment.