Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Data Science & Analytics,Data Mining & Management freelancer for Excel expert needed for building spreadsheet to track jobs job

Posted at - Feb 7, 2023

Toogit Instant Connect Enabled


I am looking for an Excel expert to help finish the Master Job Tracker spreadsheet I am building for my company. I have made the headings and have an explanation for what I want each cell to do. We are a court reporting company so we follow each job from the first stage of the reporter writing on her machine the job (transcript), the transcript then goes to a scopist (editor), then to a proofreader, then back to the reporter, and then to the office. You can see why we need to track them! What makes it complicated is there is different turnaround times to select from (5-8 day turnaround, 3-day, same-day). And what I would like to happen is after the job date is selected, the turnaround time, then I would like the 'Scoping Due Date' and 'Proofing Due Date' to auto populate to their respective dates. So for example: If 'Job Due Date' is Monday, then 'Turnaround time' selected is 5-8 days, then I would like 'Scoping Due Date' to auto populate to noon 5 business days after the column 'Job Due Date'. And then I would like 'Proofing Due Date' to auto populate to noon 7 business days after 'Job Due Date.'
Is this possible? I am uploading the initial documents I created, the Excel with column names and a Word document with more explanations about each column.
Thanks in advance!

About the recuiterMember since Mar 14, 2020 David Crone
from Central, Uganda

Skills & Expertise Required

Data Science & Analytics Data Mining & Management 

Candidate shortlisted and hired
Hiring open till - Feb 16, 2023

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$143.99
Cost

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.