Remote Data Mining And Management Job In Data Science And Analytics

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

Find more Data Mining And Management remote jobs posted recently Worldwide

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.

I can explain the logic on each sales tracker and would like you to take a hard look at it as an outsider to see how to best manage the massive amount of information for each project/ each part number from RFQ to Mass production, and to standardize it.

Later on, these standardized format will need to be link to a seperate Master sheets in order for me to quickly see a summarize of project (or parts) activities.

All files will be stored in the same computer in a shared network, so links can be established and can be automated for updates.
About the recuiter
Member since Mar 14, 2020
Kannan Vengaiya
from Baden-Württemberg Region, Germany

Skills & Expertise Required

Excel VBA 

Open for hiringApply before - Oct 2, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$26.78

Cost

Offer to work on this project closes in 6 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

Automate Copy/Paste from Excel or Google Sheets to Web Form. VBA Macro Script (Automation) Needed.

I have what should be a fairly simple scripting task. I hope to find somebody who can knock this out very quickly for me. Please reach out to discuss. If this goes well, I will definitely have more automation tasks to consider on an ongoing basis....read more

Extract data from Google Sheet to Excel workbook

We have a Google Sheet that contains 4 sheets of data.
We need the data on the 4 sheets to be exported to an Excel workbook when required

For this project we require
An Excel workbook to be created that can access a Google Sheet
...read more

Google Sheets Expert

Require an expert in spreadsheets, and specifically Google Sheets. Person must be an expert with:

- Pivot Tables
- Writing macros
- Formulas
- Conditional Formatting

Need a developer to improve current VBA Macro

To improve a current VBA-Macro in MS Excel that automatically opens workbooks and then transfers data from these multiple workbooks from a single folder to a single Macro-enabled workbook.
Currently, my VBA-Macro can only transfer my source data...read more

Excel expert needed for developing spreadsheets with macros and pivot tables

SK Market Inc is a small chain of grocery stores. We are looking for an excel expert to create spreadsheet that include pivot tables and macros. The main spreadsheets we are looking to create are for our liquor ordering and inventory and our buyers...read more