How to filter a csv file in excel jobs

I'm in need of a sophisticated product that can pull and analyze employee training data from multiple Excel files. The main purpose of this tracker is to keenly observe and report on the completion status of various training areas. Any training that remains incomplete should be fed into another excel tab. That tab should incorporate the following information: - Employee's Names - Incomplete training There should be another tab where a user is able to input a first and last name and generate the training status of any single employee. The data will come from multiple .csv or .xlsx files in a designated folder with designated file names. Freelancers with expertise in data management, exte...

I'm seeking a highly skilled freelancer to assist with data processing tasks. Key Responsibilities: - Process various data efficiently Please note, the source of the data to be processed is unspecified at this point. Timeline: - There is no strict deadline for project completion. However, a sense of urgency is appreciated Ideal Skills: - Solid data processing capabilities - Prompt delivery and high-level accuracy - Exceptional problem-solving skills Experience in the data entry field If you think this project aligns with your skills, I'd love to hear from you.

I'm in need of creating a CSV static file like this i will host own own server. csv data can be same as on its a csv file and shows as text when on browser. This project doesn't require any dynamic data manipulation or other data formats apart from CSV. Check the link for the type of file I want to create. Please bid if you have these skills.

Creation of a real estate acquisition model including Cash flow, tenancy schedule, lease modeling and renewal assumptions, IRR, levered and unleverred. Including formula to play with the model.

I have multiple Excel files that require thorough cleaning. The data inconsistencies that I need addressed include duplicates, formatting errors, and incorrect entries. There's also a need for merging, splitting, and conditional formatting. Ideal candidates for this project should be proficient with Excel and have experience in data cleaning. They should also be adept at identifying and solving data-related issues. Ultimately, I need all duplicate entries to be removed from these files. • SKILLS REQUIRED: - Proficiency in Excel - Experience in data cleaning - Ability to merge and split data - Familiarity with conditional formatting

...seeking a capable professional who can scrape and deliver details of Third Party Administrator (TPA) Companies. This project mainly focuses on lead generation and I'm not strictly adamant about timelines. Although the specific data fields are undetermined, I will rely on your expertise to guide me on what's most crucial for effective lead generation. Others have indicated that things like the company's name and email, address and contact number, or company size and industry can be extremely valuable. I am open to these suggestions, and perhaps a few others. Ideal Skills include: - Web data extraction: Ability to utilise scraping tools to efficiently gather information. - Lead Generation: Experience in generating business...

...seeking a talented graphic designer to create a captivating social media flyer for our online course. The course targets individuals aged 15-25 and course name is Data analysis with MS Excel Requirements: 1. Design must be visually appealing, professional, and in line with our brand identity. 2. The post should include engaging visuals and concise, compelling copy to capture the audience's attention. 3. Dimensions: WhatsApp status, WhatsApp post, Instagram 4. Incorporate relevant course details such as course name, key benefits, and a call-to-action (e.g., "Enroll Now"). 5. Use our brand color pallette 6. Provide the design in a high-resolution format suitable for social media posting. Deliverables:...

I require a comprehensive spreadsheet created that compares four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the following aspects: - Fees - Number of transactions closed - Average price point - Stock options - Agent attraction For the 'number of transactions closed', I wish to use a preset value for each brokerage. Moreover, I want the 'fees' data structure to be tiered. Candidates with excellent Excel skills are preferred. It's also beneficial if you have a good understanding of real estate brokerage fees and structures. Attention to detail is essential as the spreadsheet needs to allow for a deep and thorough analysis.

I require expertise in extracting purchase details from text-based PDF attachments in my Outlook emails and compiling this data in an excel sheet. Key tasks: - Set up a platform that automatically imports data from new email attachments - Extract purchase details from these attachments - Place this data into an Excel sheet accurately. Skills and Experience: - Proficient in Microsoft Outlook and Excel. - Knowledge of data extraction from text-based PDFs. - Automation experience, ability to set up a system that triggers upon receipt of a new email. - High attention to detail required. - Previous work in data extraction or related fields is a plus.

