I’m studying for my Excel class and need an explanation.
the tasks are in the picture
You will need to complete the requested reports for your manager. Download the spreadsheet with the raw data and create the requested reports using PivotTables and PivotCharts.
Your final Excel workbook should have a total of six (6) worksheets:
- Sales Distribution (Country)
- Top Five Categories
- Top Three Products-Category
- Top Five Customers
- Top Three Products-Customers
Aside from the raw data tab, the five report tabs should have both a PivotTable and a PivotChart.
Create a Microsoft Word or Google Docs document using a Business Letter/Memo template. In this letter/memo, summarize your findings from each of the five PivotTable/PivotChart reports you created and offer recommendations to your boss based on your observations of the data.
Limit your document to a maximum total of two (2) pages.