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
Ara Praptha
from West Bengal, India

Skills & Expertise Required

Excel VBA Macros Data Analysis 
Candidate shortlisted and hiredHiring open till - Mar 2, 2023

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$34.49

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

Other jobs by this client

Looking for Node.js expert for developing white label pannel for existing software. - Hourly
Full stack web developer for Data Processing, Storage and Plotting - Hourly
Developr needed to create an attractive POS - Point Of Sales - Fixed
Iranian-Accented/Farsi Female Voiceover - Hourly
Formulate an IT request to ask for a reading access to SAP tables Backend. - Fixed
Setup CICD for gitlab repo to DIGITAL OCEAN SERVER - Fixed
Amedica AS needs a designer for webdesign, Social media posts, brochures & invitations - Hourly
Node JS web developer needed. - Hourly
App Builder needed - Fixed
Mobile App Development - Fixed
Need a copywriter to rewrite the article IT&TECH related - Fixed
ADAMS DYNAMICS SIMULATION EXPERT NEEDED - Hourly
Need virtual assistant for wedding planning - vendor calling, web research, documentation - Hourly
Marketing consultant for AI startup - Fixed

Similar Projects

Google Sheets Analytics Expert

WHO WE NEED
We are looking for an expert on Google Sheets and Google Data Studio!
This task will require someone with a proper understanding of Zapier connector as well.


WHAT WE NEED
We need to recreate our current spreadshe...read more

Data Analytics Ninja

I am looking for a seasons Data Analytics Ninja.

I run a small business that is heavy in ecommerce. Im looking for someone who can help in the following areas:

FB pixel setup & tracking
Google Adwords
Google Analytics repo...read more

Run a Principal Component Analysis in R (preferred) or PRIMER

Run a PRINCIPAL component analysis (PCA) in R Studio / R Cloud or PRIMER.

The question is;
Can these factors (age, sex, distance, treatment) explain X% of the variation in participants responses.

Data has been prepared for you....read more

Create a revenue dashboard in Google Data Studio using first interaction model from GA

Hello

Im struggling to create a dashboard in GDS with the revenue from paid search but with model first interaction (last is by default).

I would be glad if you show me the solution :)

Link data in Excel

I need someone to link 2 sets of data into 1 pivot or slicer excel spreadsheet has 3 tabs: BPD, Data Object Summary and Attributes. It is the Data Object Summary and Attributes tab that need work. In Data Object Summary tab, I would like to link it t...read more