I need a freelancer with proficiency in data input, specifically text data into CSV files. The project involves: - Entering less than 1000 rows of text data into a CSV file. - Ensuring accuracy and precision in every entry. - Maintaining confidentiality of the data. Skills Required: - Proficient in using CSV files - Superb attention to detail - Conversant in English to understand text data Experience: - Proven track record in data input jobs. - Experience with CSV files will be given preference. This project is straightforward and requires high attention to detail and precision.

I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub

I need a meticulous person with a keen eye for detail to hunt down and manually input contact details from an event's website into an Excel file. Key Responsibilities: - Collect the data fields: Name, Email, Phone Number, Company and Sector from the website. - Store data in an organized manner in a .xls Excel file. Ideal Candidate: - Someone with experience in manual data entry - Attention to detail, as accuracy is of utmost importance - Please provide examples of past work demonstrating your data entry skills I look forward to seeing your applications and choosing the best fit for this job. Remember, past experience counts!

Hi, I need to extract data and images from product pages into an Excel file. Here is an example link - Video showing it - ATTACHED FILE is the format it needs to go into so I can import it into WooCommerce Product name All images Price About this product Details Variations: color, size, etc

removing lines that contain a word from all txt files in a directory build in c#

I am in need of a versatile and functional web application that allows users to pay various utility bills - specifically for electricity, water, and internet services. This application should be designed with user-friendly features, easy payment options, and a clear interface. Key functionalities to integrate: - Payment processing: The application should be designed to facilitate simple, secure, and swift payments. Compatibility with various payment methods, including credit/debit cards and e-wallets, is crucial. - Utility bill categorization: There should be distinct sections or categories for electricity, water, and internet services. This organization will make it easier for users to navigate the application and make their payments. -...

I require a meticulous and detail-oriented freelancer to concentrate specifically on the following for an unspecified number of Excel files and bank statements: - Date Formats: Ensure all dates are consistent - Transaction Types: Verification and correction of all transaction types - Narrative Consistency: Ascertain uniformity in transaction narratives Ideal skills for the job would include extensive proofreading experience and in-depth knowledge of Excel data and bank statements. Any examples of past work or detailed project proposals you could include in your application would be beneficial. Please be prepared to dive into a project of an undefined size, as the number of Excel files and bank statements has not been...

I'm seeking a skilled graphic designer who can develop a series of medium-sized, flat design styled icons for our digital courses. These courses encompass topics including Excel, PowerPoint, MS Project, and Power BI. The icons should follow the style of the ones we already have for our HSE (Health, Safety, and Environment) courses, maintaining consistency across our course offerings. Ideal Skills and Experience: - Proven experience in designing intuitive and visually appealing icons - Proficient in Adobe Illustrator - Strong understanding of flat design principles - Prior work on digital content or courseware would be a bonus - Familiarity with Excel, PowerPoint, MS Project, and Power BI for context-oriented design. Requirements: - M...

Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but ...

...looking for someone skilled in creating a conversion tool. This tool will specifically convert PDF files to CSV format. Requirements: - The tool should extract text data, tables, and images from the PDF files. - It should ensure accurate conversion, maintaining the original layout and formatting as much as possible. The initial task is to convert less than 10 PDF files, with the potential for more in the future. Ideal Skills: - Experience in data conversion between PDF and CSV files - Proficiency in any programming language that is capable of creating said tool - Attention to detail to ensure high-quality conversions - Good problem-solving skills to navigate potential issues during conversion. Bid...

I'm seeking a freelancer proficient at data entry for impending tasks. The job involves entering both numerical and textual data. Details: - You will need to enter a mixture of numeric and textual data. - Accuracy is crucial to ensure the quality of data entry. - The finalized data should be provided in an Excel spreadsheet. Skills and Experience: - Proficient in data entry. - Strong attention to detail. - Experience using and formatting Excel spreadsheets.

