Macros inventory excel jobs

I'm on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include samples of your previous...

Project Overview: The project involves reconciling sales data with weekly remittances over a span of 2.5 years in Excel. This requires merging multiple remittance files into one cohesive dataset, and then cross-referencing the sales data with the remittance data using a unique identifier (e.g., order number). The goal is to ensure that each sale corresponds to an accurate payout in the remittance, identifying any discrepancies or missing payments. Project Tasks: Data Collection: Gather all sales data and remittance files spanning 2.5 years. Ensure each dataset includes a unique identifier (e.g., order number) for matching. Data Merging: Consolidate all remittance files into one master remittance dataset. Arrange the data in a structured format for ease of analysis. Data Reconcil...

I need a skilled PHP developer to help complete the backend engineering for my E-commerce application on Revenue sharing model Key functional requirements: - User registration and authentication - Product listing and search - Shopping cart and checkout Specific features to be implemented include: - Inventory management - Payment gateway integration - Order tracking The application will mainly sell physical products, so the backend should efficiently support product management, transactions, and order tracking for this type of goods. Ideal skills and experience: - Proficiency in PHP, with a significant track record in backend engineering - Proven experience in developing E-commerce platforms, particularly physical goods - Strong understanding of integrating payment gateways and ...

I'm seeking a driven sales assistant well-versed in multitasking. Your main responsibilities will include cold calling, lead generation and sales follow-up. My business resides within the marketing industry. Having knowledge of different marketing channels like social media, email marketing, consulting, content production, and digital assets is preferred. To excel in this role, here's what you need: - A strong background in sales particularly cold calling and lead generation. - Good understanding of multiple marketing channels. - Excellent follow-up skills to ensure effective sales conversions. Apply if you're ready to help drive growth in an active marketing environment.

...completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Cont...

...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...

I'm looking for an experienced Excel whiz to help me organize a sizable amount of data. Specifically, you'll be dealing with multiple data categories that need to be sorted and structured. This calls for a high level of attention to detail and accuracy. Key deliverables include: - Sorting and categorizing the data efficiently - Utilizing conditional formatting and logic functions to make the sheet user-friendly - Ensuring all data is accurately placed Ideal skills for this project include: - Proficiency in Excel, especially with organizing and structuring data - Previous experience dealing with multiple data categories - A good eye for detail to ensure accuracy - Knowledge of conditional formatting and logic functions to make the sheet user-friendly If you hav...

I want to create Basic Vector Logo , A letter Head , And a Membership form FORM is in excel or PDF

...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...

I'm seeking a data aggregator for a unique AI training project. Key Tasks: - Gathering text content from official website/source of the particular product/entity. - Focusing specifically on product descriptions, specifications, price and other attributes. Ideal Skills: - Basic searching skills - Able to follow given format of data collection - MS Excel or Google Sheets This project requires precision, and the information gathered will contribute to an AI's learning process. Accuracy in aggregation is, therefore, key.

I am...with option example if your buying leggings then it would have a section stating "pairs with" up selling you may also like & customers also bought section Product sizing chart plugin Product categories in drop down style Privacy options for choosing cookies, terms & conditions, terms of use, privacy notice Editable changing banner for special messages on top of page Advances shipping & inventory module Product customer rating Advances seo plug in speed optimization cart flows advances security plug in seo & caching advanced plug in code management Robust Backend Image design for site ( I will provide photos ) I will require to know what plug and backbone you will be using. If you are using free plug in or paid versions. I will have fi...

I need help from an Excel specialist who can help me identify who has opened a shared Excel document that is located on Onedrive. I am trying to see when an employee accessed it last. - You'll need to create a solution that can track and log users who access the file. - The document is accessed by 2-5 people. - It would be beneficial if you could also provide a report or dashboard that can show this access data in a clear and concise manner. Please provide examples of similar work you've done in the past, and any relevant experience that you have.

