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!
80 freelancers estão ofertando em média $20/hora para esse trabalho
Hello, I am Excel Expert and VBA Developer with spreadsheet designing skills I can build for you desirable dashboard If interested, contact me Thanks
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
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.