Excel extract data list jobs

I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.

Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time rep...

I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.

As the project owner, I am looking for a talented individual who can handle two crucial tasks in Excel: 1. Adding advanced functionality with IF, VLOOKUP, and INDEX MATCH formulas. 2. Implementing conditional formatting. To be successful in this project, you should have: • Proficiency in Excel's advanced functions and calculations • Experience with customizing Excel using conditional formatting • Attention to detail and the ability to execute tasks accurately. Your primary task will be to help me improve Excel's current functionality by implementing the advanced functions mentioned and customizing my Excel using conditional formatting. Your deep understanding of Excel will be crucial to successfully carrying out these tasks...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly i...

I'm in need of an experienced data scraper to extract product information from multiple websites. The scope of this project is not set and will be contingent on your proven capabilities. As such, your application should ideally include: -Prior experience in data scraping -Examples of past work, specifically in the area of data scraping Here are some key project details: -Data Required: Only product information -Websites: Unspecified. Be ready to scrape data from multiple sources -Experience: Proven track of successful data scraping projects Please apply if you're confident in your abilities of scraping accurate, relevant and recent product information.

Looking for a savvy surveyor who can get to the crux of the ready mix concrete market in Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requireme...Varanasi, India immediately. I need an in-depth study on: - Current market size & its growth trends - Rival firms & their market share Key requirements include: - Compile a detailed report, covering your analysis & proposing actionable strategies. - Provide raw data in Excel or CSV format in addition to the report. Prior experience in market surveying and a knowledge of the construction industry are big pluses. Your ability to work fast while maintaining accuracy is paramount. Let's revolutionize the Varanasi ...

I need help with simple copying and pasting tasks from online directories. The data needs to be organized by category. The primary task includes: - Copying data from various online directories - Pasting the data into an Excel/CSV file - Organizing the data by categories Ideal skills: - Excellent attention to detail - Proficiency in data entry and Excel/CSV - Understanding of data categorization The task is straightforward and doesn't require any complex skills. I am looking for someone who can deliver accurate results in a timely fashion.

I need a big team who can process a huge lot of images... I have collected 30k recipe images and now the data size is too big so I need you to delete useless images and rename ONLY 1 image per folder. the work is effortless but MANUAL WORK Step 1 - Download and extract systematically from ZIP Step 2- Delete (80%) + Rename (only 1) Step 3- Upload the data back in ZIP to drive. BID PER 500 FOLDER Total folders = 30,000 current images per folder = 40-80 Images to keep per folder = 10-14 Expected team size needed = 10-50 people (I have 12-14 days total) Only reliable and serious candidates should apply

...and a JSON file (Google Vision API output) as input. Parse the JSON file to extract subtitle information and their corresponding timestamps. Use the subtitle timestamps to segment the video whenever the subtitles change. Save the segmented video clips with a naming convention: segment_[index]_[text].mp4, where [index] is a sequential number and [text] is the corresponding subtitle text. Ensure the script is well-documented, efficient, and handles potential errors gracefully. Provide clear instructions on how to run the script and any dependencies required. Requirements: Strong proficiency in Python programming. Experience with video processing libraries such as OpenCV or MoviePy. Familiarity with parsing JSON data. Knowledge of working with file I/O operations. Ability t...

I have excel table with project tasks by dates start and end and duration. I want to change it to project table. Preferred microsoft format.

I urgently need a professional who can input textual data onto an Excel sheet in a visually appealing and easy-to-understand way. Key Responsibilities: - Representing textual data in a clean and organized manner within an Excel sheet. Ideal Candidates Should Have: - Proficiency in Excel, particularly in handling and presenting textual data. - Strong attention to detail, ensuring that all data is correctly input. - Ability to work quickly and efficiently, as the project has a tight deadline. If you have experience with data representation and can work fast, please apply.

I'm seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization us...

I need an expert in web scraping, either in Python or by utilizing Google Chrome extension, to extract text data from a particular website. Should be delivered within 3 hours. The scraping is a one-time task, not requiring routine updates, and the extracted data needs to be saved in an Excel file (or CSV). This will be hidden behind a login wall - so I suggest that the Python script will go to the website and then wait one minute, where I will manually log in. Ideal Skills and Experiences: - Proficiency in Python for web scraping - Experience with scraping text specifically - Ability to deliver the required output in a CSV format

