Need Help to Develop Simple Excel Dashboard for Inventory Status

[Pathik Shah]

Hello Excel Experts,

I would like to develop one Excel Dashboard for Inventory Status which I can share with larger team in organization in just one snapshot.

I am having multiple inventory SKU with it's different stages so please tell me how it can be developed. It would be great if someone can provide template.

Thank you in advance for your help.

Regards,
Pathik Shah

 

[GraH - Guido]

Hi Pathik
You should at least try to make a visual of your dashboard.
Did you google "inventory dashboard in Excel"?

Perhaps have a read of one of these
https://chandoo.org/wp/excel-dashboards/
https://trumpexcel.com/creating-excel-dashboard/

Then come back and ask pinpoint questions to help you build the dashboard of your dreams.