How to filter a csv file in excelJobs

I urgently need a proficient Excel specialist to assist with the creation and formatting of spreadsheets. Key responsibilities include: - Spreadsheet Creation: Develop new Excel sheets to efficiently manage data. - Data Cleaning and Formatting: Ensure that entered data is accurate, organized, and as per a specific format for easy understanding. Your meticulous attention to detail and expertise in Excel data entry will be critical in this role. The volume of data to be handled is unclear at this moment, as this aspect was not specified. Please prepare to handle both small and large batches of data. This project is time-sensitive and completion at the earliest would be appreciated.

I have a detailed list of 45 requirements that need to be implemented into an Excel report. The primary goal of this report is data analysis. Key Responsibilities: - Implement 45 requirements into an Excel report - Ensure all requirements are met accurately - Optimize the report for effective data analysis The ideal candidate should have: - Proficiency in Python - Experience working with Excel - Strong understanding of data analysis - Proficiency in Pandas and NumPy If you have experience with similar projects and are confident in your ability to provide thorough, accurate work, please submit your proposal.

I am looking for an expert in Microsoft Excel to develop a tool to track changes between two Excel sheets. Key requirements include: - The ability to identify and track both text and numeric data changes between two sheets. - The tool should not only monitor existing data, but also be built to manage changes related to data newly added in future. - Changes identified need to be grouped and clearly displayed in a separate tab within the same workbook for ease of review. Skills and Experience: - Proficient in Microsoft Excel - Background in data analysis - Experience in creating custom Excel tools - Strong attention to detail in order to i...

I am in need of a competent networking engineer with a background in C/C++ to help me design and implement a fresh networking solution. I need someone who can code our algorithm in computer network. The aim is to display the company/lab network infrastructure using the provided connections and device details Excel sheet, so the goal is to build a C/C++ code that displays a layer-2 diagram which represents all types of connectivity within the lab.

I need to implement a custom button in Salesforce. When users click the button, I want it to prompt users to upload a file. The process should be as follows: 1. **File Upload and Dropdown**: - Upon clicking the button, users should be prompted to upload a file. - Before the upload, users should see a dropdown with options for the type of document they are uploading. These options should be easily configurable by me in the future. 2. **File Renaming**: - Once the user has uploaded the file and selected the document type from the dropdown, the file should be renamed. - The new filename should be a combination of the account name followed by the dropdown selection. 3....

I have a data entry project that requires manual entry from physical documents into Excel. Specifically, I need you to: - Accurately transcribe the data from physical documents into Excel - Include custom charts and graphical representations to visually communicate the data. Ideal skills for this project include: - Proficiency in Excel, especially in data entry and creating visual representations - Attention to detail for accurate transcription of data from physical documents to digital format. Your work should not only be precise in data entry but also visually appealing and easy to comprehend, with the use of appropriate charts and graphical representations.

Hello, We need assistance with creating a WooCommerce search filter using ACF fields: Combined search field for Product & SKU Category selection Input fields for Length, Width, Height Optional tolerance specification in cm When can you start and how long will it take? We are open to using paid plugins. Please start your reply with your proposed timeline and start with "2024" to confirm you've read everything. Thanks!

I'd like to hire a skilled professional to convert a CSV file into Shopify product format. The main goal of this task is to migrate our existing products from another platform to Shopify. Please note that the CSV data will require some optimization before it can be uploaded. The specific area that needs work is image optimization. A keen eye for detail and prior experience with Shopify and image optimization is highly necessary for successful completion of this project. check the files here:

I'm seeking a proficient data scraper to extract text content from a targeted website. Ideal Skills - * Expertise in web scraping technologies * Keen attention to detail to ensure data accuracy * Strong communication skills to understand my specific needs. Unfortunately, I neglected to specify how I would like the data to be formatted, so please ensure you can offer several options such as CSV, JSON, and Excel files. I didn't provide a timeline as well, however, we can discuss about your availability and agree on a flexible deadline. Kindly submit your proposal with relevant experience and estimated time of completion.

I'm seeking a skilled personal assistant to support my dual role as an orthodontist and entrepreneur. The ideal candidate will streamline my operations and allow me to concentrate on patient care and business growth. Key duties include: Lab Order Oversight: Efficient tracking and logging of lab orders. Financial Tracking: Manage invoices and chase payments diligently. Photo Cataloging: Securely organize patient photos for easy access. Account Checks: Perform daily account audits for financial integrity. Clinic Setup: Oversee the logistics of new clinic establishments. Regulatory Liaison: Manage necessary government interactions. Appointment Monitoring: Accurately track patient treatment plans. Task Prioritization: Ability to discern and address task...

