Scenario You have been working as the new assistant to a member of the executive board for Northwind Traders, a company that distributes food and drink products to small markets all over the world. You received a message, containing a file, from your man
I’m studying for my Excel class and need an explanation.
the tasks are in the picture
ASSIGNMENT
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:
- Data
- 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.
Scenario You have been working as the new assistant to a member of the executive board for Northwind Traders, a company that distributes food and drink products to small markets all over the world. You received a message, containing a file, from your man
I’m studying for my Excel class and need an explanation.
the tasks are in the picture
ASSIGNMENT
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:
- Data
- 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.