I require the expertise of a skilled data scraper who can quickly retrieve text data from a specified website. The site in question is I need the following specific information delivered in Microsoft Excel Format: - Country Name - Grand Lodge Name - Website address - Email address - Phone - Address - Grand Master name (if available) The ideal freelancer for this project would have significant experience in data scraping, particularly text data, and an understanding of the website's structure to retrieve the desired information effectively. Speed and efficiency are of the essence. Your ability to deliver this project promptly without compromising accuracy will win you this bid.

To give you a brief idea the data you are dealing with is for recipe ingredients and I need nutrition info for all those ingredients from USDA. I'm seeking a Python expert who can give me 100% accurate "mapped" data without duplicates or missing information. YOU WILL BE REQUIRED TO WRITE/SEARCH NEW script to modify my data in Excel sheets - I have 3 Excel files having a total of 50000 rows, These are ingredients from recipes, I need you to do the following tasks - (A) - Assign a new ingredient ID number to all non-duplicate Ingredients. (B) - Replace "Name of ingredients" with the newly assigned number in the whole file (C) - For all ingredients - search, get the FDC ID from USDA Food Central and save this info in a separate fi...

I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this tas...

I am in need of a Python script that can extract Amazon's official keywords and search terms, and update this information on a daily basis. This data includes keyword search volume, keyword competition, and top ranking keywords. Key requirements and responsibilities include: - Developing a Python script to extract Amazon's official keywords and search terms - Ensuring the script is capable of updating this data on a daily basis - Retrieving keyword search volume, keyword competition, and top ranking keywords - Aiming for improved product visibility, enhanced product listings, and optimized PPC campaigns The ideal freelancer for this project should have: - Proficiency in Python - Familiarity with web scraping and data extraction - Experience w...

I'm looking for a QuickBooks expert who ...essential. - Labor and Operational Costs: I require a detailed breakdown of labor and operational costs. This will be crucial in understanding our clinic's overall profitability and the net profit of each doctor. Ideal Skills and Experience: - Proficient in QuickBooks: Experience and expertise with QuickBooks is a must for this job. You should be able to navigate the software with ease and extract the necessary data for the cost analysis. - Cost Analysis Expertise: Understanding of cost analysis methodologies, particularly in a medical setting, would be highly advantageous. - Attention to Detail: Given the potential complexity of our operational and labor costs, a great attention to detail is required to ensure the analysi...

I'm in need of an experienced freelancer who can effectively perform data entry tasks involving financial data. While the specific type of data has not been specified -- it could range from invoices and expense reports to bank statements -- the chosen professional should exhibit versatility and aptitude in working with various forms of financial data. Key Requirements: - Proficiency in Excel: You'll need to be well-versed in using Excel for data entry tasks. - Background in Finance Data Entry: Experience or relevant knowledge in finance data entry is crucial. This ensures you can deliver accurate results. To apply, offer a detailed approach on how you would tackle this project. Also, provide evidence of your past wo...

Advance Excel work to be done urgently.

...highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the requi...

Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab

I intend to streamline the process of document submission and verification in relation to EDPMS entry and BRC, with a focus on customs or trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validati...trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validation purpose. Key Responsibilities: - Submission and verification of customs or trade-related documents - Verification and correction of any errors found in the documents Experience & Skills: - Experience in the customs or trade sector is essential - Proficient in Excel/CSV - Strong attention to detail and high accuracy in document handling - Previous exposure to EDPMS and BRC is...

I've already done most of the work in analysing ...Comprehensive Review: It's important that you review my analysis comprehensively and suggest corrections or improvements where necessary. - Final Financial Year Analysis: The analysis should cover multiple financial years, ensuring a comprehensive assessment of my trading performance. Ideal Skills and Experience: - Proficiency in Excel: The data prepared to do is in an Excel spreadsheet format, so advanced Excel skills are essential. However I also have a full list of my trades that is only in pdf. - Financial Analysis: A solid background in financial analysis and portfolio management is necessary for this project. The ideal candidate will have a keen eye for detail and the ability to provide...

As your assistant for this project, my job will be to type data into an Excel spreadsheet. However, I currently don't have specific information on what type of data (text, numbers, dates) you require. Additionally, I need clarification on whether you have any specific formatting needs for the data and if any calculations or formulas will need to be applied. Ideal Skills: - Proficient in Microsoft Excel - Precise and quick typing ability - Understanding of Excel formulas (just in case) Your prompt response to these questions will help ensure successful completion of your project. Looking forward to working with you!

