Remote Network And System Administration Job In IT And Networking

Creating an MVP of an internal review system in Excel VBA for macOS

Find more Network And System Administration remote jobs posted recently Worldwide

Hi there! I have a bit of a niche request for you! Im looking for an Excel/VBA expert!

The brief is to design and build an MVP of an internal review system using Excel VBA hosted on SharePoint.

There will be three User types, an Admin, Reviewer and Reviewee.

The review process is as follows:

An employee is up for review, the Admin will initiate a new review. Admin will allocate up to 6 Reviewers to fill out up to 6 templated spreadsheets with a variety of scores and text inputs based on our particular scoring system. On completion of the review, this will populate the Admin spreadsheet which will be hosted in a restricted area of SharePoint (or otherwise password protected). The Reviewee will also be asked to fill out a different templated spreadsheet which will populate another area of the Admin spreadsheet

After the review process is complete, the Admin will collate the scores and text responses from both the Reviewers and Reviewee.

The Reviewee will then be shown an anonymised summary of the scores and text responses. Ie. The Reviewee should not see who the Reviewers are.

Please let me know what I can clarify for you, I understand this is somewhat of a unique request!
About the recuiter
Member since Mar 14, 2020
Mourad Benguell
from Morelos, Mexico

Skills & Expertise Required

Excel VBA 

Candidate shortlisted and hiredHiring open till - May 9, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$26.80

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

Similar Projects

VBA Automate excel pivot tables + batch file

I have a text file automatically downloading to a folder.
I need to automate importing the text file from a folder, adding pivot tables, and dropping the completed excel into a folder.

BluePrism Finance Project - Need urgent help

I am looking for BluePrism developer who can help me with my current project. Need to finish this project in 15 days so i require help urgently. Application include Excel, SAP, Management web protal.

A clean and detailed SDD is prepared by...read more

Excel PM tool & project PN tracker for a small sales team. Linked files & updated to master tracker.

Im a new sales manager managing a team of 4 sales. As Im new to the team, I find out each sales is using their own format/ template of tracker to track status of their part. Would need help to consolidate them into a standard file format.

...read more

EXCEL POWER QUERY MANIPULATION

I have an excel data table that i need manipulating (ideally via Excels Power Query).

As youll see in the picture the first column is CODE. that will always be called CODE and will always be the first column.

we then have a repeati...read more

VBA Automation Developer

We are seeking an experienced VBA developer to create a Windows desktop application that will be used to automate steps involved to (1) import data from several CSV files (2) populate an Excel template with various forms of the data from #1, (3) per...read more