Excel Specialist -- 2
Budget: $15 – $25 CAD
Looking for a very good and organized Excel Specialist mainly to help us prepare our factory orders using data from multiple Excel/CSV documents.
Task that we are trying to simplify:
1. Export the in-stock inventory count from QuickBooks in a CSV format and input in our Excel master form containing multiple columns.
2. Also Input all the “to come” items individually from multiple Excel files.
3. Clean up the file from unnecessary information
4. Place and order based on all the information that was input
We need to automatically transfer and combine information from one Excel worksheet to another by product SKU. The person needs to be good with Excel with advanced formulas, task automations, database manipulation, extraction and Macros.
We are looking to improve repetitive and time-consuming tasks (download, combine, clean files). The idea is to improve this process by creating a macro-enabled Excel file that could automatically download, process, and aggregate data in a dynamic optimized document in order to save time and maintain accuracy while increasing efficiency and ease of use.
SKILLS required:
• Advance excel formula
• Macros
• Data Administrative Support
• Organized and methodical
• Diligent, structured work and efficient
• Very easy to communicate with in English
• Analytical and research skills with a need to understand how things work
• Strong computer skills including Excel are essential and knowledge of data modeling
• Good interpersonal and communication skills and ability to communicate technical information to both technical and non-technical people in English
• Quick to answer and available online during north America Eastern standard time from 9am to 5pm Monday to Friday
This would be the first project to work on and we would need you to work on other projects occasionally as needed.
Let me know if you are interested.
Task that we are trying to simplify:
1. Export the in-stock inventory count from QuickBooks in a CSV format and input in our Excel master form containing multiple columns.
2. Also Input all the “to come” items individually from multiple Excel files.
3. Clean up the file from unnecessary information
4. Place and order based on all the information that was input
We need to automatically transfer and combine information from one Excel worksheet to another by product SKU. The person needs to be good with Excel with advanced formulas, task automations, database manipulation, extraction and Macros.
We are looking to improve repetitive and time-consuming tasks (download, combine, clean files). The idea is to improve this process by creating a macro-enabled Excel file that could automatically download, process, and aggregate data in a dynamic optimized document in order to save time and maintain accuracy while increasing efficiency and ease of use.
SKILLS required:
• Advance excel formula
• Macros
• Data Administrative Support
• Organized and methodical
• Diligent, structured work and efficient
• Very easy to communicate with in English
• Analytical and research skills with a need to understand how things work
• Strong computer skills including Excel are essential and knowledge of data modeling
• Good interpersonal and communication skills and ability to communicate technical information to both technical and non-technical people in English
• Quick to answer and available online during north America Eastern standard time from 9am to 5pm Monday to Friday
This would be the first project to work on and we would need you to work on other projects occasionally as needed.
Let me know if you are interested.