Program an Excel Sheet with a Dynamic Dashboard

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.)

Skills: Excel, Visual Basic, Data Processing, PHP

See more: interactive dashboard excel template, excel dashboard training, making a dynamic dashboard excel, interactive excel dashboard, excel dashboard design, excel dashboard templates xls, excel dashboard tutorial pdf, excel dashboard templates xlsx, make stand program excel sheet, ready program excel sheet, i have a pattern and material i need a manufacturer to make the clothes, i need a design done for the name of a new flashlight, i need a design for a bottle label this is for a vitamin water and it comes in 4 flavours it is quite simple as i already have a, i need a header image for the top of my website you can see the temporary attached, i need a lightroom expert in the uk, i need a logo design for the name synergy x, i need a logo that depicts the nature of my business, i need a technical writer in the atlanta area, i need a visionary website for the promotion of my new clothing brand to protect the brand we would like to be contacted by phon, i need an engineer to fix the problems of my computer

About the Employer:
( 0 reviews ) Makati City, Philippines

Project ID: #26350657

44 freelancers are bidding on average $148 for this job


Hello, I can help you with your project - Program an Excel Sheet with a Dynamic Dashboard I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have a More

$180 USD in 4 days
(424 Reviews)
(426 Reviews)
(161 Reviews)

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data More

$150 USD in 3 days
(96 Reviews)

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

$140 USD in 7 days
(91 Reviews)

Hey there! This is Sourabh Gupta from New Delhi. I am advanced Excel developer currently at the post of Forum Expert at I would like to provide my services for this project. I can develop a fully More

$249 USD in 6 days
(152 Reviews)

Hello sir, I have read your project details and reviwed attachment carefully. I can make Program an Excel Sheet with a Dynamic Dashboard by maintaining 100% accuracy of your data absolutely as you want ------VBA Macr More

$250 USD in 5 days
(131 Reviews)
(22 Reviews)
(93 Reviews)

Hi there, Need an Excel workbook with these features - adds batch entries or an entry, updates or modifies an Entry; and summarizes the five criteria in the job post thru Dashboard? Please message me if this is any More

$100 USD in 7 days
(23 Reviews)

Hi i am an certified excel VBA expert. Hi i can do it. For Professional works -Hire me. As 10+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i ca More

$300 USD in 1 day
(37 Reviews)

Hello I am Nathiya. I have lot of experience working in VBA, .net excel add-in. I am also a BI analyst. Have experience working in BI tools like Power I BI, Spitfire...etc. I completed many projects in this area. T More

$30 USD in 3 days
(32 Reviews)

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.

$90 USD in 1 day
(18 Reviews)

Only 140$ in 2 days-Lowest bid with a high potential solution-Payment after 100% Work satisfaction I have gone through your current requirements Excel Sheet with a Dynamic Dashboard & happy to provide the required s More

$140 USD in 2 days
(2 Reviews)

Greetings, Throughout my 35+ years career, I have used Excel extensively to manage the programs / projects / actions and the reporting requirements. Normalized/cleaned up lot of data, collected from various sources an More

$120 USD in 7 days
(2 Reviews)

Hi, I have gone through your project placement & it matches my expertise, I understand that you are looking for an expert in excel for dashboard. please visit my profile for reviews on similar assignments. My Profile: More

$30 USD in 1 day
(5 Reviews)

Hi, I have 15 years experience as Supply Chain analyst. My main competencies are, Excel and creating overviews. I am used to use Access as database for my Excel sheets. I am ready to start. I need a some more info bef More

$150 USD in 4 days
(1 Review)

Hi there, Hope you are taking care of yourself. I am Abhishek, a professional data scientist with 5 years of experience working with data to create compelling data stories. You can check out my profile for the portf More

$125 USD in 7 days
(1 Review)

Hi, I had read the details of your project and understood your requirements, I have experience, ping me and I will start the project immediately and finish your work in the least time possible with quality……. Thanks. More

$50 USD in 7 days
(1 Review)

Hi, I can this project for you. Though I am not able to get any useful input from the attached excel sheet, I till find this to be very interesting & challenging assignment , with a lot of dashboard requirements. I am More

$100 USD in 7 days
(0 Reviews)