I have two excel files. In the file, I want you to color code cells from B2:E2 to the end of the columns with text as either green, yellow, orange, red for how closely the text in one cell matches in another. Green - perfect or near perfect match Yellow - most of it is good Orange - less than 70% match Red - poor match or no match I roughly counted there are about 2000 cells.

I'm looking to hire someone proficient with Excel to reconstruct a spreadsheet using a template that I will provide. The new version should replicate the original as closely as possible, without any added functionalities. Key requirements: - The spreadsheet should have exactly the same type of data as the original one. - You will not need to incorporate functionalities such as formulas, calculations, data validation or conditional formatting as they were skipped in the requirements. I want to ensure that my project is in good hands, therefore, your experience is crucial to me. During your application, kindly detail relevant experiences you've had recreating or working with spreadsheet templates. Looking fo...

I am seeking an Excel expert who can provide in-person training on ‘Budgeting and profit and loss projections’ for one person. I already has an intermediate understanding of Excel and we need further training on: - Basic Excel Functions: The trainer would be expected to reiterate on the basic functions to ensure a strong foundation for the subsequent practical sessions. - Creating Formulas: The ability to create and manage formulas is the next skill we wish to hone. This includes all the necessary functions to perform complex calculations for our projects. The spreadsheet has already been created, it needs to be corrected a little but can be explained further in the training session. T...

...require a meticulous and professional proofreader, well-versed in Japanese, to refine four not-safe-for-work (NSFW) landing pages. My timeline is tight, and I expect the task to be completed within the next 24 hours. Key Requirements: - Exceptional command of the Japanese language. - Ability to adhere to an informal style. - Focused enhancement of readability and flow without altering the core message. - Prior experience with adult content is preferable but not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Jap...

Hi there! I'm Sourabh Dhos a detail-oriented individual with a knack for data entry. I thrive in fast-paced environments where accuracy is key. Proficient in ( Excel,ms word,I ensure data integrity while meeting deadlines.

HI Eyo, are you ok/still around.? EA you helped long time ago I want to get started testing it and add indicator filter. EA has fault, if trade open that goes negative pips the partial close of 50% is executed when 1 bar bar closes. The SL of new 50% is then incorrect. It should stay as a fixed value SL and not partial close when negative. (Add 10) Add indicator logic filter too. I have code. (and/or) Code, still bit messy. If interested let me know before I post publicly Warm wishes, Kevin

Looking for an individual to accurately transfer numerical information and tables from PDF to Excel. Previous experience in data entry will be advantageous. Ideal skills and qualifications: - Beginner level experience in data entry or similar roles - Proficient in Microsoft Excel - Excellent attention to detail - Ability to interpret and analyze data Example attached.

I am in need of an experienced data handler to effectively mine critical information from two specific websites- and Sportsbet.com.au. What's key is your ability to adeptly navigate through these sites, isolate and then scrape pricing information only. A successful bid will involve scraping this data on demand, when I initiate the web scraper to start, and neatly compiling the results in either .xls or .csv file. Ideal Skills: - Expertise in web scraping - Attention to detail and accuracy - Knowledge in handling and processing data - Experience working with .xls and .csv formats.

The aim is to build a comprehensive business plan for my IT Service, consulting technology-based business. The key purpose is to attract investment. To this end, I need a professional who can effectively portray my business and future prospects through this plan. Key Requirements: - Incorporation of financial projections for more than 5 years into an Excel sheet. - Strong understanding of the technology service industry. - Experience in developing business plans specifically for investment purposes. Skills and Experience: - Excellent financial modeling skills. - Profound knowledge of the technology industry. - Experience in preparing business plans for fundraising purposes. - Proficiency in Excel. By effectively po...

Hello, I am glad to submit the proposal as follows: Development of module for computing the relative distance between teacher and the student and storing the same in csv file along with the results of previous work. Experimentation will be performed using few videos. Thanks.