...WhatsApp whenever new data is entered into an AppSheet application connected to Google Sheets. Key Requirements: Integration between AppSheet and Google Sheets is already established. Develop a mechanism to trigger notifications in real-time whenever a new entry is made in the Google Sheet through AppSheet. Create customizable message templates to populate WhatsApp messages with data from the newly entered form. Ensure secure and reliable communication between AppSheet and WhatsApp Business API. Implement error handling mechanisms to address any potential issues during data transfer and messaging. Technical Approach: Utilize the WhatsApp Business API to establish a communication channel between AppSheet and WhatsApp. Implement webhooks in AppSheet to detect new...

...architectural drawings in an impressive and articulate format. So, if you've got strong knowledge of residential architecture and experience with these software tools, you could be the perfect fit for this project. Your expertise is paramount for the success of my architectural drafts and interior designs. Individuals with a detailed-oriented mindset and the ability to think outside the box will excel in this project....

I'm intending to create an Excel roster to effectively manage the allocation of shifts, roles and skills within my organization. Key details I aim to competently track include: Example-if i select a product we are making that day it automatically populates how many people required for that product and when box is clicked it shows the names of people available that day. The names we can enter and remove has needed if employees leave or new employees arrive. - Employee Names: I want to record the names of each staff member in my organization. - Shift Management: I want to assure every shift for specific products has appropriate manning. Ideal Candidate: A freelancer who has experience with HR data management and Excel roster creation would be ideal for this tas...

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the porta...

For my expanding fashion business, I'm on the hunt for inspired and skilled fashion designers -- those who excel in creating both underwear, swimwear, and sleepwear for Womens. But, the real cherry on top would be a knack for lingrie designs. Key Requirements: - Ability to create unique, innovative designs that target different audiences - Proficiency in both trendy and classic styles. We value versatility! - Expertise in working within a monochrome and neutral color scheme Desired Skills: - Expert knowledge of fashion trends in underwear, swimwear and sleepwear - Exceptional creativity and innovation - Strong sketching skills with attention to detail With your help, we can revolutionize the market by producing designs that encapsulate both the traditional classics and...

I...professional who can adeptly manipulate and extract data from relational databases using Azure Data Factory for API endpoints. Key Requirements: - Solid understanding of Azure Data Factory tools and best practices - Expertise in data extraction and customization - Proficiency in multiple programming languages - Experience working with relational databases, cloud storage like Azure Blob Storage, and on-premises files - Proven track record of successful integration of different data sources using Azure Data Factory - Exceptional problem-solving skills The project involves handling an existing pool of databases constructed in a range of programming languages; hence, versatility is a must. If you are a resourceful individual who thrives ...

I'm seeking a meticulous data entry operator capable of transferring data from digital documents to an Excel sheet. This task involves: - Taking solely textual data from digital documents. - Conducting minor internet research and using ChatGPT when necessary to fully understand the instructions. - Accurately entering the required information on the provided Excel sheet. The ideal candidate for this job is one who is proficient in the use of Excel spreadsheets and has excellent attention to detail. Previous work experience in a similar data entry role is advantageous. This work is specifically in the context of creating content for product listings in e-commerce sites. So if you have specific experience in this area, that would be an ...

I require a freelancer proficient in excel to assist with data cleaning and sorting tasks for a range of diverse digital files. Your expertise in managing and optimising Excel spreadsheets will be invaluable and greatly appreciated. Key tasks will include: - Using Excel functions to clean datasets, removing discrepancies and inaccuracies - Sorting data into relevant fields and categories for easier access and analysis The optimal freelancer will have: - A meticulous eye for detail to ensure data accuracy - An understanding of Excel formulae and functions - Proven data cleaning and sorting experience - The ability to meet tight deadlines without compromising quality. Your primary role will be to untangle and streamline my Exce...

I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be ...

... ever-changing regulations, and the potential for errors can lead to stress and financial penalties. Introducing GCC TAX GPT- GCC TAX GPT utilizes the power of Generative Pre-trained Transformers (GPT) to become your intelligent tax assistant. Here's what it will offer: Automated Data Entry: GCCTAX GPT will be trained on vast amounts of tax data, enabling it to automatically extract relevant information from financial documents like receipts, bank statements, and investment records. This eliminates manual data entry, saving users significant time and effort. Personalized Tax Guidance: GCC TAX GPT analyzes a user's financial situation to generate personalized tax recommendations. It identifies potential deductions and credits, ensuring users claim...