I require professional assistance with data entry. More specifically, the task involves typing information from digital documents, such as PDFs, Word files, and Excel spreadsheets, into an Excel spreadsheet. The ideal freelancer for this job is proficient in data entry and is highly skilled in using Excel.-Accuracy and attention to detail are key skills that would make this project a success.

I'm seeking a skilled personal assistant to support my dual role as an orthodontist and entrepreneur. The ideal candidate will streamline my operations and allow me to concentrate on patient care and business growth. Key duties include: Lab Order Oversight: Efficient tracking and logging of lab orders. Financial Tracking: Manage invoices and chase payments diligently. Photo Cataloging: Securely organize patient photos for easy access. Account Checks: Perform daily account audits for financial integrity. Clinic Setup: Oversee the logistics of new clinic establishments. Regulatory Liaison: Manage necessary government interactions. Appointment Monitoring: Accurately track patient treatment plans. Task Prioritization: Ability to discern and address task...

I am seeking a competent web crawling specialist who can efficiently extract text content from a specific website's news updates. Here’s what I require: • Extract information from news updates within the target website. • Save the extracted data in Excel format. • Deliver clean, organized, and structured data. Ideal skills and experience: • Expertise in web crawling and scraping tools. • Previous experience working with news or media websites. • Proficiency in data extraction and Excel. • Strong attention to details. I appreciate a freelancer who can show some examples of their previous data extraction projects, especially in a news context.

I'm in need of an Excel expert to Create Macros. I have two spreadsheets. On each spreadsheet i have an input form. When the form has been entered and the user clicks "Enter Asset" each of the filled out cells (as per the File - "Template Code Functions") should be transferred to the "Data Collection Spreadsheet". Just enter into the next unused row. When the asset has been added successfully the cells marked as "Yes" as per the "template code functions" for "Reset on data entry" shall be empty on the input form. There are two spreadsheets, they are slightly different from each other.

I need a professional to create an advanced Excel-based sales forecasting model. This model will integrate data on sales volume, revenue, and customer demographics, across various time periods - monthly, quarterly, and yearly. Key requirements: - Incorporate Sales Volume, Revenue, and Customer Demographics - Develop the model for Monthly, Quarterly, and Yearly forecasting - Integrate and track Gross Profit Margin, Conversion Rate, and Average Order Value as key metrics Ideal Skills & Experience: - Advanced Excel Proficiency - Proven track record in Sales Forecasting - Experience with Power BI for data visualization - Strong understanding of Gross Profit Margin, Conversion Rate, and Average Order Value in a sales context This project ...

I need a comprehensive statistical analysis of my survey data using descriptive statistics, and I'd like the results presented in visually engaging charts and graphs. Your main tool for this should be Microsoft Excel. Key Responsibilities: - Perform a detailed descriptive statistical analysis of my survey data. - Translate the findings into easy-to-understand charts and graphs. - Ensure all the visualizations are created using Microsoft Excel. Ideal Skills and Experience: - Proficiency in statistical analysis, particularly in descriptive statistics. - Strong experience in creating visual representations of data through charts and graphs. - Expertise in using Microsoft Excel for data visualization. - Ability...

Key features must be: User Registration/Login Search Bar Product Listings Price Comparison Engine Filter and Sorting Options Product Details Wish List/Save for Later Price Alerts User Reviews and Ratings Secure Payment Integration User Profiles Notifications Barcode/QR Code Scanner Multi-platform Support Analytics Dashboard (for Admin) Customer Support Social Sharing Location-based Services Offline Access Customizable Alerts and Preferences Loyalty/Rewards Program Integration Accessibility Features Data Privacy and Security Feedback Mechanism Admin Panel Third-party Integrations

I need a skilled Excel expert to create a comprehensive spreadsheet and optimize its formulas and functions. The project needs to be completed within a month. Key Tasks: - **Spreadsheet Creation**: The successful freelancer will be responsible for creating a detailed spreadsheet that will serve as a part search tool. - **Formula and Function Optimization**: I need assistance in optimizing the formulas and functions within the spreadsheet. This is to ensure the tool is efficient, accurate and user-friendly. I would like to have a new parts search screen made up similar to the one attached ( Storeroom Parts Locator. ) but using the attached excel sheet (inventory Report) Nice UI on front pag...

About the Role: A renowned leader in digital security is actively seeking a skilled Golang Developer for a contract role focused on developing a Golang agent for SSL certificate management, which will interface with a PHP API. This opportunity is ideal for back-end development professionals who excel in automation, system operations, and delivering high-quality outcomes in a remote environment. Project Overview: As a Golang Developer, you will be instrumental in: - Developing a Golang agent to manage SSL certificate lifecycles, interfacing with a PHP API. - Implementing features such as system monitoring, logging, and robust error handling. - Performing thorough testing and optimizati...

