Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Data Analytics,Data Science,Excel VBA,Microsoft Excel,Microsoft Excel PowerPivot,Spreadsheets,Statistics,VBA freelancer for Custom Excel Spreadshet VBA - Task & Project Management job

Posted at - Aug 9, 2018

Create a custom spreadsheet that will be used for task & project management.

Project tasks broken up into several categories with each category containing take and sub tasks.

Each task /subtask to have a check box next to it that strikes out the task and marks it's status as complete once finished.

Each task / subtask will have priorities (Low, medium, high).

Each task will have a tag/category. Tags/categories will be generated from an editable table of tags categories.

Each task / subtasks will have option box for people assigned to task. People able to be assigned will be generated from an editable table of people.

Each task will have a start and end date. You click on the cell and you pick a date on a calendar.

Each task will have a description field where you can type descriptions and share links.

Will be able to easily add more tasks to list.

When adding tasks you can make it a subtasks to another task, and the subtasks will appear indented (like an outline format) under parent task.

On a separate tab you can generate reports that show tasls due today, by date, by person.

On a separate tab there will be a dashboard showing the % complete by category of task
It will also show % complete of entire project based on % complete of weighted tasks.

Tasks generate a gant chart or will be able to exportable to Microsoft project.

The spreadsheet can be copied and reused for other projects.

There may be other items that I need, but this is my intital idea.

About the recuiterMember since Aug 28, 2017 Samuel
from Quebec, Canada

Skills & Expertise Required

Data Analytics Data Science Excel VBA Microsoft Excel Microsoft Excel PowerPivot Spreadsheets Statistics VBA 

Candidate shortlisted and hiredHiring open till - Jun 5, 2019

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Apply on more work from home jobs posted in Data Mining And Management category.

Related Jobs

Latest In Data Analytics Jobs

Latest In Data Science Jobs

Latest In Excel VBA Jobs

Latest In Microsoft Excel Jobs

Latest In Microsoft Excel PowerPivot Jobs

Latest In Spreadsheets Jobs

Latest In Statistics Jobs

Latest In VBA Jobs