Sales Data Analysis
Tasks
1) Get New Sales Raw Data (table)
2) Change sorting for Sales Raw Data using field ‘Value’ DESC (descending order) and then field ‘Country’ ASC (ascending order)
3) Create 5 Pivot Tables
Total Sales by Country
Total Sales by Salesperson
Total Sales by Customer
Total Sales by Product Category
Total Sales by Product Description
4) Change sorting to all 5 Pivot Tables
Total Sales by Country DESC
Total Sales by Salesperson DESC
Total Sales by Customer DESC
Total Sales by Product Category DESC
Total Sales by Product Description DESC
YouTube video: Create 5 Pivot Tables with a button (VBA)
FB Tags:
#vba #data_analysis #excel_tips #mindstormGR
Views: 31
Comments are closed.