Company: Multinational large-scale FMCG
Timeframe: 1 week with a proposed dashboard look in a few days.
Deliverable: Fully functional coded excel sheet with an updating dashboard to represent progress. Ideally with a feature to submit and update individual entries.
Given data sample sheet attached below, I need an excel file (with a dashboard) wherein we can continually add data like the sample. The dashboard should be able to summarize the data points of the sample. Will be needing the dashboard to show:
1. how many stores were added this month
2. how many stores are assigned or unassigned
3. how many stores have been tagged
4. How many stores have been onboarded
5. Year to date and month to date progress report
6. Division of stores per category (how many % of total are specialty stores, how many % carry HC, etc.)
44 freelancers are bidding on average $148 for this job
Hi, I am an expert in expert in excel. I have checked the attached excel file there is not date column to calculate month, month to date, year to date etc. please can you send me complete data. Thanks
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.