...Availability: Customers should see real-time dress availability. - Reservation Management: A streamlined system for tracking and managing dress bookings. - Payment Processing: Reliable, secure processing of customer payments. During the booking process, we need an efficient way to collect key customer details including: - Name - Email - Phone number - Residential Address Managing our dress inventory is crucial and we prefer to handle this manually. Therefore, the system should provide a straightforward means to manually update stock levels. Ideal freelance applicants would have a portfolio showcasing similar e-commerce projects and are experienced in integrating the above-mentioned features. Strong skills in UI/UX design, payment gateway integration, and database management a...

I have an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the documen...

Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.

...a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be delivered in the next 2 days. If ...

I'm currently on the lookout for an expert in Excel 2016, with a specialized focus on the creation of VBA. The end goal? Correct spelling mistakes across multiple worksheets in my data set. Given the language locale, proficiency in English (USA) is essential. In addition to this: - Strong attention to detail and accuracy skills are needed. - Proven experience of using Excel, especially dealing with multiple worksheets. - Experience in creating and executing VBAs effectively for similar problems. Do you believe that your expertise aligns with these requirements? If so, consider submitting a proposal.

I am seeking a professional highly experienced in Sage reporting to generate standard reports for Supply Chain Management. Key examples include: Inventory Management: e.g., On-hand quantities, weeks on hand by part and storage location. Supplier Performance Management: - Spend by supplier. - On-time delivery report (receipt date vs required date). - Lead time analysis by part and supplier, including trend analysis. Open PO and aging report Additionally, there may be ad-hoc reporting needs. Ideal Skills and Experience: Proficiency in Sage Reporting software is required. Prior experience with supply chain data and reporting is highly preferred. Strong attention to detail and the ability to create accurate, user-friendly reports.

I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers ...

I'm seeking a professional developer with experience in Elementor to design and built an e-commerce website where I can sell my services. Key website functionalities needed include: - Inventory Management: This feature will allow me to keep track of the services offered. - Customer Reviews: A section for customers to leave ratings and reviews enhancing the trustworthiness of the services offered. - Discount codes option: For promotional purposes, a feature to apply discount codes is desirable. Ideal freelancers will have a strong background in e-commerce website creation, specifically service-based businesses, and familiarity with Elementor. A portfolio showcasing similar projects would be advantageous.

I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.

I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share...creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake data entry tasks with accuracy and speed. Experience with Excel data manipulation and a keen eye for detail are ideal for...

I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.

I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of

We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills

I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data is entered cor...

...Application development from scratch. - Debugging during the development phase to ensure top-notch functionality. - Providing software maintenance post-development. Key Features: - A simple and minimalist interface for user-friendly navigation. - Book borrowing management capability to check the status and track all borrowings. - User account management which enables personalized access for users. - Inventory tracking for systematic management and easy accessibility of books in the library. Ideal Skills and Experience: - Strong experience in Java development and Eclipse toolset. - An eye for creating user-centric, minimalist interfaces. - Prior experience in creating library management software or similar would be beneficial. and i want the source code and the code with swing ...

I am looking for a skilled Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets. The project specifically involves: - Utilizing Alteryx for blending data from multiple sheets in Excel - Handling complex data structures within the Excel spreadsheets, including nested tables and formulas. Ideal candidates will have: - Proven experience with Alteryx, particularly in handling data blending tasks - Strong understanding of complex data structures, like those found in nested tables and formulas in Excel This project requires a high level of attention to detail and proficiency in data manipulation, so please only apply if you have the necessary expertise.

I'm seeking a perceptive full stack developer to build a dynamic platform for selling used vehicles. Key functions include: - User Regi...profiles to facilitate transactions. - Advanced Search Filters: Users should easily find vehicles through specific features and filters. - Seller Verification: To ensure authenticity, a robust seller verification process is essential. The platform should accept versatile payment options including credit card, PayPal, and bank transfer methods to accommodate users' preferences. Finally, the inventory should appeal to a wide array of buyers with options for cars, trucks, and motorcycles. The ideal hire would have experience in eCommerce platforms, user experience design, security systems, and payment gateway integration. Note: Check t...

