Excel dashboard project
Budget: $10 – $30 USD
To create a dashboard to navigate the data in an easy and elegant way
:: Please consider the following Tabs ( CNS, OHID, IMM, PAH, MB) when doing the dashboard:
1. Colum for each month of the year "Jan 21 - Jan 23" ( Medical Supply, item, stock, sales, Average consumption, Coverage ) to allow filling the data in the future and reflected as well in the dashboard
2. fill the data provided from Dec 2020 - April 21 with the above sequence
3. the dashboard should be navigated easily and show charts like ( comparison between stock and average consumption, stock and coverage, stock and sales, etc )
4. All the above details and more are within the excel sheet
:: Please consider the following Tabs ( CNS, OHID, IMM, PAH, MB) when doing the dashboard:
1. Colum for each month of the year "Jan 21 - Jan 23" ( Medical Supply, item, stock, sales, Average consumption, Coverage ) to allow filling the data in the future and reflected as well in the dashboard
2. fill the data provided from Dec 2020 - April 21 with the above sequence
3. the dashboard should be navigated easily and show charts like ( comparison between stock and average consumption, stock and coverage, stock and sales, etc )
4. All the above details and more are within the excel sheet