Use Excel to analyze the sales based on various product categories and create the Dashboard using the sales and working data.
-
Prepare a table of Sales and Profit month-wise in a working sheet.
-
Prepare the sales table region-wise in the working sheet.
-
Create User Control Combo box for Product Category.
-
Create a Column Chart of the month-wise table and region-wise table.
-
Link the table with a combo box.
-
Create a dashboard.