I'm looking for a RPA software specialist who can create a macro for the Google Chrome browser. The main task will be to automate the process of downloading PDF files. The desired macro should: - Navigate to a specific URL - Download all PDFs - This includes navigating to the next page(s) until all PDFs downloaded. Do not use the "All" link, use the "Next page" link. The macro should do the downloads page by page. The page URL is All this can be done with the free version of Ui.Vision. Screenshot attached. We need this macro within the next days. So please only bid if you can work on this now. In your bid, please mention "This week". Sorry about that, we need that filter to avoid all ...

I'm searching for an individual specialized in data mining and web scraping who can help me extract specific product information from an e-commerce website. Key Responsibilities: - Locate and extract specified data from the selected e-commerce site - Ensure collected data is reliable and structured properly Ideal Candidate: - Has in-depth knowledge in Web Scraping and Data Mining - Is familiar and proficient with Excel as the required output format is an Excel file This project aims to support a larger market research initiative, thus accuracy and attention to detail is critical. Only professionals with proven experience in similar projects need apply.

I'm experiencing an issue with my pbix file. Despite the fact that my data is neatly structured on a single worksheet with multiple tables in Excel, it is not refreshing in the pbix file when expected. Given the nature of this problem, it's clear that an expertise in data management with Excel and Power BI is necessary for this project. Proficiency in troubleshooting Power BI related issues is also a must. The primary tasks will include: - Analyzing the pbix file and the associated Excel worksheet - Pinpointing the cause behind the failure to refresh data - Implementing a fix to ensure smooth data refresh in the future The preferred freelancer should be experienced ...

I will order the full configuration and implementation of Algolia search engine in an online store. It is to work as an overlay-window when the search box is clicked. The data is prepared in a .csv file or available in pimcore.

I need an expert in web scraping to help gather daily energy data from an energy provider website. The specific data to focus on includes: - Energy consumption statistics. The software can take input parameters such as ip adress, username, password and some filter parameters and also must have the ability to issue bulk queries Ideal skills and experience for this job are: - Website scraping expertise - Familiarity with energy data - Knowledge of Excel. This could become a long-term project for the right freelancer if the information is accurate and timely.

I have a specific goal for this project, which involves web scraping and organizing data into a comprehensive Excel spreadsheet database of UK care homes. The work scope includes: - Extracting contact details (both phone numbers and emails) of each care home - Categorizing the extracted data based on care home location The ideal freelancer for this job should hold the following skills and experience: - Proficient in web scraping - Knowledge of categorizing or sorting data - Excel spreadsheet expertise Accuracy and attention to detail is crucial in this task. This project is suitable for individuals who have previously demonstrated efficiency and success in similar roles. Resource could be

...work with the Amazon API to produce a solution for retrieving specific order details and implementing real-time updates in stock values. Notable tasks include: - Fetching Customer name/address, product information, and quantity details from Amazon orders, and presenting in CSV format. - Ensuring the API sends back the tracking information to Amazon, including Carrier name, shipping method, and the associated tracking number. -Updating stock values to Amazon on a daily/regular basis An experienced developer who has worked with Amazon's API previously is a must. Familiarity with CSV data and order tracking systems is also highly desirable. A solution designed for efficiency and accuracy in retriev...

...am looking to automate and streamline my operations. Primarily, I need a skilled Python developer to integrate the Angel Smart API with Microsoft Excel. Areas of concern include: - Developing data retrieval and analysis functionality: This involves retrieving and analyzing stock prices. - Option chain data management: I am specifically looking for functionalities like real-time option chain data retrieval, historical option chain data retrieval, and sophisticated analysis and visualization of the gathered data. - Creating an automated reporting system: In order to keep track of market conditions, an automated system for generating reports is essential. The ideal candidate should be expert in Python, comfortable with Excel, and...

I need the Tecdoc 2023 3Q or 4Q in sql format and the pictures. or the same data as CSV plus pictures.

