Data validation vlookup excelJobs
...produktfeed-import til Excel via Make Projektbeskrivelse: Vi er på udkig efter en dygtig freelancer med erfaring i automatisering og databehandling, som kan hjælpe os med at automatisere importen af forskellige produktfeeds fra flere leverandører direkte ind i et Excel-ark ved brug af automatiseringstjenesten Make (tidligere Integromat). Opgaver: Opsætning i Make: Opsætte automatiserede workflows i Make, der importerer produkter baseret på specifikke EAN numre fra en liste, vi har tilgængelig i en særskilt fane i Excel-arket. Dataselektion: Sikre, at kun produkter, der matcher EAN-numrene på vores liste, bliver importeret. Dataimport: Automatisk import af følgende produktdetaljer til Excel: ...
Hej, Jeg har behov for en Expert, som kan udvikle en kalender for mig. Jeg har et rengøringsselskab, hvor vi få udleveret et kalender fra vores kunder. Alle kunder har forskellige fridag, men de fleste har helligedage som lukkede også er der enkelte der har ekstra feriedage, så de skal også indtastes. Herudover vil jeg indtaste, hvor menge timer medarbejderne har enkelte dage, så jeg kan beregne hvor timer der skal udbetales. Eksempelsvis har en kunde 20 arbejdsdage, hvor medarbejderen arbejder dagligt 10 timer, så i alt skal der udbetales 200timers løn.
I have an invoice template, i need to add a second page to it that have instead of the columns Beskrivning Antal Enhet à pris Moms Moms kr Belopp should have 10 columns. I have attached the invoice template. So i need a second description page to this template.
Design or formulate the financial analysis for a self storage project in order to ascertain its viability.
Jeg har brug for en ny hjemmeside Bare bygge den Internetbutik Skal sælge gavekort på min webshop på shopify og have betalingsmodul fra pensopay på samt 4 API opkoplinger diverse social media integration samt adwords og trustpilot, Excel fil fra bestilling skal sendes til produktionssted
Jeg skal ha lavet et database program hvor jeg kan indføre forskellige data hver dag. Skal helst kunne køre som app på både android og ios, ios i første omgang Jeg skal selv kunne skrive og lave nye data der skal indføres. Der skal være et pænt layout og være meget nemt at gå til Der skal være en backend, hvor man selv kan tilføje og rette i de ting der skal indtastes. Der skal ikke være begrænsninger for hvor mange indtastninger man kan lave Alt skal kunne konverteres og udskrives i pdf og excel Der vil være småting der skal ændres og tilføjes løbende, så det skal være en der kan arb på projektet noget tid
Skal have lavet en opgave i Regnskab. Skal laves på excel.
På side 1. (ark – ’kontobevægelser’) er der i kolonne D indsat beløb (kr.), - pkt. C Værdien i pkt. C (side 1) ønskes overført til pkt. C (side 2) - arket ’2017’. Der skal indsættes en formel i pkt. C, arket ’2017’ (side 2) som overfører værdien fra pkt. C (side 1) til pkt. C (side 2). Dette gøres ved: • Det aktuelle ark som værdien i pkt. C (side 1) skal overføres til findes ud fra datoen i pkt. B (side 1). Værdier fra kalenderår 2017 overføres til arket ’2017’. Værdier fra øvrige kalenderår eksporteres til de respektive ark/kalenderår. Dvs. værdier for kalenderåret 2016 indsættes i ark &r...
Vi har brug for hjælp til at opbygge i MS Excel rapport, som via Jetreport henter debitor / salgs data fra Microsoft Dynamics NAV 2009 R2 - SQL database.
Hej, Jeg leder efter nogen til at løse et par matematikopgaver. Opgaverne er vedhæftet og mit budget fremgår af dette projekt. Opgaverne skal løses i et regneark (gerne Microsoft Excel). Deadline er 5 dage efter projektet er uddelt. Se nedenstående vedhæftninger.
Hej, jeg søger en som kan lave et design til et træningsprogram. Jeg har et design som I kan gå udfra, når I kontakter mig på mail. Håber i kan hjælpe. Mvh. Martin Nielsen
Vi ønsker at få en pris på at få oversat den engelske LOD manual inkl. excel workbook til dansk.
Vi ønsker at få en pris på at få oversat den engelske LOD manual inkl. excel workbook til dansk.
project for dangersystem dangersystem dangersystem
Jeg har vedblivende arbejde relateret til vores tidligere projekt 'Application that can upload excel sheet to sql table'
Solve excel problem using excel solver
Jeg skal lave en prissammenligningsside. Jeg har samlet alle priser hos en forhandler og skal nu have fundet de samme produkter hos andre forhandlere. Jeg har lavet et excel ark hvor jeg liste alle URLs til den primære forhandler. Det er så jeres opgave at gå ind og finde det tilsvarende produkt hos de andre forhandlere og indsætte links i Excel arket. For at produkterne er de samme skal I tjekke at billedet er ens. Hvis I ikke kan finde det pågældende produkt skal der bare skrives 0 i cellen. Se vedhæftede fil for hvordan templaten ser ud. Det drejer sig cirka om 1000 produkter og 10 forhandlere, der skal tjekkes
Jeg har vedvarende arbejde relateret til vores tidligere projekt ' Looking for a user-interface for Excel'
Take excel spreadsheet & upload via talend to REST service. Might have to work via multiple sheets. Rory to pass on details.
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forwar...
I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.
...Responsibilities: Write a Python script using PyAutoGUI to control keyboard inputs specifically tailored for interaction with a Firefox web page. Design the script to switch focus to the Firefox browser automatically and accurately press the designated "Yes" and "No" buttons. Ensure the script can be adjusted or configured easily to work with different web page layouts. Provide robust error handling and validation to ensure the script operates reliably under different conditions. Create a clear documentation on how to set up and use the script, including any necessary installation of additional software or libraries. Requirements: Proficient in Python with a strong understanding of automation scripts, specifically with PyAutoGUI. Experience in developing aut...
I'm seeking a proficient individual who can efficiently execute data entry tasks. The primary task will be the accurate transcription and input of both numerical and text-based data from scanned documents into Excel spreadsheets, requiring: - High attention to detail for accurate data entry - Ability to transcribe both numerical and text data - Proficiency with Excel and its functionalities - Previous experience with data entry and analysis from scanned documents Your knowledge and precision in data entry will play a crucial role in ensuring data accuracy, which is integral to the success of this project.
I'm seeking a freelancer who is adept at typing for a task that involves transcribing handwritten notes into Excel. The legibility of the handwriting is average, so this job demands patience, careful observance, and excellent data entry skills. - Your task would be to transcribe the data from handwritten notes into an Excel file. - The content you'd be dealing with primarily includes text. I'd prefer individuals who have previous experience in data entry, especially tasks that require extracting data from handwritten sources, and are proficient in using Excel. Attention to detail is a must, as accuracy is paramount in this job. Your ability to decipher moderately legible handwriting would be a great advantage. Please bring...
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valu...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - Expertise in Amazon SEO and PPC ads, with a specific focus on product listing optimization. - Experience ...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...
Vær venlig at Tilmelde dig eller Log ind for at se detaljer.
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of th...
...financial losses and enhance security. Need to detect a submitted computer generated receipt in pdf if it is a tampered or real one. There are chances like in the computer generated bill some people can change the amount, name, address sections and submit. This model should able to detect all those tampered PDFs with minimum false positives. Do metadata analysis QR code reading in the receipt and validation Key Responsibilities: - Develop a fraud detection algorithm using Python. - Test and tune the model for maximum accuracy. Ideal Experience and Skills: - Proficient in Python programming. - Proven experience in creating algorithms, preferably in fraud detection. - Ability to demonstrate relevant past work. Applications without showcasing relevant past work will not be ...
I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...
As a client, I am looking for a skilled developer who will create a custom webpage for conducting polls. The key functionalities I need include: 1. Email Verification: The webpage should limit voting to one time per institutional email address. If an invalid email...crucial for the freelancer to have experience in creating such an interactive visual display. 3. Commenting Feature: I want users to be able to create notes as comments under the poll. This gives people a space to share thoughts or elaborate on their vote. The ideal freelancer for this job will have a strong background in web development, with specific experience in real time data visualization and email validation techniques. Knowledge about implementing commenting functionalities on a webpage will also be hig...
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based researc...