I require an experienced freelancer to manage 100-500 product uploads from my Shopify store to the Shein marketplace. Key task: - You'll be provided with the product images, descriptions, SKU, and inventory details for upload. Categorization: - The products also need to be correctly categorized into existing Shein marketplace categories. Ideal Skills: - Shopify and Shein marketplace experience - Attention to detail - Strong data entry skills - Excellent categorization ability.

I am in need of a Point of Sale (POS) system for my pizza store, catering to in-store purchases only. The system primarily needs to support cash transactions - making it ea...for my team to process orders and handle cash transactions. Key requirements include: - Generating sales reports: I would like the system to provide insights into daily sales, popular items, and revenue trends. - Inventory management capabilities: The system should help in tracking stock levels and provide alerts when inventory is running low. Ideal candidates will have experience in developing POS systems, particularly focusing on single-location businesses. Previous experience in the F&B industry or with pizza stores will be advantageous. A good understanding of inventory management and...

...years of technical business or functional analyst experience and demonstrated ability to see a project through from beginning to end including creation of business requirements and formal documentation during the solution development life cycle required  Strong emotional intelligence (EQ) and interpersonal skills required  Experience with workflow design required  Proficient in Microsoft Word, Excel, PowerPoint, Project, and Visio preferred Supervisory Responsibilities: None Travel:  Up to 20%, to include overnight stays, may include an annual software user conference Physical Requirements:  This role frequently communicates with others, must be able to exchange accurate information in these situations  This role routinely uses standard office equipment such as computers, p...

I'm in need of a savvy professional who appreciates the finer details of Major League Baseball (MLB). You'll be tasked with compiling a comprehensive sprea...should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on which pitcher is better, and predictions on which team will win. The ideal candidate will have a strong background in data manipulation, particularly in Excel or similar tools. But more than just your average data enthusiast, I'm specifically looking for someone with a deep understanding of baseball. If you can hit a home run with MLB stats and predictions, ...

I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.

I'm looking for a skilled professional to transmute product attributes into product variables for my electronics inventory. Particulars: - The attributes consist of Color, Size, Material, and Type. - The ultimate aim of this transformation is to make these variables usable for product filtering. Skills and Experience Required: - Experience with catalog management in the electronics industry. - Proficiency in data transformation. - Knowledge of product filtering mechanisms. Your ability to effectively execute this task will enhance our inventory management and streamline the user's product discovery process.

Please Sign Up or Login to see details.

hello everyone we have a CRM which allows us to manage our customers, a CRM entirely coded by us in html php and javascript. we have started to integrate a function which allows us to insert customers into our CRM using an excel file, but I don't have the time to finish that. It must be ready before the end of the day, today! mandatory deadline. if we are satisfied we will entrust you with many other missions on this brand new CRM

I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.

Apply VBA code in new Excel file

I'm looking to implement a multiplex pricing strategy for all my items, including bundles. This strategy focuses on providing differentiated price lists between pickup and shipping. Therefore, I seek someone with exceptional expertise in pricing stra...analyzing market trends and aligning them with my business to create effective pricing strategies. This project marks a strategically crucial shift in our business, ensuring our prices reflect the diverse needs of our customer base while maximizing profitability. Please bid with confidence if you possess the skills and experience above. Note: This project will include working with all items in our inventory, including bundles. Clear communication and extensive understanding of eCommerce pricing strategies will be critical to en...

