Excel Specialist Needed for Organizing Electric Bike Components for producing and ordering
Budget: €18 – €36 EUR
Task Description:
We are a manufacturer of electric bikes and we need an Excel professional to meticulously organize our list of components and sub-components. This will streamline our production and spare parts ordering processes. Here are the specific tasks required:
Data Organization & Structuring:
Combine and restructure multiple Excel files containing lists of electric bike components and sub-components.
Categorize components based on their primary function and subtype (e.g., Drive System: Motors, Batteries; Braking System: Brake Pads, Brake Levers, etc.).
Ensure that every component has a unique identifier, relevant specifications, supplier information, and price.
Hierarchy Creation:
Develop a hierarchy system to differentiate main components from sub-components.
Create relationships between components to showcase which primary component a sub-component belongs to.
Data Validation:
Scan through the consolidated list to identify and rectify any data duplications, inconsistencies, or errors.
Ensure that all data is accurate, updated, and relevant to our current product range.
Interactive Features:
Implement dropdown menus and filters to simplify the search process for specific components or categories.
We are a manufacturer of electric bikes and we need an Excel professional to meticulously organize our list of components and sub-components. This will streamline our production and spare parts ordering processes. Here are the specific tasks required:
Data Organization & Structuring:
Combine and restructure multiple Excel files containing lists of electric bike components and sub-components.
Categorize components based on their primary function and subtype (e.g., Drive System: Motors, Batteries; Braking System: Brake Pads, Brake Levers, etc.).
Ensure that every component has a unique identifier, relevant specifications, supplier information, and price.
Hierarchy Creation:
Develop a hierarchy system to differentiate main components from sub-components.
Create relationships between components to showcase which primary component a sub-component belongs to.
Data Validation:
Scan through the consolidated list to identify and rectify any data duplications, inconsistencies, or errors.
Ensure that all data is accurate, updated, and relevant to our current product range.
Interactive Features:
Implement dropdown menus and filters to simplify the search process for specific components or categories.