Designing-a-Sales-dashboard-in-Excel

Objective:

Use Excel to analyze the sales based on various product categories and create the Dashboard using the sales and working data.

Queries:

1. Prepare a table of Sales and Profit month-wise in a working sheet.

2. Prepare the sales table region-wise in the working sheet.

3. Create User Control Combo box for Product Category.

4. Create a Column Chart of the month-wise table and region-wise table.

5. Link the table with a combo box.

6. Create a dashboard.