Excel Tracker Developer for Document Review Process
Budget: $250 – $750 USD
Opportunity for a talented and experienced freelance Excel tracker developer to assist in streamlining our document review process. Your task will be to create an Excel tracker that effectively coordinates our team throughout the review cycle, which consists of two stages: the initial review and the final review of the document received from an external provider. This freelance opportunity requires excellent Excel skills, attention to detail, and a strong understanding of document review workflows.
Responsibilities:
Develop an Excel tracker to facilitate the document review process for our team, which includes both the initial review and the final review of the document.
Capture essential dates, including the start date, due date, and completion date of each reviewer's review for both stages.
Implement a user-friendly interface that allows team members to indicate when they have completed their reviews for each stage.
Enable the tracker to highlight any delays and clearly identify team members responsible for review delays in both stages.
Establish a link between the tracker and the shared folder containing the document under review for easy access for both stages.
Enable the tracker to be shared online and easily compiled by the team members.
To provide you with a better understanding of our expectations, we have an example video that can serve as inspiration. You can find it at https://www.youtube.com/watch?v=4gIqZvR7RJo&pp=ygUZZG9jdW1lbnQgd29ya2Zsb3cgbWFuYWdlcg%3D%3D. Please note that adjustments will be required to tailor it to our specific needs.
Requirements:
Proficiency in Microsoft Excel, including advanced formulae, conditional formatting, and data validation.
Strong organizational skills and attention to detail to ensure accurate tracking of review dates and delays for both stages.
Excellent communication skills to understand requirements and provide progress updates.
Prior experience in developing Excel trackers or similar project management tools is highly desirable.
Ability to deliver a functional version of the tracker within the specified timeline.
Willingness to make modifications based on feedback and improve the tracker over time.
Availability for ongoing collaboration and support at a reasonable price.
Responsibilities:
Develop an Excel tracker to facilitate the document review process for our team, which includes both the initial review and the final review of the document.
Capture essential dates, including the start date, due date, and completion date of each reviewer's review for both stages.
Implement a user-friendly interface that allows team members to indicate when they have completed their reviews for each stage.
Enable the tracker to highlight any delays and clearly identify team members responsible for review delays in both stages.
Establish a link between the tracker and the shared folder containing the document under review for easy access for both stages.
Enable the tracker to be shared online and easily compiled by the team members.
To provide you with a better understanding of our expectations, we have an example video that can serve as inspiration. You can find it at https://www.youtube.com/watch?v=4gIqZvR7RJo&pp=ygUZZG9jdW1lbnQgd29ya2Zsb3cgbWFuYWdlcg%3D%3D. Please note that adjustments will be required to tailor it to our specific needs.
Requirements:
Proficiency in Microsoft Excel, including advanced formulae, conditional formatting, and data validation.
Strong organizational skills and attention to detail to ensure accurate tracking of review dates and delays for both stages.
Excellent communication skills to understand requirements and provide progress updates.
Prior experience in developing Excel trackers or similar project management tools is highly desirable.
Ability to deliver a functional version of the tracker within the specified timeline.
Willingness to make modifications based on feedback and improve the tracker over time.
Availability for ongoing collaboration and support at a reasonable price.