...scope of contest. I require a skilled professional in Excel to develop an automated dashboard for my business. The system will need to manage data entry, data analysis, and reporting - all automated. Key tasks will include: - Setting up a dashboard connected to Excel files with automation functionality. - Automating cleaning up and processing of data for analysis. - Developing reports with automatic generation feature. Regarding data visualization, the dashboard should be capable of generating pie charts, line graphs, and bar graphs as per the data analyzed. You should be proficient in Excel and familiar with data visualization techniques. Experience in automation and connecting Excel with other data...

I'm seeking a proficient data specialist who can successfully convert a CSV file into an XLSX Excel format. This conversion needs to be done meticulously to ensure optimal usability for sharing data with others. Key responsibilities will include: - Converting a CSV file into an XLSX format - Checking data integrity post-conversion - Ensuring the final layout is easy to understand and use for sharing with others The ideal freelancer for this job has extensive experience with Microsoft Excel and, more specifically, with CSV to Excel conversions. This is a one-off project, but I'm interested in a flawless output. Accuracy and meticulous attention to...

...require a meticulous and professional proofreader, well-versed in Italian, to refine four not-safe-for-work (NSFW) landing pages. My timeline is tight, and I expect the task to be completed within the next 24 hours. Key Requirements: - Exceptional command of the Dutch language. - Ability to adhere to an informal style. - Focused enhancement of readability and flow without altering the core message. - Prior experience with adult content is preferable but not mandatory. Ideal Candidate: - Proven track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Dutch. ...

I have a requirement for an advanced Excel specialist to develop a structured Gantt chart. More details will be provided to shortlisted candidates.

Please Sign Up or Login to see details.

Hi, we have a ready box mock up for e-bay. We would like to create the thousand of boxes via a csv file or something like that. The texts/ pictures numerated from 1-11 are dynamic and change with each box. You can find our ready design as a psd (I will provide you with a link as its too big to upload here) and attached also the file with picture of the dynamic parts 1-11. For any questions feel free to contact me.

I am in need of an Excel operator to assist with data entry tasks. Ideal candidates would have extensive experience in Excel and be confident in their data entry abilities. Skills and Requirements: - Proficient in Excel data entry - Attention to detail - Experience with Excel formulas is a plus Application Details: Applicants should include their Excel experience details in their application. Please provide information about past related work, specifically focusing on data entry tasks in Excel. Tasks to be Performed: - Input various data points into Excel spreadsheet accurately - Handle high volumes of data entry - Maintain the integrity and accuracy of the data If th...

I need a Python developer to create an efficient application for Windows that can effectively download and print files, most likely PDFs, from the Collabora Online Development edition system. This application should be able to not only handle a single file at a time but also manage multiple files simultaneously. Ideal Skills and Experience: - Proficient in Python programming language - Knowledge of Collabora online development environment - Experience in developing applications for Windows - Familiarity with file handling and printing functionality Main Responsibilities: - Create an application to override download and print protections - Ensure the application can handle both one file and multiple files simu...

I require a skillful developer to create a React Native, hybrid application that's intuitive and operates smoothly on both Android and iOS platforms. The key focus of the app is to stimulate user engagement. As specifics for features and functionalities are currently undefined, your creative input is welcomed. Ideally, you should have: • Proficiency in hybrid mobile app development, MERN stack • Background in creating apps geared at maximizing user interaction • Ability to suggest and implement features for enhanced engagement. Near to Accurate requirements are mentioned below : Create Article from Wordpress Add Categories for article add filter for categories OTP free tier required add notification and al...

I'm seeking a professional to aid in matching and synchronizing our prices with various online retailers. This project involves working with data that is currently in CSV file formats. Key Project Tasks: - Correctly map, match and sync our data with the corresponding data from online retailers. - Implement synchronization to ensure updated accurate price comparison. Ideal Skills & Experience: - It's essential to have a background in data synchronization and comparison. - Fluency in managing and manipulating CSV files. - Experience working with online retail pricing data is a significant plus. Through this project, synchronization of our data with online retailers will be ach...

I need a web application developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and...