Excel macros extraction data jobber
I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with complex data sets. The project wil...
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
I have a data entry task that involves inputting text data into a digital format (e.g., Excel, Word). The primary goal of this task is record keeping. Key Points: - Data Type: The task involves handling text data only. - Data Source: The data will be provided in a digital format. - Task Goal: The primary objective is to maintain records in a systematic way. Ideal Freelancer: - Proficient in Text Data Entry: The ideal freelancer should have experience with accurately and efficiently entering text data. - Familiarity with Excel/Word: Proficiency in using Excel and Word is necessary for the task. - Attention to Detail: Given that the task involves record keeping, the freelancer should have good attention to detail ...
I'm in need of a professional who can build a tool that scrapes product data from Walmart and exports it into an Excel spreadsheet. Key Requirements: - Develop a web scraping tool specifically for Walmart website - Extract essentials (price, upc, title) Skills and Experience: - Proficiency in web scraping using Python, Scrapy, or similar tools Please let me know your availability and estimated time for completion. This is an urgent project, so a quick turnaround would be highly appreciated.
Description: Seeking a freelancer to find and verify the contact information (email and mobile number) of specific job titles at a list of companies. We will provide the list of companies and if possible the name of the person we would like to speak with, just need for you to track down the email address and phone number. Responsibilities: • Research and identify the correct person in each company based on the provided job titles. • Find and verify the email and mobile number of the identified person. Requirements: • Strong research skills and attention to detail. • Proficiency in using online tools and databases for contact information search. • Excellent communication skills. • Strong web scraping/crawling skills. Need to understand how to obtain this inf...
I'm looking for an experienced professional to create a user form macro in MS Project Professional. The macro should have the following capabilities: The key functionality that the macro should have is the ability to filter the project based on selected criteria in the user form, including: - Project Phase: This is a custom field, or ...custom field, or Text6 - (And) Custom Look-Ahead Formula's for 15, 30, & 60 day look-aheads. See attachment but the end user will select one of the three look-ahead options. For the Look-Ahead formula, it should be defined as: IIf(([Start]<([Status Date]+15, 30, or 60) And ([% Work Complete]<100))). It's extremely critical that the candidate has strong proficiency and understanding of MS Project macros, logical formulas,...
...estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experie...
I'm seeking help with creating line charts in Excel. My dataset is small but involving multiple data series. Requirements: - Generate line charts from provided multi-series data - Ensure the charts are clear and visually engaging - Basic understanding of trendlines and data labels would be a plus, though not mandatory Ideal Skills: - Proficiency in Excel, with a focus on charting - Prior experience working with complex, multi-series datasets - Strong attention to detail and an eye for creating visually appealing charts
Vennligst Registrer deg eller Logg inn for å se detaljer.
I'm in search of a robotics expert with advanced experience in working with Vex V5 parts. The goal of this project is to build a robot that strikes the right balance between speed and strength, specifically for a high school robotics competition. Key Responsibilities: - Building a competitive robot that can excel in a high school robotics competition - Optimizing the robot for a balance between speed and strength Ideal Skills: - Proficiency in working with Vex V5 parts - Previous experience in high school robotics competitions - Strong understanding of robot design principles Communication for this project is crucial, and I would prefer to have in-person meetings to discuss progress and updates. Please consider that you must be able to meet in person in Connecticut west ha...
...professional to assist me with translating my bank transactions from PDF format into a spreadsheet. My accountant needs this data to be organized and easily accessible. Tasks for the freelancer include: • Extracting transaction information from my downloaded PDF bank statements • Compiling this data into an Excel spreadsheet • The project will need to include the date, transaction description, transaction amount, resulting account balance, and transaction category The ideal candidate needs: • Strong attention to detail • Proven experience working with both PDF and Excel files • Fluent in English for effective communication Expectations: • Maintain rigorous data accuracy • Finished product will closely re...
I need an expert to create a comprehensive Excel report and sheet using the 7QC Tool. The main purpose of this project is to analyse process data, identify quality problems, and improve process efficiency. Key Project Details: - The Excel report and sheet should incorporate data analysis, financial calculations, and performance metrics. - The type of data to be stored in the Excel sheet will be sales data, employee information, and inventory records. The ideal freelancer for this job will have a solid understanding of the 7QC tool, advanced Excel skills and knowledge in data analysis. Experience with managing sales data, employee information, and inventory records within Excel is highly beneficial.
Como estas me gustaria cotizarte la creacion de un plugin de wordpress modo calculadora, tengo diseño de como debe verse y el documento con macros en excel que deberia de replicarse para realizar los calculos en el plugin. La idea es que el plugin es que desde la base de datos se alimenta una calculadora (Externa) y esa info se la pueda exportar como un PDF. Debe haber una seccion para alimentar la base de datos (Interna) que ya esta medio avanzada en php.
Looking for someone to engineer a shared to-do spreadsheet in Microsoft Excel that supports real-time collaborative editing for our team. The successful candidate should have: * Advanced Excel skills; * Experience creating custom spreadsheets for project management; * Understanding of user permissions in Excel with the aim to allow full control access to every team member; With your help, we'll revolutionize how we tackle tasks as a team. The ideal freelancer for this project should be prepared to propose and implement a solution promptly. Familiarity with Microsoft Teams is a plus.
I need a skilled Arabic typist to enter data from PDF, into a single excel table .
I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of vendor pricing data.
I'm seeking a skilled Excel developer to help me create a tracking system. Key Requirements: - The system should monitor the month over month membership growth for our community PCPs. - The PCP targets should be identified by name and location. Please note that this needs to be completed as soon as possible. Ideal skills for this project: - Strong proficiency in Excel and data tracking - Experience with creating dynamic systems in Excel - Attention to detail to ensure accurate tracking This will be a key tool for our organization moving forward, so I'm looking for a freelancer who can deliver high-quality work efficiently.
...include: - Extracting 13 individual prescriptions from a standard PDF document - Saving each prescription as a standalone PDF file The end goal is to have these individual prescription files sent to my email address, from where I can further forward them in an encrypted manner to an organization. Ideal skills and experience for this project: - Proficiency in PDF manipulation and extraction - Experience in automated data processing and file handling - Understanding of email automation and attachment handling - Familiarity with encryption protocols would be a plus Please provide a brief overview of your approach to this project along with your bid. I'll be happy to provide any further clarification as needed. All of this has to be kept confidential, as I could lose...
...and Raspberry Pi is highly beneficial, though not strictly compulsory. - The algorithm should be versatile enough to function accurately in varying lighting conditions, both indoors and outdoors. Hence, a deep understanding of image manipulation and light conditions is required. By engaging in this project, you would leverage your coding skills to build an intricate system that can handle text extraction efficiently and effectively. This is not merely an exercise in technical depth but also creative problem solving. Make sure to highlight any relevant experience in your bid to improve your chances of selection....
I'm looking for a freelancer to create a line graph in Excel. This graph will be utilized for report analysis, showcasing the trend for a single data set. Key Responsibilities: - Develop a line graph in Excel - Present the data trend effectively - Ensure the graph is tailored for report analysis Ideal Skills and Experience: - Proficiency in Excel, particularly in creating graphs - Prior experience in crafting visuals for reports - Ability to convey data clearly and effectively This project specifically does not entail comparing different data sets, as it solely focuses on illustrating the trend of a single set. The ideal candidate will deliver a polished graph that can be seamlessly integrated into a report.
Need an Excel expert to create a complex forumula to get desired results from big set of data. Budget is placeholder/estimate. final amount will be discussed during work.
...brief overview of what I'm looking for: - **Data Extraction**: I'm looking for a full database extraction - including names, email addresses, subscription dates and any engagement metrics, if available. - **Data Compilation**: I would prefer to receive the compiled list in a Google Sheets document. **Ideal Skills and Experience:** - Proficiency in WordPress and email list management. - Previous experience in data extraction and compilation. - Strong attention to detail and ability to ensure data accuracy. - Excellent communication skills to keep me updated on the progress. Please note that I'm not looking to apply any specific filters or criteria to the data at this time. I'm simply looking for a comprehens...
I'm looking for a skilled individual who can help me scrape data from a dead mobile app (has both ios and android versions). The database of the app is of particular interest, however, I am not sure of the specifics such as the Database Management System (DBMS) it uses. Key Points: - Extracting data from the database of a defunct mobile app - Unspecified Database Management System (DBMS) - will require exploration and identification Ideal Skills and Experience: - Proficiency in data scraping and extraction - Strong background in database management and familiar with multiple DBMS - Resourcefulness and ability to work with minimal information Please get in touch if you're confident in your abilities to handle this task.
I'm seeking a skilled professional to develo...specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creatio...
I have multiple Excel spreadsheets containing contact information, and I need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and ...
...looking to add several Virtual Assistants (VA) to our team who can assist us with various tasks, including social media posts, research, data entry, and more. We are seeking individuals with a strong background in data entry, Google Drive/Sheets, and similar responsibilities, as outlined in our LinkedIn job posting. While the tasks themselves are relatively straightforward, it is important to note that this will be ongoing, daily work for the foreseeable future. If you have a proven track record of delivering high-quality work, and maintaining consistent performance, we encourage you to apply. Key qualifications and requirements for the role: - Proficient in data entry and experienced with Google Drive/Sheets. - Demonstrated reliability and consistency in previou...
As discussed I have delivered the excel workbook. Thanks!
...floorplans (if available), and location. This data should be compiled and organized into a spreadsheet for easier analysis and comparison. This is not Zillow or any traditional UK or US based portal, the website is specifically a portal focusing on luxury items Key Requirements: - Extraction of specific information from residential properties only - Data to be collected from a well-known property portal - Compilation and delivery of data in a spreadsheet - Inclusion of property description, price, number of bedrooms, bathrooms, images, videos (if any), floorplans (if any), and location - Images to be put into separate folders named after the property they are from Ideal Skills and Experience: - Experience with web scraping and data extraction...
I'm in need of a professional who can build a tool that can extract data from LinkedIn. The data I'm interested in includes: - Contact information (email address, phone number, etc.) - Profile information (name, job title, etc.) - Connection network (connections, mutual connections, etc.) I'd like the extracted data to be conveniently structured in a CSV (Excel spreadsheet) format. The primary use of the extracted LinkedIn data will be for lead generation. The ideal candidate for this project should have: - Expertise in web scraping and data mining, particularly with LinkedIn - Proficiency in data handling and structural organization - Proven experience with developing tools for lead generation - Strong communication ski...
I'm looking for a web scraping expert to carry out daily data extraction. The websites to be scraped will contain text content, along with images and video. I may need the scraping program to be written such that it can be conducted on a daily basis. to update new articles We are going to be scraping around 50 websites for the first project Key Requirements: - Profound experience in web scraping and automation tools. - Strong problem-solving skills to deal with any potential web structure changes. - Creating and maintaining a database of the scraped data would be a plus. Please provide your quote, along with the tools you intend to use for this process and your relevant experience. Looking forward to your bids. Ideally we want this done in PHP.
Tengo un software de facturación al que se le pueden importar facturas en lote subiendo un Excel con un formato concreto de filas y columnas para que sea capaz de reconocerlo y generar las facturas de forma correcta. Necesito poder hacer esto de forma automática, es decir, teniendo un archivo de origen xls en un formato, poder extraer los datos para montar otro archivo xls con el formato que necesita el software de facturación para leerlo correctamente.
We are an Ecommerce company dealing with variety products and we are looking for a...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
...appears below. if you can help me with explanations and about which package to buy from you that would be perfect, thanks! 1) Set up the Java project and the necessary libraries for computer vision and machine learning. 2) Capture video input from a camera. 3) Pre-process the video frames to enhance th quality and reduce noise. 4) Use computer vision techniques (like image segmentation and feature extraction) to detect and recognize sign language gestures. 5) Translate the recognized gestures into text. 6) Display the translated text in the user interface....
Data entry work from home part Tim e
You need to build a power app for a business process of onboarding, offboarding customers. There is a data...customers. There is a database of the customers with specific users db that has access and approve a checklist. We need it on a sharepoint portal and emails are automated for every action. It is a simple process of adding a user, give them a checklist, customer completes all actions, there is an internal admin who confirms the checklist and there is a progress to track. Will provide a dummy of excel sheet, expect 3-5 screens across onboarding, offboarding, admin and customer login. Ideal Skills: - Proficiency in Power Apps, Microsoft Power Automate. - Expereince in MS dataverse, power platform - Ability to grasp business processes and convert them into efficient digital ...
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
...rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in using Instagram for business research - Experience in lead generation - Bonus: Familiar with the nightlife industry...
...URLs. The emails need to be in Excel format. What I Need in Excel: - Name of the person - Email - Location - Designation Procedure: - I shall enter sales navigator ulr where multiple leads in pagination format displayes. - Software will pick each person url and find out his email (personal/professional) - Add that record along with above fields in excel sheet. Make sure software must not stuck, and i shall clear the payment after testing couple of days. Ideal Skills: - Proficiency in Python. - Experience in web scraping, particularly with LinkedIn URLs. - Familiarity with data manipulation in Excel files. This project is ideal for someone with a strong background in Python and web scraping. The successful freelancer will help me automate the ...
...proficient Excel expert to build a multifunctional sales proposal tool. The core functions include: - Entering Data: The tool should accommodate efficient and easy data entry from multiple source files. If this can be automated that would be preferable. - Sales Calculations: The tool must have the ability to perform various sales calculations and convert source files from multiple currencies to GBP - Templates: I require outputs to integrate into existing Excel templates for generating client proposals, producing invoices, and confirming projects. - Automation: Desired features include automatic data sorting and automated calculations to streamline and simplify tasks. - I have example files I can share which can form basis of design. Ideal candidate...
I require a professional freelancer with extensive experience in Microsoft Office 365 to develop a set of Word, Excel, and PowerPoint templates for my business. Key Details: - Each template needs to incorporate our company's logo, color scheme, and slogan in a visually appealing manner. - I am looking to have 1 to 3 distinct templates created for each platform – Word, Excel, and PowerPoint - so I need someone versatile and creative. Ideal Skills: - Strong knowledge of Microsoft Office 365 - Graphic Design Skills - Branding Experience Please provide some examples of the branded content you have created in the past, especially any corporate identity materials. Looking forward to your bids. Thank you.
I'm seeking an Excel expert to help with a data analysis project. The spreadsheet is set to a high level of complexity, requiring a mix of data analysis and data cleaning tasks. Key Tasks: - Data Analysis: I need someone who can set up the spreadsheet as a dashboard, and perform data analysis tasks. - Data Cleaning: You need to handle the data cleaning part of the project. This involves removing duplicates, handling missing values, and standardizing data formats. The ideal professional for this job will be experienced in: - Advanced Excel functions, including data analysis and building dashboards. - Proficient in data cleaning techniques. - Able to work with complex data sets. The project wil...
I need to extract text and tables from a series of PDFs and convert them into an Excel file. The main requirements for this project include: - Extracting text: The texts from the PDF files need to be carefully extracted and placed into the corresponding cells in the Excel sheet. - Tables: There are some tables within the PDFs that need to be accurately reproduced in Excel. The Excel file must preserve the original formatting of the text and tables, so as to maintain the integrity of the data. The PDFs are only in English, so no complex multilingual extraction is required. Ideal Skills: - Proficiency in PDF to Excel conversion - Strong attention to detail - Ability to preserve original formatting in Excel - Excellent English lan...
I'm in need of a skilled professional who can help me generate leads. Unfort...some important details in the initial questions. - I'm open to both B2B and B2C leads, so I need someone who can handle both categories effectively. - The industry I target is quite broad, including but not limited to Technology, Healthcare, and Real Estate. Hence, I need a freelancer who is experienced in lead generation across various sectors. - Lastly, the leads should be provided in an Excel spreadsheet. This is crucial for my further processing and follow-up. Your previous experience in generating and categorizing quality leads across different industries will be a huge advantage. Proficiency in understanding both B2B and B2C lead generation methodologies is also important. Looking f...
I'm looking for an SAP B1 expert to help me extract critical data for a migration project. Your main tasks will include: - Extracting data from SAP B1, including customer data, inventory data, sales data, purchase orders, and financial data such as journal entries. - Ensuring the data is extracted in Excel format for ease of handling and migration. The successful freelancer should have: - Extensive experience working with SAP B1 and extracting data from it. - Proven track record of successful data migration projects. - A strong understanding of how to handle financial data, especially journal entries, within SAP B1.
...Development: Create coherent and effective style guides and design systems. - User Experience Optimization: Improve the usability of existing websites to maximize user satisfaction. What We Offer: - Opportunity to work on varied and innovative projects. - Collaborative work environment focused on professional growth. - Remote work flexibility. Required Qualifications: We are seeking specialists who excel in one or more of the listed areas, able to demonstrate skill in translating user insights into designs that clearly communicate and effectively solve problems. Proven experience in UI/UX projects and a portfolio showcasing your skills and success are essential. How to Apply: If you are a UI/UX Design Specialist ready for challenges that drive your creativity and technique, we...
...system in the platform. Customer will buy credits with their credit / bank cards and the credits will be deposited. They will spend their credits by requesting file processes. Also, there will be a shop section in the platform. Customers will be able to buy already uploaded files by admin. Customers shall be able to view their expenses and deposits as a list and that table should be exportable to excel. There will be 3 information pages which customers will be able to search and find for specific information. After you contact, I will explain these pages in detail. For all these functionalities corresppnding admin panel pages are needed. For example: pricing page for file processings, upload page for file requests, upload page for shop, a page to add new vehicles to the syste...
We are looking for a skilled freelancer to assist us with a high-speed web scraping project. Our existing web scraping scripts have been developed and deployed, but we need to optimize the scraping process to achieve faster data extraction rates. Responsibilities: Optimize existing web scraping scripts for speed and efficiency. Deploy and manage web scraping scripts on platforms such as Scrapy Cloud, Apify, AWS Lambda, or Azure. Implement techniques to ensure high-speed data extraction (e.g., parallel processing, distributed crawling, efficient request handling). Monitor and troubleshoot scraping processes to ensure uninterrupted operation. Collaborate with our team to understand project requirements and adjust scraping strategies as needed. Requirements: Pro...
I'm in need of an experienced data scraper that can help me in extracting data from Yellowpages of Malaysia, Thailand, Japan, and Indonesia. Key Details: - I require a full listing of all businesses from various sectors within the mentioned countries. This includes but not limited to Restaurants, Hotels, Clinics, and Retail Stores. - The extracted data should be well-organized, including data such as business names, contact information, and addresses. Skills/Experience: - Proven track record in web scraping with a focus on Yellowpages. - Familiarity with the Yellowpages platforms of Malaysia, Thailand, Japan, and Indonesia. - Capability to handle large data sets and deliver the information in an easily usable format. - A high level of accuracy in ...
...following are the steps:- a) Excel file containing Product url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MSRP is appearing for variation, then it should fetch and enter that number. It is very easy and simple work. Bid only if you can do within next 24 hours. See the attached excel fil...