Excel Dashboard and Variance Tab Creation
Budget: $10 – $30 USD
I need an Excel project involving six tabs of inventory data. This will require a simple comparison and a dashboard.
Requirements:
- Dashboard to show key metrics:
- Total inventory count
- Daily comparison between dispatched and received
- Units in trucks
- Variance tab based on data from the six tabs
- Formulas or macros should automatically read pasted data and populate the dashboard correctly
Ideal Skills and Experience:
- Proficiency in Excel, especially with dashboards, formulas, and macros
- Experience in data comparison and variance analysis
- Attention to detail and ability to deliver accurate, user-friendly outputs
This is a straightforward task, but I expect more work in the future.
Requirements:
- Dashboard to show key metrics:
- Total inventory count
- Daily comparison between dispatched and received
- Units in trucks
- Variance tab based on data from the six tabs
- Formulas or macros should automatically read pasted data and populate the dashboard correctly
Ideal Skills and Experience:
- Proficiency in Excel, especially with dashboards, formulas, and macros
- Experience in data comparison and variance analysis
- Attention to detail and ability to deliver accurate, user-friendly outputs
This is a straightforward task, but I expect more work in the future.