I need an experienced accountant familiar with Odoo ERP to conduct a thorough audit of my manufacturing company's accounts. We have less than a year's worth of financial data to review. Key Areas for Audit: - Accounts Receivable - Accounts Payable - General Ledger - Inventory Your role will be to scrutinize these areas with the aim of ensuring accuracy and identifying any discrepancies or areas that need improvement. Ideal Skills: - Proficiency in Odoo ERP - Extensive experience in financial auditing, particularly for manufacturing companies - Strong knowledge of accounting principles and practices - Attention to detail and ability to spot inconsistencies - Good communication skills for reporting findings Please note that I'm specifically looking for a review and...

As a vendor, I have three excel sheets containing product numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe existing pink cells. Here's a detailed b...

I need a PHP Laravel system developed for my salon. It should include features for appointment booking, client management, and inventory management. Key Features: - Appointment Booking: The system should allow clients to schedule appointments easily. - Client Management: It should have a database for client management, allowing us to store and access information about our customers. - Inventory Management: The system should also include a feature for managing our salon's inventory. Design: I do not have a design or template for this system. Therefore, I'm looking for a developer who is skilled in creating a user-friendly and aesthetically pleasing interface. Online Payments: While the system should support appointment booking, I do not require online payme...

I am seeking a professional to conduct a comprehensive financial audit of our Odoo ERP system. The audit should focus on the General Ledger, Accounts Payable, Accounts Receivable, and Inventory modules. Key Responsibilities: - Reviewing and assessing the accuracy of data in the General Ledger, Accounts Payable, Accounts Receivable, and Inventory modules. - Ensuring the completeness of financial data in the system. - Conducting data reconciliation to identify any discrepancies. - Producing detailed findings on the Balance Sheet, Income Statement, and Cash flow statement. Ideal Skills and Experience: - Proven track record in financial auditing, particularly within ERP systems. - Strong understanding of financial reporting and reconciliation. - Experience with Odoo ERP would b...

Hi Work-Nix Solutions, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm in need of an adept hydraulic or fluids engineer to create a PVC pipe gold trap tailored specifically for high water flow. Key components for this project would be: - Efficiency: The design should excel in gold particle collection, regardless of particle size - from less than 0.5mm to 2mm. - Adaptability: The trap will be utilized in a sandy soil environment. - Durability: The trap should possess a high erosion resistance to exceed in everyday wear and tear in mining operations. Your expertise in fluid mechanics, material selection and applying scientific principles to practical application would make you an excellent fit for the task. An understanding of the gold mining process would be a plus but isn't necessary. I'm looking forward to discussing your ideas an...

I'm lookin...in the packing process. - Box size optimization: to reduce shipping costs and environmental impact, this feature should enable the best box size selection based on order contents. It's essential that the developer has experience with eCommerce systems, 3D visualization, and size optimization algorithms. The ideal candidate will also have a solid understanding of order packing logistics and inventory management. This web application will be mainly accessed via API. It will be sent all box dimensions available along with all products on a sales order along with their individual dimensions. It should return the boxes to utilized, the products in each box, and the diagram of how the items are placed in each box. It should fully optimize using the least and s...

I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key...managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL databas...

As your client, I'm looking for a specialist having a proficient knowledge of Microsoft Excel to achieve a simple data manipulation project. The task involves predictive analysis of data, heavily leveraging date and time functions. Key Responsibilities: - Manipulating data using simple Excel functions. - Predictive analysis using Excel based on the manipulated data. Ideal Candidate: - Sufficient proficiency in Microsoft Excel, with specialised expertise in date and time functions. - Strong attention to detail and accuracy in data entry and analysis. - Superior skills in organising and ability to handle increasing complexity when required.

Would you please be able to provide a quote for integration between our Woocommerce store and a online marketplace called Backmarket. Here are the integration docs from Backmarket. Our goal is to integrate the following functions through API. Inventory sync Create/update listing's from woo to Backmarket Sync pricing from woo to Backmarket Sync inventory levels from woo to Backmarket Orders Sync Order creation from Backmarket to woo Order update both directions Update order status and shipping notes both directions These are a high level view of the functionality needed. If these functions need further elements to make them functional this should be included in the quote. The quote should also include testing phase.