I'm looking for a Python developer to help me extract various types of data - text, numerical, and images from a website. This is a one-time job that involves extracting these different types of data, not just one or the other. Ideal Skills and Experience: - Proficiency in Python - Web scraping experience - Ability to extract and handle various types of data, including text, numerical, and images The preferred form of delivery would be to added the extracted data directly to a table if you can't do it then we can consider csv file as well.

Need an accounting and valuation expert with good excel skills.

...that can process a provided Excel file and display the data in various ways. Key Features: - The app should be able to read the Excel file I provide. - It should show the numeric data per line and column as specified in the Excel. - It should also be able to perform statistical analysis on the data. - The app should provide graphical representation of the data. Users should be able to interact with the data within the application in a 'view only' mode. Ideal Skills: - Proficient in Android app development - Experience with Excel data processing - Ability to implement statistical analysis in an app - Familiarity with graphical representation in mobi...

I'm in need of someone who can create a simple JPEG in a 2:3 (portrait) including the attached info on hoeg not excel format. The design style should predominantly be green and favor a minimalist approach. THIS IS FOR THE WEBSITE Key Responsibilities: - Creating a JPEG media card design. - Utilizing a 2:3 (portrait) layout. - Integrating a predominantly green color scheme. - Implementing a minimalist style. Ideal Skills: - Proficient in graphic design. - Prior experience with media card layouts. - In-depth knowledge of color theory. - Advanced user of design software (Adobe Suite, etc.) - Understanding of minimalist design principles. Please include samples of prior work, especially with media...

I need help downloading the "Longitudinal Behavior Modeling Dataset" from for conducting research analysis. Key Requirements: - Download the "Longitudinal Behavior Modeling Dataset" in CSV format from the provided URL. - No specific preprocessing or analysis tools are required for this project. Ideal Freelancer: - Experience in data downloading and handling. - Proficiency in accessing and managing data from online repositories. - Knowledge of how to effectively convert and save data in CSV format.

...are seeking a skilled freelancer to collect, structure, and analyze historical data from space missions. The goal is to build a comprehensive dataset that can be used to evaluate past mission trajectories, orbital maneuvers, burn times, and other relevant parameters. This dataset will not only help identify potential areas of improvement for past missions but also aid in developing sophisticated software for future space mission planning. This software will leverage machine learning to predict and optimize mission outcomes. Task Objectives: 0. Data sourcing. Find sources. Sources of this data could include NASA, ESA, Roscosmos, and other space agencies' official databases, academic journals, and verified public datasets. Create summ...

I have an excel SS that I need some quick formula help with. No VBA please. Table with expenses, then another table dividing up. I need the expense categories divided over months as per quantaty of time it is used. Explained in the SS attached. I need this done ASAP. Your responsibilities: - Understand the project financials and structure the Excel to match - Create a Gantt style tallies that captures my project expenses effectively Skills and Experience: - Solid expertise in advanced Excel functions - Experience in financial tracking, preferably in project management - Ability to work fast and deliver quickly Note: I didn't specify the expense categories so it should be customizable to accommodate any ...

I am personally seeking assistance to build a concise list of influencers within the fitness and food niche on YouTube. These influencers should predominantly be located in North America and Europe, hence familiarity with these regions will be beneficial. The main requirement is for influencers who have a medium-sized audience, specifically between 500k to 1 million subscribers, thus demonstrating they have a significant, though not overwhelming reach. Skills in data collection, an understanding of YouTube's platform, and perhaps previous experience working with influencer marketing or advertising would be ideal for this role. Check out the csv file attached below

I'm looking for an individual proficient in data entry, email management, online research, and making phone calls. Your daily tasks will primarily involve: - Performing data entry tasks using Microsoft Excel - Managing email communications effectively and promptly - Conducting online research as required - Making certain phone calls when necessary -Schedule is 9am-3pm CST (Monday-Friday) In addition, experience with project management software 'Click Up' will be highly favored. A strong work ethic, attention to detail, and excellent communication skills are fundamental for this role. The selected candidate will be expected to perform these tasks on a daily basis. Your ability to meet deadlines and work independently w...

I need a excel data sheet typist frequent in basic as well as skillful skills. There's no error in the formats and also professionally done with great effort.

Hey! I have experties on statistical analysis.

We are looking for a freelancer to scrape product information from Website and organize it in an Excel spreadsheet. Key Requirements: - The script should extract all text content and images displayed on the homepage need be add to excel file

