Remote Data Mining And Management Job In Data Science And Analytics

Excel macro vba specialist

Find more Data Mining And Management remote jobs posted recently Worldwide

Excel VBA/Macro Database expert to automate manual analysis of Cost/Price Excel spreadsheets & report on, & track changes made. Multiple acquisition cost excel files from multiple vendors must be combined all lists into new excel worksheet. Then compare the cost spreadsheet vs. the previous months cost spreadsheet & vs. the master excel customer price catalog. UseVBA & macros to automate comparison of customers product & price catalog vs. acquisition cost files from multiple vendors. Report on - 1. new products (part #s) listed in my acquisition cost files which are not listed in master customer price file - Mark to be added 2. (part #s) listed in acquisition cost files which are not listed in master customer price file - Mark to be deleted. 3. items where our acquisition costs have changed (higher or lower than the previous cost files) - Mark to review price changes 4. items where units of issue has changed (higher/lower then previous cost files) - Mark to review units of issue


About the recuiter
Member since Mar 14, 2020
Riki Nanda Put
from Kerala, India

Skills & Expertise Required

Excel VBA Macros Data Analysis 

Open for hiringApply before - Jun 28, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$34.49

Cost

Offer to work on this project closes in 44 days!
Are you interested in this Opportunity?

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

Quickbooks help needed

I need help with QuickBooks for very small business with less than 20 transactions per month. Need help to correct errors. Help could be remote via Team Viewer and telephone.

Google Sheet for Tracking Investment

I have some investments in one of the many lesser-known cryptocurrencies.

I am wanting a spreadsheet that tracks the value of these investments.

The primary thing I am doing is running nodes on virtual servers that earn on an unpred...read more

API to capture body measurements accurately.

I am looking for a developer with knowledge of machine learning, computer vision, data science and predictive modelling to create an API that is capable of capturing body measurements from a photo, and producing accurate body measurements.

Advanced Excel - INDEX and MATCH with multiple criteria with incremental match return

To all the excel experts out there, I need help on an advanced formula. I am trying to use an INDEX MATCH formula that is configured with MATCH set to look through a one-column range and provide a match based on given criteria. The sample criteria lo...read more

Sales & Marketing Data Analyst

Looking for medium level Data Analytics specialist that can assist with creating reports and dashboards for tools like Hubspot, Salesforce, SalesLoft, Outreach, Google Data Studio, Databox, etc