As discussed I have completed the template for Home Team Workbook.

I'm seeking a home-based freelancer proficient in Microsoft Word, Excel, PowerPoint, Outlook, and Tally ERP 9 for a variety of tasks. Key Responsibilities: - Data Entry: Accurate, timely, and efficient data entry support is a core requirement. - Document Formatting: Assistance with formatting a range of documents, ensuring a professional and consistent appearance. Ideal Skills & Experience: - Proficiency in Microsoft Office Suite: You should have a strong command of Word, Excel, PowerPoint, and Outlook. - Data Entry: A proven track record in data entry, with a focus on maintaining a high level of accuracy and meeting deadlines. - Tally ERP 9: Experience in using Tally ERP 9 is preferred, but training can also be provided. - Organizatio...

...seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-frien...

...Key Project Details: - The PDF invoices I frequently deal with come in both scanned image and digital (text-based) formats. - The extracted data from these invoices must be: - Directly integrated into Sales and Purchase Invoice Module for further processing - Exported to Excel/CSV files - Directly integrated into accounting software Ideal Skills and Experience: - Proficiency in OCR technology - Strong background in invoice processing and automation - Experience with integrating software systems, particularly accounting and invoicing modules - Ability to work with both scanned image and digital PDFs - Proficient in data export to Excel/CSV files If you have a track record of successfully implementing OCR-based automation solutions and you�...

...goodbye to you!!!! **** ALL TASKS ARE STATED HERE ***** I am looking for EXPERT Porto theme Woocommerce builder. Install and Configure Porto WooCommerce theme for these site functions. I purchased this theme: SSL has been installed and configured for domain. 1. NEED A WOW HOME PAGE - floating/falling words/images - Extract codes from demo pages included in theme package a. See attachment for home page sketch which needs improvement b. Want the home page to fade in color like this page porto demo which is included in the WooCommerce theme c. The mantra of the site is: "Together We Soar" scrolls from left to right across heading d. Images of the Collection - Soaps

I require the expertise of a freelancer capable of securing a pre-existing mailing list. The list should contain the contacts for less than 1,000 podcast listeners, PREFERABLY AUSTRALIAN LISTENERS in the middle demographic, specifically engaged with news and current events. Key skills and experience: - Proven track record in data acquisition - Experience in media or entertainment industry is a plus - Understanding of podcast listener demographics General tasks include but are not limited to: - Purchase or obtain the said mailing list - Verify the authenticity and relevance of the list - Ensure data privacy and ethical sourcing are strictly adhered to.

...system that can take data from the existing Excel files and convert them into customized PDF reports. Key Points: - The primary data source is existing Excel files. This means you need to have the ability to efficiently extract and interpret data from these files. - The PDF reports need to be customized with personalized data fields. So, you should be able to dynamically merge data from Excel into the PDF reports. - Proficiency in PDF generation tools and Excel data manipulation is essential. Your responsibilities will include: - Developing a system that can accurately generate customized PDF reports using data from Excel files. - Ensuring that the system is user-friendly and can be easily ado...

I want to build anything which enables me to send customized whatsapp message as well as images from excel sheets

I want to get a extension which can send messages and images from whatsapp web using numbers and other data from excel sheet

Here is a list of 35000 phone numbers. I need the american country code, +1, added to each entry. There is a way on excel to do this pretty quickly, I just dont know if, hoping you do.

I have an Excel data set that encompasses 5-10 sheets. I need support in: - Data entry: Entering new information into the existing sheets. - Data cleaning: Checking and correcting any errors in the data, removing redundancies. - Data analysis: Conducting basic analysis of data. Ideal applicants should have beginner proficiency in these tasks. Your experience working with Excel data files, especially handling entry, cleaning, and analysis tasks, will greatly benefit this project.

I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfa...

I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.

I'm in need of a professional proficient in Excel and data entry to support two key tasks: data analysis and spreadsheet management. Here are the tasks in detail: - Data Analysis & Visualization: I've collected customer feedback data which need to be efficiently analysed and visualized. - Spreadsheet Creation & Management: The data mentioned above should be incorporated into comprehensible spreadsheets. In terms of analysis, the focus should be on customer segmentation. Ideal candidates should have: - Advanced proficiency in Excel for data analysis and visualization - Strong understanding of data cleaning and formatting to ensure accurate analysis - Experience with customer segmentation based on feedbac...