Create an executable scraper in Python that can extract the SKU (product) list from the following Indonesian online grocery apps: - Astro - Sayurbox - Segari The scraper must be IP-block tolerant, meaning if the scraper gets blocked, execution can be continued from the point where the last row of data was successfully extracted. Scraper Functions Function: list_category_tree Input: competitor_name(astro | sayurbox | segari), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocompl...

I'm in need of a high-converting landing page to drive Google Ads traffic for my roof replacement business. The primary goal of the page is to generate leads in the form of phone calls and form submissions. Key Requirements: - The landing page should be designed to encourage visitors to either call my business directly or fill out a form to enquire about a roof replacement. - The form should collect the visitor's name, phone number, email address, and details about their project. - Particular attention should be paid to encouraging visitors to provide details about their project, including project location and current roof condition. These details are crucial for me to provide accurate qu...

...configurators in one system. A separate configurator for each product. 2. Only display configurator after entering a customer number. Configuration is not possible without a customer number. 3. Use customer number to recognise which configurators / products are available. 4. Do not display prices on the website, no direct sales. 5. The preview image of the product should be constantly updated depending on the configuration. 6. After completing the configuration, no order should be created in the system, but an offer should be created automatically as an Excel file, which is not sent to the customer, but to the office sales department, which checks the offer and can see which parts have been added, so that prices are a...

IA-calculated Excel Sheet Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor Invoice Excel Template Vender List, Client List , Purchase order , Quotation & Invoice Log Excel Purchase Order Generator and Tracke...

Read a JML/JSON (see the example) file created by Selenium IDE and save it into an Access Database (.mdb) Requirements: 1) The application is a Windows desktop application 2) Development language: C# .NET latest version 3) The application will be called ImportBotJob 4) The application must include all of the components to run on a PC without Office installed.

I need an expert in iMacros scripting who can scrape data from a specific website for me, Website 1. Here's what I'm after: - Data-specific scraping: I'm not after user profiles or product listings, I'm particularly interested in data scraping from this website. - CSV output: I'd like the scraped data to be formatted and delivered in a CSV file for easy use and analysis. The ideal candidate for this project would have: - Significant experience with iMacros scripting - Proven track record in web data scraping - Expertise in CSV data formatting and delivery I look forward to seeing your bids and discussing the project further.

I'm looking for a proficient web developer with experience in Joomla and Hikashop to customize the invoice sheet layout of my website. The sheet should be working for both languages of website in the specific language and should be easily printable by siteadmin to be attached to the package( .csv / or xml?) Your tasks will include: - Modifying the layout of the invoice sheet, specifically the header arrangement, footer items, and body contents. - Customizing the header of the invoice sheet as per provided example. The ideal candidate will not only have a solid understanding of Joomla and Hikashop, but will also be adept at translating my vision into a user-friendly interface. If you possess these skills and think you...

...looking for a freelancer to create an Excel dashboard that will be linked to a Microsoft PowerApp. The dashboard will be used for monitoring various data points. Key Details: - The dashboard will need to be dynamic and allow for updates directly from a database. - The successful freelancer will need to demonstrate experience in creating similar solutions in the past and provide a detailed project proposal for this task. The ideal candidate will have: - Proficiency in Excel, particularly in the creation of dynamic dashboards. - Experience with database connectivity and management. - Previous work examples that showcase their ability to create effective and user-friendly solutions. ...

I have a medium-sized Excel dataset that needs to be cleaned and analyzed. The tasks include formatting cells, filtering, and sorting data. Moreover, I'm looking for a professional who can conduct statistical analysis on this dataset. Key tasks: - Formatting cells: This involves making sure that the data is presented in a readable and visually appealing format. - Filtering and sorting: The freelancer should be able to organize the data in a way that makes it easy to understand and analyze. - Statistical analysis: The dataset needs to be analyzed statistically. This means that the freelancer should be proficient in statistical tools and techniques. Ideal candidate: - Proficient in Excel:...

In need of a detailed-oriented freelancer for an alphanumeric data entry project using information sourced through online research. Key Responsibilities: - Source relevant information using online research methodologies - Accurately input alphanumeric data into a system - Ensure the final data is properly structured and error-free The final data should be delivered in an Excel spreadsheet format. Ideal Skills: - Experience with online research tools - Proficient in Excel - Fast typing skills - High attention to detail - Previous experience in alphanumeric data entry roles. The success of the project will be measured by the accuracy of inputted data. Proven examples of prior work in a similar data entr...

