Em Andamento

Build me a dashboard/s in Excel

I have a spreadsheet that I use as a report for a Portfolio Committee. It details what stage a project is at.

1. Concept Paper

2. Business Case

3. Project Brief

I have attached the current version and what data I am capturing.

I am looking for an advanced user of Excel to turn the spreadsheet into a dashboard. I am looking to be able to add:

1. A resource function - I want to be able to add/remove resource ie the name of the Business Analyst and be able to use drop downs to select the resource

2. A new sheet that graphically shows what projects each business analyst is working on how many days a week they are working on each project

3. An new Sheet that graphically shows start and finish dates of projects. Also would like to able to show what the Business Analyst estimates the work completion in days vs the actual days it took to complete the work

4. Look and Feel needs work!

Habilidades: Processamento de Dados, Excel, Excel VBA, Microsoft Access

Veja mais: design a business user web dashboard, help build dashboard business, excel spreadsheet portfolio loans, build dashboard excel social media analytics, excel spreadsheet project dashboard, report presentation excel spreadsheet, example spreadsheet sales report excel, dashboard excel spreadsheet, excel spreadsheet shares portfolio, loan portfolio excel spreadsheet, build excel spreadsheet, blog commenting excel spreadsheet report, seo products description use excel spreadsheet, report card excel spreadsheet, build widget excel spreadsheet, complete excel vbscript create user accounts, dashboard vba excel, free dashboard templates excel, excel spreadsheet commission report, excel yearly business plan spreadsheet

Acerca do Empregador:
( 0 comentários ) Australia

ID do Projeto: #17302125

Concedido a:

shoguna2m

Hello, my name is Andrés. First of all, thank you for considering my bid. I am an industrial engineer with more than four years of experience in the simulation, process improvement and data analysis fields. Within this Mais

$25 AUD / hora
(74 Comentários)
6.4

80 freelancers estão ofertando em média $20/hora para esse trabalho

schoudhary1553

Hello, I can help with you in your project Build me a dashboard/s in Excel . I have more than 5 years of experience in Data Entry, Excel, Excel VBA, Microsoft Access. We have worked on several similar projects befor Mais

$22 AUD / hora
(282 Comentários)
7.7
sandroshubladze

Hello, I am Excel Expert and VBA Developer with spreadsheet designing skills I can build for you desirable dashboard If interested, contact me Thanks

$25 AUD / hora
(198 Comentários)
7.8
jkaranm

Hi, My name is Janis and I have been here in freelancer since 2014. One of the preferred freelancer because of the good standing and have good feedback from previous employers. I was asked by the freelancer staff Matt Mais

$29 AUD / hora
(41 Comentários)
7.8
SBITServices

Hello toddhansell1, I have checked the file and understood your requirement. I have 2.5 years experience in Excel advanced concepts like VBA, Pivot table, Vlookup, Charts, Data analyser etc.. I can compl Mais

$17 AUD / hora
(412 Comentários)
7.4
dgled

I would like to suggest to you a Microsoft Excel application which enables you to manage databases of resources in a spreadsheet. The app allows you to open/edit/delete resources and conduct a central database with th Mais

$29 AUD / hora
(59 Comentários)
6.6
zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag Mais

$23 AUD / hora
(97 Comentários)
6.9
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$25 AUD / hora
(206 Comentários)
6.8
workerbee1974

I suggest microsoft access if you have microsoft professional. I can build it either way. My passion is building Custom Access/Excel Databases. I have built well over 300 custom databases in the past 19 years. I have Mais

$29 AUD / hora
(39 Comentários)
6.5
Tanmoy236

"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Busine Mais

$20 AUD / hora
(168 Comentários)
6.6
SShtv

I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data and constructing information panels. As an example, I bring screenshots of some of my works. Mais

$20 AUD / hora
(60 Comentários)
5.7
satishtl

- Have very good expertise in Excel. - Can get the resource being added via a dropdown Went through the Pipeline Summary Sheet & the sections Concept Paper Business Case Project Brief & Tracked Work. - B Mais

$20 AUD / hora
(49 Comentários)
6.0
aimefx

Hi, I am an expert in excel, VBA and power bi. I have created many similar projects before. Please, this video of my previous projects: [login to view URL] [login to view URL] If you were interested, Mais

$25 AUD / hora
(41 Comentários)
5.5
vaidyag

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in I Mais

$18 AUD / hora
(14 Comentários)
5.2
usmanhassan123

PhD in computer science having seven years of experience in Excel dashboard designing. I can also deliver you my previous work. I already done many dashboard projects.

$25.56 AUD / hora
(39 Comentários)
5.8
$50 AUD / hora
(7 Comentários)
5.3
vbhavesh448

If you want a powerful and easily manageable solution for dashboard or overview and generating analysis report based on data on your excel sheet then I can provide it by making on software which will display all data a Mais

$15 AUD / hora
(6 Comentários)
4.9
$17 AUD / hora
(27 Comentários)
4.7
gr8tech

Hello there I am available to assist you in building the required Excel Dash board. I not only have experience working with Excel\Formulas\VBA\Charts for data processing, analysis visualization, I also have experience Mais

$17 AUD / hora
(33 Comentários)
4.8
augurstech

Dear Employer, Hope you are doing well....!!! Coming to your project scope we will develop your dashboard with resource function where you will be able to add/remove resource ie the name of the Business Analyst a Mais

$18 AUD / hora
(3 Comentários)
4.6
supergana

Hi - I am a IT professional with 2 decades of work experience in a Tier1 company (Infosys) based out of India. I recently resigned and started taking up work on my own. I have 2 patents in US. Having played leadersh Mais

$22 AUD / hora
(23 Comentários)
4.5