Macros to search for data in excel jobs

I need an Excel professional to help me clean up my data. Specifically, I'm looking for someone who can assist with text and number formatting. Key tasks include, but are not limited to: - Data cleanup, focusing on text and number formatting - Ensuring the data is well-structured for its intended use - Delivering the formatted data in a different file format than the original Excel file Ideal candidates should have: - Proficiency in Excel and its various functions - Prior experience in data cleanup and formatting - Attention to detail and commitment to quality - Strong communication skills, as you may need to clarify certain aspects of the data. Plea...

We are looking for a programmer to create the search engine for our magento 2.4.6 with Proto Theme website using Algolia search. The programmer has to implement the algolia search engine using his own code following the guidelines published by Aloglia to use it in the main page and in the search results page. It must include the following Filtering by attributes ( brands, specific attributes, color, etc) Keyword filtering Filtering by categories The search results should be displayed in a js block on the home page and in the search results. The theme used in magento 2.4.3 is "Fatest by codazon". Please only serious people, we don't want people who spend hal...

...issues with Google Search Console and I need an expert to help me resolve them. Key tasks involved: - Fixing Indexing Issues: There are some pages on my site that aren't being indexed properly by Google. This could be due to various reasons like crawling errors, server problems, etc. - Resolving Sitemap Errors: I've been receiving errors related to the sitemap of my website. This could be contributing to the indexing problems. - Addressing Mobile Usability Issues: Google has flagged some mobile usability issues on my site. I want to ensure my website is fully mobile-friendly and complies with Google's guidelines. Ideal Skills and Experience: - Strong understanding of Google Search Console: You should have a deep understa...

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please n...

I'm in the process of starting an enterprise and seeking a skilled website designer and technical SEO specialist. The purpose of the website is to provide information about this new business. It should be beautifully designed, user-friendly, and effectively present our business details, mission, and services. As for the SEO, emphasis is on technical aspects. Your job would entail ensuring the structure of our site is search-engine friendly and meets all backend requirements for optimal ranking. Ideal skills and experience: - Expert in website design, preferably with portfolio of business sites - Proficient in Technical SEO with a good understanding of backend website requirements for optimal search engine ran...

Hello, I need complet the Amazon categories catalogue excel in french

...goal is to have a complete informational website developed for my business. With a focus on offering key details like: - About Us: A section devoted to explaining our business and its values - Services: A clear and comprehensive listing of all our services - Contact Information: Clear details on how customers can contact us; including phone number, email address, and physical location - Pricing: Transparent pricing information for our services The ideal freelancer for this project should have prior experience in developing informational websites with an easy to navigate user interface. Proficiency in web design and development and a keen eye for detail is necessary. Knowledge of SEO to help maximize the visibili...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Exce...

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in...

My Wordpress site has some issues. Also a lot error alerts in Google search console need expert to fix that

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

...skilled freelance developer with expertise in crafting seamless experiences across mobile and web platforms? We're seeking a talented individual to collaborate with us on an exciting project to develop a modern and user-friendly job search platform. Key Functionalities: - User Registration and Profile Management: Enable users to create, manage, and update their profiles to streamline the job search process. - Real-Time Messaging: Facilitate communication between job seekers and employers through real-time messaging functionality. - Advanced Search and Filtering: Empower users to discover relevant job listings based on specific criteria such as location, industry, and job type. - Subscription-Based Fees: Implement a fl...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm in need of a Virtual Admin Assistant to help me manage my daily work. Our dailly working time is : 10 - 7pm. We are in retail industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experie...

...looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing comprehensive plans that can be used for obtaining necessary permits. Your understanding of local building codes and regulations will significantly contribute to the project's success. - Ensuring these detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a stro...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

One of our clients is looking for a literature search with a view to searching the Pubmed database using the inclusion and exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-d...

Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook ...

I am looking for a skilled Google Ads expert to help me run an effective campaign. - Ideal candidate will have expertise in all areas of Google Ads: Search, Display, and Video Campaigns. - The primary goal of this campaign is to increase website traffic. - The target audience for these campaigns is yet to be determined. The successful candidate should be able to provide insights on the target audience and develop a strategy that can effectively drive traffic to my website. You should be able to propose a campaign that can provide measurable results. The ideal candidate should have a proven track record of managing successful Google Ads campaigns, ideally for clients with similar goals.

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

...specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth kno...

...freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add anothe...

I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related ...

We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding o...

...a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is...

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of...

I'm currently in need of an AI Engineer, specifically experienced with Python, to resolve some issues related to our RAG architecture and vector similarity search. Here's a general overview of the project: - Troubleshoot and resolve issues in the RAG architecture - Enhance the efficiency of the existing vector similarity search - Implement suitable solutions for seamless integration with other systems Ideal candidates should have: - Strong background in AI and experience with Python - Prior experience with RAG architecture and vector similarity search - Excellent problem-solving and troubleshooting skills - Good communication and ability to work in a team Your contribution will be crucial to the...

need someone to do keyword research for low competition keywords for a small channel with high search results. my niche is in the entertainment space. so any videos entertaining in the entertainment space is fine. it needs to be based in the united states as well

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

I am in need of a document management software that will be compatible with Windows& Mac. This software is intended for use by business professionals, so it should be user-friendly, efficient, and secure. Key Features: - The software should include a document scanning feature, making it easier for users to transfer physical documents into the digital realm. - It should also offer a filing system that is organized and intuitive, ensuring that users can easily locate and retrieve the documents they need. I require a freelancer who has experience in developing document management software, particularly for Windows. The software should be designed to handle a large volume of documents while maintaining high performance. A strong unders...

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dos...

We're seeking an experienced developer company to help upgrade a state-of-the art startup MEMBERSHIP PLATFORM; website, iOS & Android apps, and admin panel. **OVERVIEW** The framework is built in versions that are several years old. For example Node JS 7.10.0 and MySQL 5.7.0. Everything needs to be updated to highest stable version that offers support and packages. For Node.Js that will likely be version 18 or 20 Moreover, this project offers an excellent opportunity for more development. **QUOTE: UPGRADE** -Please provide a quote for upgrade of website, iOS & Android apps, and admin panel. -The Framework described below. -Specify team size and roles. -Time frame for completion. **PLATFORM FRAMEWORK ...

...developer to integrate an open-source search function, like Elastic Search or Solr, into my application. The app's search utility must be optimized to suggest relevant products to the user based on input, even for spelling errors. For example, when searching for "Poma", it should suggest "Puma", "Puma shoes", or "Puma Tshirts". Details about the project: - The search index size would be small, accommodating less than 10,000 items. - It will focus on product search within the application. - The search results need to be sorted by relevance for better user preferences. Ideal Skills and Experience: - Proven track record of implementing and optim...

I am in need of an Internet search executive residing in Iraq, with strong proficiency in Kurdish and Arabic, for an engaging project. The ideal candidate should possess the following qualifications: - Proficiency in Google and social media scanning - Excellent English communication skills - Experience in conducting keyword research - Ability to perform data collection and analysis While I have not specified an industry or topic for focus, the candidate should be versatile and adapt to various subject matters. Your role will primarily involve conducting internet-based research, including keyword research and data collection and analysis. To succeed, you should be proficient in Kurdish and ...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I'm in need of a thorough background check of a potential employee in Malaysia. This requires searching for and providing information on criminal convictions, arrests, and sentences. Key Requirements: - Check for Convictions, Arrests, and Sentences: The primary aim of this screening is to uncover any past criminal activities of the candidate. - National Level Records: The search should focus only on national level records. The findings will be used for: - Employment Screening: The purpose of this check is to evaluate the potential risks posed by the candidate and make a well-informed hiring decision based on the facts presented. Ideal Candidate: - Experience: A background in legal work, law enforcement, or private inv...

I am looking for a skilled freelancer to help convert 12 simple floor plans into editable layouts suitable for creating evacuation maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel...

...your offer with the word in the attachment, otherwise we dropp you out. We are looking for a database with websites, HAVING EMBEDDED YOUTUBE Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. Wi...

...proven track record in the real estate industry, particularly focusing on residential properties. As someone who knows how important SEO plays in the organic growth and visibility of a website, I expect you to employ top-notch strategies in improving my website's reach and visibility. Your tasks will include: - Increasing the organic traffic on my website, - Enhancing my website's search engine rankings, - Driving up conversion rates on-site, - Working on online reputation management by removing any negative comments. Ideal candidates should have: - Specialized experience in SEO for real estate, most notably residential properties. - The ability to implement effective SEO strategies for real estate. - A tra...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

I'm looking for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to...