I'm in need of a skilled PHP and MySQL programmer to handle a two-part project. Firstly, the MySQL database requires a series of updates, including the addition of new data fields, the modification of existing ones, and the removal of obsolete fields. Moreover, the database as a whole will need updating. The second part of the project involves the development of a front-end interface for this database. The interface must feature a user authentication and login mechanism, as well as an intuitive search and filter system. Key Requirements: - Proficient in PHP and MySQL - Experienced in updating and maintaining MySQL databases - Skilled in crafting user-friendly front-end interfaces - Ability to...

I am in need of a sharp and detail-oriented freelancer to assist me in a unique data entry task. Your primary responsibility will be to find pictures that correspond to specific words, and organize them in an Excel database. This project is crucial for the development of a comprehensive picture-based database. Key Responsibilities: - Search for images that match specific words - Organize the found images in an Excel database Ideal Skills and Experience: - Proficiency in using Excel for data entry - Strong attention to detail - Ability to efficiently find and match images - Prior experience working with picture databases would be a plus Please ensure that the images you ...

I'm looking for a PowerBI expert to set up a dashboard for our construction project. This dashboard should pull data from Excel spreadsheets and provide valuable insights into our construction progress. Key Requirements: - Integrating Excel Spreadsheets: The primary data source for this project will be Excel spreadsheets. Your ability to connect and visualize data from this source is vital. - Construction Progress Monitoring: The dashboard's main focus should be on monitoring our construction progress. This includes: - Project Timeline: Displaying where we stand in terms of project timeline against the planned schedule. - Budget Utilization: Visualizing how the budget is being utilized in real-time. - R...

I'm looking for a professional freelancer to convert a 300-line PDF bank statement into an Excel report for reporting purposes. The specific bank statement details that need to be included are Date and Description as well as Debit and Credit amounts. Key Requirements: - Extract date and description details from the bank statement - Extract Debit and Credit amounts from the bank statement - Must have a clear understanding of date formatting in Excel Ideal Skills/Experience: - Must have extensive experience in data entry and Excel - Should have a good understanding of banking terms - Attention to detail is critical - Previous experience in bank statement conversion will be advantageous.

We are looking to collect the current prices for 5 specific procedures from local clinics. We need a call center to call 200 dental clinics from a list that we have already created to inquire about pricing. You will be calling as if you are an interested patient inquiring about getting the procedure. You will then fill out the 5 procedure costs on the excel sheet. We are hoping to hire a call center that speaks English with minimal accent. We have a general script. Each phone call should not last more than a few minutes. You need to have more multiple people on your team as we would like this project done very quickly. You also must be able to call from a US based phone number and have it show up ...

I'm looking for someone proficient in Excel to assist with data entry and basic data analysis. Requirements: - The task involves entering numerical data into an Excel sheet. - The data is for both analysis and record-keeping, so accuracy is crucial. - I also need some basic Excel functions applied to the data, particularly summation and averages. Skills & Experience: - Proficient in Excel with experience in data entry - Knowledge of basic Excel functions (sums, averages) - Attention to detail for accurate record-keeping - Some experience with data analysis would be a plus Looking forward to your bids. Thank you.

...this Job. I am looking for a freelancer to help me set up my Ecommerce Google Merchant Centre , clean and prepare and optimise our csv product feed and setup a Google Shopping/PMax campaign. Platform: - My ecommerce website is built on a CMS called , so experience with this platform is preferred. Google Merchant Center: - I already have a Google Merchant Center account set up, so the freelancer should be familiar with this platform. * Setup Correct conversion tracking for ecommerce on GA4 and integrate into Google Ads. Shopping/PMax Campaign: - I do not have a specific budget for my campaign, but I am open to suggestions from the freelancer. - The freelancer should have experience in setting up and managing Shopping/PM...

I'm in need of a skilled professional who can adeptly handle both copywriting and Excel data analysis tasks. For this project, the copywriting will need to be informative in nature. Aim it towards industry professionals, with the intent of providing detailed information in an engaging, digestible format, not advertising or branding. Excel expertise should include, but not be limited to, proficient data analysis capabilities to make sense of complex datasets. Ideal skills for the job: - Proven experience in copywriting, specifically informative writing. - Strong knowledge of Excel, particularly in the field of data analysis. - Ability to communicate complex information in an understandabl...

I'm seeking an individual proficient in Excel, with significant experience specifically in entering statistical data. The task revolves around efficiently and accurately typing numbers into an Excel sheet, which will then be processed for statistical analysis. Key Responsibilities: - Accurately input numerical data into Excel - Familiarity with statistical data is advantageous - Format inserted numbers as percentages Ideally, the individual will have stellar attention to detail, the ability to work under tight deadlines, and a strong grasp of handling statistical data. Prior experience in a similar role will definitely give you an edge.