I need help using Microsoft excel to create a better Excel dashboard
- or -
Post a project like this2525
$$
- Posted:
- Proposals: 15
- Remote
- #1557638
- Awarded
Book formatting/layout for Createspace/Kindle/Smashwords with Graphic design support
Chennai
Business Plan, Pitch Deck, Financial Forecasting, Equity Research, Excel Modelling
Dubai
164456816471221648805
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