I need help using Microsoft excel to create a better Excel dashboard
- or -
Post a project like this2515
$$
- Posted:
- Proposals: 15
- Remote
- #1557638
- Awarded
Excel VBA, MS PRoject Expert, Web Scraper, Arena, Simulation, Spreadsheet, Wordpress customisation
Istanbul
20 plus years of exposure of assisting its clients in Financial Modelling, Company valuations for Fund Raising in various stages of FR life cycle.
New Delhi
9634512341619539744372074947975079776883110176291267140130044913140071523510
Description
Experience Level: Intermediate
Industry: Business
Description of excel work: While we have significant expereince using Microsft excel we want to create a relationship with a Microsoft Excel/ Access consultant to help us develop an excel/ access model. I have created a simple mock up of the type of model we want to create and included it below. The finished model will contain more information and templates however at first we would like to understand how to create this version.
Our initial issues are in understanding how to create:
1 An automatic upload of a new sheet for each company where the information is correct despite the directors shareholding creating varying amount of rows for each company.
2 Dashboard information and detailed specific template for each company
3 Link to outside excel worksheets to bring information across if necessary and display symbol
4 Create graphs in dashboard
Description of excel work: While we have significant expereince using Microsft excel we want to create a relationship with a Microsoft Excel/ Access consultant to help us develop an excel/ access model. I have created a simple mock up of the type of model we want to create and included it below. The finished model will contain more information and templates however at first we would like to understand how to create this version.
Our initial issues are in understanding how to create:
1 An automatic upload of a new sheet for each company where the information is correct despite the directors shareholding creating varying amount of rows for each company.
2 Dashboard information and detailed specific template for each company
3 Link to outside excel worksheets to bring information across if necessary and display symbol
4 Create graphs in dashboard
Tadhg D.
100% (5)Projects Completed
9
Freelancers worked with
7
Projects awarded
17%
Last project
18 Mar 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
For your worry of automatic upload of data into your excel workbook,you have option in excel called connection.
Using this we can automatically import your different company data and compute and generate dashboards.
408841
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