Scribd
Upload
8 views9 pages

Excel Sales Dashboard Design Guide

The document outlines a project for designing a sales board using Microsoft Excel. It includes steps for preparing sales and profit tables, creating user controls, generating column charts, linking tables with combo boxes, and developing a dashboard. Each step is aimed at enhancing data visualization and interactivity in the sales analysis process.

Uploaded by

Mohhammad Rashid
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views9 pages

Excel Sales Dashboard Design Guide

The document outlines a project for designing a sales board using Microsoft Excel. It includes steps for preparing sales and profit tables, creating user controls, generating column charts, linking tables with combo boxes, and developing a dashboard. Each step is aimed at enhancing data visualization and interactivity in the sales analysis process.

Uploaded by

Mohhammad Rashid
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Microsoft Excel(MS-Excel®) Project – Designing Sales

Board

. Step-1:- Prepare a Sales and Profit Table month-wise.

. Step-2:- Prepare a Sales Table Region-wise.


Step-3:- Create User Control Combo box for Product Category

Step-4:- Create a Column chart for month-wise and region wise.


Step-5:- Link the table with Combo-box.
Step-6:- Create a Dashboard.

You might also like