Analyzing a Retail Organization's Sales Data using Pivot Tables

-Use the homework starter link to finish the excel spreadsheet and submit it back to me as a final draft

-follow the instructions for the assignment by clicking the link that says activity 9 homework instruction

-Download the Starter Workbook for this assignment: Act#9-Homework-Starter.xls Download Act#9-Homework-Starter.xls

The starter file is a table of quarterly sales data from a hypothetical coffee shop retail organization (Corey's Coffee). (This is the same data we used in Act#7-Homework.) This data was extracted from their sales tracking system and includes a year of sales data summarized by a quarter across two levels of grouping: the specific product (Product) and the category of that product (Category). The two other columns are the sales of that product in each of the four quarters of the reporting year (Qtr 1, Qtr 2, Qtr 3, Qtr 4).

-Description of Activity:

All instructions for this homework activity are described in this instruction slide set: Act#9–PivotTables-Homework-Instructions.pdf Download Act#9–PivotTables-Homework-Instructions.pdf

Note that all of your work for this assignment can be done in Googlesheets or other cloud-hosted application systems