Find more Scripts & Utilities Remote Jobs posted recently Worldwide

Required Excel VBA,Microsoft Excel PowerPivot,Microsoft Excel,sql freelancer for Excel reporting with Power Pivot w/ SQL database job

Posted at - Jan 27, 2018


Hello -
I have a report that shows daily results for my restaurants, districts (7-10 restaurants per district) and total. It utilized a SQL database and Power Pivot. I need someone to do the following"

- Add/remove metrics from the report - there are 4-5 metrics i need to add that come from various files on my server
- update speed - currently the refresh is taking a very long time (10 minutes)
- automate tabs - versus pre-building tabs I would like a macro that created the tabs for districts when pushed
- fix values - some of the values for the areas/restaurants aren't correct so the formulas need to be corrected
- add a ranking tab - I would like a tab that shows the top/bottom performers for certain metrics


Please let me know what questions you have

About the recuiterMember since Aug 15, 2017 Martin D.
from Maharashtra, India

Skills & Expertise Required

Excel VBA Microsoft Excel PowerPivot Microsoft Excel sql 

Candidate shortlisted and hired
Hiring open till - Jan 27, 2018

Work from Anywhere
40 hrs / week
Hourly Type
Remote Job
$2.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 Scripts & Utilities category.


Related Jobs


Latest In Excel VBA Jobs


Latest In Microsoft Excel PowerPivot Jobs


Latest In Microsoft Excel Jobs


Latest In sql Jobs