Develop an interactive dashboard in Excel
- or -
Post a project like this1302
£200(approx. $251)
- Posted:
- Proposals: 9
- Remote
- #2988564
- OPPORTUNITY
- Awarded
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
Website Developer, Graphic Designer, Transcriber, Content writer, CAD Expert, Python Developer, Photo Editor, Web Scrapper, JAVA developer, Android developer, Wix/Shopify Expert,
Regensburg
24785859647545841066498414064162543778280377238734914044120
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Develop an interactive dashboard
Hi I need an excel dashboard doing for a report that shows how many widgets companies have purchased.
The report has a tab for each financial year (5 year in total) on the tab it has a column for each month with a total column for the quarter. At the end of the tab it has a grand total for the financial year.  The row starts with the company name.
I need the dashboard to show:
1. The total number of widgets across the industry by year/month
2. An average of widgets purchased per month over the five year to show the trend throughout the months of the year. Eg it would show their sell more widgets in December.
3. To be able to show the increase in widgets purchased by a company over the last five years in comparison to our companies. Eg I could select company be in comparison to ours.
4.  show our companies widgets purchased per month yearly/monthly and over the last five years to show growth.
5. to be able to see the top 20 sites purchasing widgets and their yearly growth. 
6. Any other reports that help shown the data
I need:
To work ok excel Mac - could in work on an iPad?
Look good.
FAST - tomorrow morning
Be able to talk to you if we need to confirm points (to save 100's of emails)
open to ideas
Thanks
Hi I need an excel dashboard doing for a report that shows how many widgets companies have purchased.
The report has a tab for each financial year (5 year in total) on the tab it has a column for each month with a total column for the quarter. At the end of the tab it has a grand total for the financial year.  The row starts with the company name.
I need the dashboard to show:
1. The total number of widgets across the industry by year/month
2. An average of widgets purchased per month over the five year to show the trend throughout the months of the year. Eg it would show their sell more widgets in December.
3. To be able to show the increase in widgets purchased by a company over the last five years in comparison to our companies. Eg I could select company be in comparison to ours.
4.  show our companies widgets purchased per month yearly/monthly and over the last five years to show growth.
5. to be able to see the top 20 sites purchasing widgets and their yearly growth. 
6. Any other reports that help shown the data
I need:
To work ok excel Mac - could in work on an iPad?
Look good.
FAST - tomorrow morning
Be able to talk to you if we need to confirm points (to save 100's of emails)
open to ideas
Thanks
Zac J.
100% (46)Projects Completed
58
Freelancers worked with
46
Projects awarded
29%
Last project
23 Jan 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies