Simple data analysis of sales with filters, pivot table and charts
Filters:
->Filter Electronics
->Filter Clothing
->Filter Quantity Sold<70
->Filter Price>50
->No filters
Pivot table :
->Revenue per Category
Charts :
->Revenue per Product Name
->Quantity sold per Product Name
->Revenue per Category
Filename: simple_data_analysis.xlsm
Download simple_data_analysis.zip (includes simple_data_analysis.xlsm)
Views: 12
Comments are closed.