Excel warehouse inventory spreadsheet jobs
...develop a digital scorecard in Microsoft Excel. The ideal candidate will have experience in Excel data management, visualization, and automation functionalities. Key Requirements: - Microsoft Excel proficiency: The digital scorecard will be based on Microsoft Excel, and as such, the freelancer must be highly skilled in this software. - Data entry fields: The scorecard should have user-friendly data entry fields, allowing for the easy input of information. - Interactive charts and graphs: The scorecard should include interactive charts and graphs that visually represent the data. - Automated calculations and summaries: The scorecard should automate calculations and summaries based on the data entered. Skills/Experience: - Proficiency in Microsoft Excel...
I am in need of a skilled data entry freelancer to assist in inputting textual data from digital files into an Excel spreadsheet. Key Responsibilities: - Accurately inputting textual data into an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data entry, particularly with textual data. - Familiarity with Excel and the ability to work efficiently with spreadsheets.
Good day. Trust you're well. I have a project that I need to download multiple PDF documents from website and compile them into 1 excel spreadsheet. Would you be willing to help with this?
I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding -...
...using a basic Google Sheet to track these details, but I need a more comprehensive, automated solution. The tracker will need to detail: - Crop type (specializing in fruits and vegetables) - Quantity harvested - The date of harvest - The sale price of each item - Purchaser name - Remaining stock (calculated by subtracting the amount sold from current inventory) Ideal skills and experience for this project would include Google Sheets or Excel expertise, incorporating automated calculations, and the ability to create a user-friendly layout. Knowledge of or experience with farming or agriculture would be a bonus but is not a requirement. The key for me is accuracy and simplicity. A system that is too complicated or prone to errors won't save me any time. I look forward...
Looking for an experienced web developer who can take my Google Sheets table / Excel spreadsheet with the custom formula and turn it into an engaging, dynamically updatable and nicely styled website which I can embed into multiple sections of my WordPress site. Skills and Experience: - Proficient use of WordPress - Extensive experience with website development and design - Sound knowledge of Google sheets and its functionalities - The developer should be able to make the sheet customizable and allow for data updating. Please include your experience relevant to the job as part of your application. Don't worry about showcasing your past work or drafting a detailed project proposal - your background in web development and WordPress is what's most important to me...
I'm looking for a professional who specializes in cleaning text data to help me with my project. Key Responsibilities: - Identify and remove duplicates within the text data - Correcting typos, spelling mistakes, and grammatical errors - Standardize the data in terms of formats and consistency I need someone who can handle this project within a month. Ideal Skills: - Proven experience in data cleaning, specifically with text data - Proficiency in text mining and natural language processing - Attention to detail and accuracy - Effective communication skills to keep me updated on the progress of the project. If you have these skills and are available to start working on the project as soon as possible, I'd love to hear from you.
I'm seeking a skilled game developer with professional experien... The objective isn't explicitly defined, but the emphasis is on enhancing game dynamics rather enforcing modification. - Dedication to improving player-to-player interaction. You should be adept at crafting solutions that create a more engaging, social landscape within the game. - Development and implementation of a trading system. This feature should be designed to enable a fair exchange of inventory items between players, enriching the communal aspect of the game. Ideal candidates will have a portfolio reflecting their expertise and creativity in developing Metin2 plugins/scripts. Your bout for coding strategies that heighten player engagement and enrich the overall gaming experience will be highly valua...
I'm seeking a skilled developer to enhance my Odoo POS V15 system. The project involves incorporating inventory management capabilities and revamping the system's design. Key Points: - **Inventory Management**: I want an efficient inventory management feature, with a particular emphasis on utilizing the DataMatrix feature. This will require you to enable the system to scan and decode DataMatrix codes. - **Design Changes**: The system's design also needs an overhaul for better user experience. Ideal Skills and Experience: - Extensive experience in Odoo POS V15, with a proven track record of system enhancements. - Proficiency in developing and integrating inventory management systems, especially those involving unique features like DataMatrix....
...working on our Power App, using it to collect date data that they later send to an Excel spreadsheet. Unfortunately, we're facing an issue wherein the date picked up by the Power App appears to be a day behind the date actually entered. Your task will be to investigate and rectify this date discrepancy issue, ensuring that the date data picked up by the Power App is accurate and aligns with the data entered by the user. Key tasks and responsibilities would include: - Analyzing the date data flow within the Power App to understand the root cause of the discrepancy - Implementing a fix that ensures the date picked up is the same as the date entered - Verifying that the data is correctly being sent to Excel, reflecting the accurate date Ideal Skills & Exp...
1- Convert the excel data to Sage300 GLGE entries: Help in converting data from the excel details data to Sage300 excel format to import them directly inside Sage 300 ERP to create the needed GLGE entries automatically. 2- Support Sage300 Integration (AM Acquisition app): The application you developed previously needs an update. In the current process of creating Acquisition Entries based on shipments, all items are being transferred to the Fixed Asset module, irrespective of the data. The necessary update involves ensuring that only records with relevant data are migrated automatically when shipments are loaded in the application. Specifically, records without asset details (Sage optional fields) should be flagged as ignored. This flag should provide the user wit...
...design is paramount. 2. Functionality Improvements: The goal is to make every aspect of the software work seamlessly and quickly, especially focusing on providing smoother and faster billing. 3. Inventory Management: The software should deliver on our inventory management expectations, ensuring efficient tracking of goods and services. 4. API and Integration: The system needs to be designed such a way that the Sales Invoice page might be connected with API. Later more apps need to be connected with API. This project requires proficiency in Django, API integration and an understanding of inventory management systems. A background in crafting intuitive interfaces and creating smooth functionality would be ideal....
I need a proficient data entry operator to assist a task involving typing handwritten documents into Excel spreadsheets. The ideal candidate would have previous experience in data entry, and a high speed typing ability. Accuracy is key in this project, as they'll be transcribing valuable information, it's critical every detail is correct. Time management skills are also important, as there's a specific deadline to complete the task. If you've done similar jobs in the past, please mention it in your proposal. I look forward to working together.
I urgently need an experienced Tally developer who can seamlessly integrate the OBR (Tax Department) API into my current Tally software. Your role will primarily involve: - Implementing API integration for advanced functionality - Guiding the customization process to improve account management, inventory management, and report generation Skills and Experience: - Strong expertise in Tally software - Proven experience in API integration, preferably in the OBR (Tax Department) - Efficient in meeting tight deadlines Please note, I require this project to be completed with utmost urgency. Candidates who can deliver quality work promptly will be favored.
I need help populating an Excel sheet with 378 company websites. - The task involves searching the internet for the website of each company and entering it into the Excel sheet. - If a company doesn't have a website, please mark it as 'No Website'. - All URLs should be inserted in a new column in the existing Excel file. I would prefer the URLs to be in the format '' or ''. Ideal Skills: - Proficiency in Excel and web research. - Attention to detail to accurately populate the data. - Strong communication to flag issues or ask questions during the process.
Any one experienced with octoparse or any other web scrapping tool can easily complete this straight forward web scrapping project. Please see this google drive link for instruction and check attached excel where sample scrapping is done for you.
...analyst to organize and create detailed furniture packages for various property types and customer segments. The goal is to systematically structure these packages in Excel, covering multiple styles and accommodating property sizes from studio apartments to 4-bedroom homes. Each style will cater to different client types: holiday homes, new homeowners, expats, and investors. ### Objectives - **Create Defined Furniture Packages**: Develop comprehensive lists of items included in each package tailored to specific client types and property sizes. - **Organize Data Efficiently**: Present the data in a clear, accessible format in Excel that allows our team to understand and utilize the information effectively for sales and marketing strategies. ### Scope of Work 1. **Data Org...
I'm in search of a talented and hard-working freelancer to help me with an Excel task. The job at hand is complex and demands someone with strong analytical skills and attention to detail. The primary objective of this project is to achieve a high level of accuracy and efficiency in the output. Thise means that the quality of work is paramount. To succeed in this role, you must have a good understanding of Excel, be able to think logically, and work meticulously. Key Skills & Experience: - Proven track record in Excel data management - Strong analytical and problem-solving abilities - Attention to detail - Ability to work autonomously I look forward to receiving your application, and I will be in touch with the successful candidate soon.
...streamline the process of time-stamp duration reporting in Excel. The solution I'm seeking should ideally have the following components: I have a report (excel-sheet) exported from a system that I use in a weekly basis, however in this report, the date and time of processing exported in a form of “timestamp” and in order to calculate elapsed time of each stage in cycle, every time I have to do the followings: - Fix the format issue in excel since system always export data in a form of “timestamp” and there is no to fix that. - Exclude non-working hours for each stage/ elapsed time. - Exclude Weekends (Friday & Saturday). - Sum up the total of elapsed times Do you have a solution that I can use the as tool either by creating exc...
I'm looking for a Salla developer to set up my online store. The project entails creating a store with custom product options, a payment gateway, and inventory management features. Key Requirements: - Platform: Salla - Features: Customizable product options, Payment gateway integration, Inventory management Custom Product Options: - Text Fields: for customers to personalize products - Dropdown Menus: for product variations - Image Upload Capability: so customers can add images to their orders I need a developer with Salla experience to ensure a smooth and successful implementation. The ideal candidate should have a good understanding of e-commerce, particularly in customizing product options, and expertise in Salla platform. Looking forward to hearing from capable ...
I'm looking for a freelancer who can provide me with the links to Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Co...Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Compile a list of specified Facebook pages - Deliver the links in google seets Ideal Skills and Experience: - Proficiency in Internet Research - Experience with Excel or Google Sheets - Strong attention to detail - Ability to follow instruct...
I'm looking for a skilled freelancer to enhance my Google Spreadsheet with a few specific features 1. Protect on Edit Functionality: I'd like to add a protection mechanism that ensures the spreadsheet can be edited by all users but avoids accidental changes to existing data. 2. Automated Data Analysis: I'm looking to automate the process of data analysis in the spreadsheet. Your solution should be efficient and user-friendly. 3. Make analysis available in existing web page 3. Export to other existing database It is important that the sheet can be accessed and run from Google Workspace with mainstream browsers without requiring usr to download extensions, run scripts, etc Happy to work on time based payments and will contract item 1 first and then mo...
I'm in need of a talented professional to tailor my point of sale (POS) odoo V 15 system, focusing mainly on two components: user interface design and inventory management. Here's what I'm looking for: USER INTERFACE DESIGN: - Some features should be added while others removed to foster user-friendliness. INVENTORY MANAGEMENT: - sales by datamatrix handle all sales process by datamatrix. - Addition of features like a tab per order, listing view, and batch data. Please only submit a proposal if you have extensive experience in customizing POS systems and have a knack for clean, minimal design.
... Detailed Job Descriptions - Strong proficiency in Microsoft Dynamics 365 for Finance and Operations (D365 FinOps), including experience with retail functionality - Experience in customizing and extending D365 FinOps retail solutions using X++ and .NET technologies - Proficiency in developing and maintaining retail management systems, point-of-sale (POS) systems, and inventory management systems - Demonstrated expertise in designing and implementing retail processes and workflows - Experience with data migration, integration, and interfacing with external systems - Strong problem-solving and debugging skills - Excellent communication and collaboration skills, with the ability to work effectively in cross-functional teams and mentor junior developers - Bachelor's or
I'm in need of a proficient Excel and Word expert who can assist me with various tasks. Unfortunately, I did not specify the exact tasks nor provide a deadline for this project. However, I'm excited to review your proposal and discuss your experience in more detail. Please include your past work in Excel and Word with your proposal. This could be anything from template creation to complex data analysis and automation. The more detail you can provide about your past work, the better. In terms of my needs, I'll be looking for a flexible freelancer who can help out with a range of tasks. Experience in data analysis, formula creation, and automation in Excel would be particularly desirable, as would proficiency in creating and formatting templates in Wor...
I am in need of an experienced and knowledgeable professional to assist in the development of a comprehensive training program for individuals aspiring to become advanced pentesters. Key responsibilities: - Create a structured, in-depth training curriculum focused on web applications, networks, and mobile applications pentesting. - Design ...particularly in the areas of web applications, networks, and mobile applications. - Prior experience in designing and delivering training programs, workshops, or courses. - Strong communication skills and the ability to explain complex technical concepts in a clear and concise manner. The goal of this project is to equip participants with the necessary skills, knowledge, and practical experience to excel as advanced pentesters in a professiona...
I am looking for a skilled Power BI specialist to help me create an engaging and dynamic dashboard. The primary data source for this project will be an Excel spreadsheet. Key Metrics and Visualizations: - The dashboard should highlight key metrics and KPIs such as sales figures, customer engagement metrics, and operational efficiency. - I would like to see a mix of different chart types in the dashboard, including bar charts, line graphs, and pie charts. Ideal Skills and Experience: - Proficiency in Power BI and data visualization techniques - Experience working with Excel spreadsheets as a data source - Ability to create dynamic and engaging dashboards that effectively highlight key metrics - Knowledge of various chart types and the ability to recommend the most ...
...Volume and Sales Data History features of the Shopee API - Enable tracking of average monthly search volume for my product listing - Provide monthly sales data for each product - Extract historical sales data within a window of the last three months Ideal Candidate Skills: - Proven experience with Shopee API integration - Strong knowledge in data tracking and analysis - Sound understanding of inventory management, and product listing - Efficiency in task execution and time management I am looking for someone who can help me steer my business decisions with the help of informative data. If you have the skills and experience mentioned above, I’d like to hear from you....
...menu data, which exceeds 500 entries, in Excel. My project primarily involves handling text data. Here's what you would focus on: - Categorizing different types of food items. - Ensuring accuracy and consistency in data entry. While not a firm requirement, familiarity with culinary vocabulary could be beneficial. Additionally, someone proficient in MS Excel and particularly experienced in data categorization would be ideal. I appreciate your consideration and look forward to potentially working with you. Paid project: remote work Seeking Assistance: Categorizing Online Menu Data in Excel Hey guys, I hope you're doing well! I'm reaching out because I could use your expertise for a project I'm working on involving categorizing online me...
I have a highly encrypted XLSM file that I urgently need help with. This specific project involves making VBA in the file visible. I need someone with advanced VBA skills and experience in cracking down highly encrypted XLSM files. Key requirements: - Expertise in VBA for Excel - Experience with highly encrypted XLSM files - Ability to make VBA visible in such files Please only apply if you have previous experience in this area and can start immediately. BID NOW!!! Serious freelancers only with the skills since it is ASAP!!
I'm seeking an Excel expert to revamp my Google Sheets, transforming it into an interactive platform. Specifically, I need to integrate the XIRR calculation for my stock transaction data, which spans over 4 years. This will involve the addition of dropdown menus for transaction selection, buttons for XIRR calculation, and color coding for profit and loss data. Key Requirements: - Integrate XIRR calculation for stock transactions - Create dropdown menus for transaction selection - Develop buttons for XIRR calculation - Implement color coding for profit and loss data Additional Context: - I am using Google Sheets, not Microsoft Excel - I update my stock transaction data on a weekly basis Ideal Freelancer: - Proficient in Google Sheets - Experienced in complex Excel...
...as a platform for data visualization and export. Key Functionalities for Admin User: - **User Management:** The admin should have the capability to manage user accounts, including setting access permissions. - **Graph Creation:** The admin needs to be able to create visual representations of data. - **Data Viewing and Exporting:** The admin should be able to view all the data and export it to Excel for further analysis. Graphs Per Department: - **Data Points:** The graphs should focus on data from Sales, Expenses, Profit, and Number of Employees, using a rolling average approach for accuracy. - **Rolling Average Calculation:** The rolling average for the graphs should be calculated based on Manual Entered Data, per department. Additional Requirement: - **Formula Calculation...
I'm seeking a proficient data entry specialist to assist with my project. The task involves entering text data from various digital documents into a spreadsheet. Key project details: - The data consists of text only, no numbers or images. - You'll be provided with digital documents in PDF and Word format. - The main goal of this project is data analysis and reporting. Ideal skills and experience: - Proficient in data entry, with high accuracy and attention to detail. - Experience with data analysis and reporting is a plus. - Familiarity with handling text data from PDFs and Word documents is preferred. Your role in this project is crucial as the data you enter will be utilized for further analysis and reporting. If you have relevant experience and a keen eye for detail,...
I need assistance on a monthly basis with bookkeeping and managing operations of my transportation and logistics business. The freelancer who takes on this task will be responsible for the following: Key Responsibilities: - Tr...will be responsible for the following: Key Responsibilities: - Transportation management - Order Finding - Order tracking - Client Meetings Skills and Experience Required: - Strong organizational and routing skills - Experience with transportation management - Proficiency in using Excel Spreadsheets for data management - Ability to communicate effectively during client meetings In conclusion, this role requires an individual proficient in Excel and experienced in logistics and inventory management, who can also handle clie...
...of both text and numeric data from PDF files. The extracted data will then need to be arranged in a specific format in an Excel sheet. Key Responsibilities: - Extract both text and numeric data from PDF files - Perform the data extraction on a weekly basis - Arrange the extracted data in specific columns and rows in Excel Ideal Candidate: - Proficient in using PowerAutomate for data extraction - Experience working with PDF files and Excel - Attention to detail for correct formatting of data - Ability to meet weekly deadlines - Strong communication skills to verify data accuracy Please find attached pdf (extract) example (there is 5 different templates to use) & excel (input). Looking forward to working with you! We have many more use cases like this,...
I'm in need of a highly skilled AWS OCR specialist to help extract data from a large number of PDF invoices. We intend to export the extracted data into an Excel (XLSX) file. All invoices follow a consistent format, as shown in the attached sample. All invoices have been scanned at 300dpi resolution with searchable OCR enabled." Key Requirements: - Proficiency with OCR technologies, particularly those integrated with AWS services (Textract) - Experience with extracting data from PDFs, especially invoices. - Ability to export extracted data into Excel format. The freelancer will supervise the implementation process on our PC. Due to confidentiality, access to the invoices will be provided remotely on my PC
At present, we manage all our revenues and expenditures through multiple bank accounts. For different types of expenses, we use different cards - for instance, the card ending in 1234 is used for fixed expenses, while the card ending in 0123 is for non-fixed expenditures. All our receipts are sent to Receipt-Bank, which is synced with XERO. - reconcile bank accounts each month - setup inventory management - loan interest - P/L statments - Setup up reconciliation rules Must be finished by 10th of each month Approx 300-400 receipt/bank statement rows need reconciling each month. In XERO, every transaction must be matched with a receipt from Receipt-Bank or reconciled from a bank statement row.
I need a data entry operator who is proficient with intermediate level data entry tasks in spreadsheets. The primary task will involve entering data from digital files like PDFs and Word documents into spreadsheets. Key Responsibil...entry tasks in spreadsheets. The primary task will involve entering data from digital files like PDFs and Word documents into spreadsheets. Key Responsibilities: - Accurately inputting data from digital files into spreadsheets. - Using formulas and sorting data within spreadsheets. - Ensuring the data is entered correctly and consistently. Ideal Skills and Experience: - Proven experience with spreadsheet data entry. - Proficient in using formulas and sorting data. - Attention to detail and high accuracy levels. - Ability to work efficiently and meet ...
I need a seasoned Excel Macro developer to help me create a macro to automate repetitive tasks and generate daily reports. Key Requirements: - The macro needs to be compatible with Excel 2016, as this is the primary version I'm working with. - I'll need to run the macro daily, so it has to be stable and reliable for consistent use.
We are seeking an Amazon virtual assistant to set up our online store. Responsibilities include product listings, inventory management, and optimising sales. Project-based with potential for ongoing collaboration. Compensation negotiable.
...costume inventory and track its condition and rental history. Key Features: - Manual entry for check-in and check-out processes, with a search function for easy access. - Inventory tracking: A system that allows us to track and manage our costume inventory easily. The system must include a way for me to search a parent costume title (the character name) and check out all subsequent pieces associated with the parent costume individually - Damage and repair tracking: The system should allow us to note down any damage to the costumes and also track their repair status. - Rental history records: It should be able to keep track of the rental history of each item in our inventory. Please only apply if you have experience working with Airtable and have worked on s...
I'm seeking an experienced MS Excel specialist for a freelance data analysis job. Key Responsibilities: - Execute thorough data analysis using Excel. - Generate actionable insights from the data. - Prepare and present reports based on findings. Ideal Candidate: - Proficiency in MS Excel. - Proven experience in data analysis. - Strong analytical and problem-solving skills. - Excellent attention to detail.
I need a meticulous and detail-oriented freelancer to assist with numerical data entry for the purpose of data analysis. Key Requirements: - The data you'll be working with is in a digital format, mainly in Excel and CSV files. - You will be responsible for accurately entering this numerical data. Ideal Skills and Experience: - Proficiency in Excel and data entry. - Experience with numerical data analysis. - Attention to detail and accuracy. - Ability to work with large sets of numbers efficiently.
...and intangible assets, as well as financial assets. - The Ultimate Goal: The primary objective of this project is to implement robust asset management practices via a comprehensive depreciation forecast. I'm seeking a professional with: Creating a excel spreadsheet that i can download my asset register into and then have the worksheet calculate future annual depreciation say to 10 years. But also allow the ability to have the individual assets to be revalued either an increase or decrease in the original asset cost. This would mean the excel sheet would need to be able to take into account prior accumulative depreciation and adjust in the year we are currently reporting in. The attached file is current assets as at 30th June 2023. No depreciation has ran fo...
I'm in need of a freelance job, specifically requiring assistance with Excel. This project is tailored for someone with experience in the following areas: - **Excel Expertise**: I'm looking for someone who is proficient with Excel, especially in handling data analysis tasks. The ideal candidate should be comfortable with manipulating large data sets and extracting key insights from them. - **Data Analysis Skills**: A strong background in data analysis is crucial. You should be able to interpret data, identify trends, and provide meaningful conclusions based on your analysis. - **Attention to Detail**: As this job involves working with data, high attention to detail is a must. The ability to spot errors or irregularities in data sets is crucial to the succe...
I'm in need of a skilled accounting professional who can seamlessly handle a variety of accounting...bookkeeping, financial analysis, and tax preparation. Key Responsibilities: - Timely and accurate bookkeeping: Keeping track of all financial transactions. - Perform financial analysis: Analyzing financial data and creating financial models to support decision-making. - Tax preparation: Preparing and filing tax forms in a timely and accurate manner. Ideal Skills and Experience: - Proficient in Excel, Tally Prime, and Zoho Books. - Strong understanding of bookkeeping, financial analysis, and tax preparation. - Prior experience with daily accounting tasks. - Excellent attention to detail and organizational skills. - Strong communication skills and ability to work efficiently an...
...an existing Excel calculator into a web-embeddable format for integration on our website. The calculator should perform basic arithmetic operations and allow user input for the calculations. At the moment the user has to imput the item being stored and the size of the shed and it will tell them how much it can store of that item. We want this reversed and the user will put in the item they want to store and how much they want to store and it will calculate the size the shed will need to be. Key Requirements: - Convert an existing Excel calculator to a web-embeddable format - Ensure it performs basic arithmetic operations - Allow users to input values for the calculations - Optimally integrate the tool within our website Ideal Skills and Experience: - Proven experience ...
...requires implementing product and service selling capabilities in one robust solution. My requirements are as follows: • Skillful Development & Design: I need an attractive, user-friendly, and professional-looking Shopify website to showcase more than 100 various products and services. • No Inventory Management: Although our offerings are plentiful, there's no need to integrate an inventory management system. The focus lies in striking design and seamless user experience, rather than back-end inventory tracking. Ideal Skills and Experiences: • Extensive Shopify website design and development • Adept with product and service integration • Excellent understanding and experience with e-commerce websites. Your extensive portfolio s...
